| Caché | |
|---|---|
| Developer | InterSystems Corporation |
| Latest release | 2007.1 |
| OS | multiple |
| Genre | database management and application development |
| Website | InterSystems.com/Cache |
InterSystems Caché is an object database management system from InterSystems Corporation. It provides object and SQL access to the database, as well as allowing direct manipulation of Caché’s underlying data structures. Caché runs on Windows, Unix, Mac OS X and OpenVMS platforms. The company claims Caché is the world’s fastest database. Internally, Caché stores data in multidimensional arrays capable of carrying hierarchically structured data. These are the same “global” data structures used in M technology, and very similar to those used by MultiValue (aka PICK) systems. In most applications, however, object and/or SQL access methods are used. Caché ObjectScript, Caché Basic or T-SQL can be used to develop application business logic. External interfaces include native object binding for C++, Java, EJB, ActiveX, and .NET. Caché supports JDBC and ODBC for relational access. XML and Web Services are also supported. Caché Server Pages technology allows tag-based creation of Web applications that dynamically generate Web pages, typically using data from a Caché database. Caché also includes InterSystems Zen, an implementation of AJAX that enables component-based development of Rich Internet Applications. The notable customers of this DBMS are top US hospitals, who run their EMR systems on Caché, financial institutions like Ameritrade and Sungard, and others including IBM, BT, and Vodacom.
Competitors
The main competitors are vendors of relational database such as DB2 from IBM, MS-SQL from Microsoft, and Oracle.
External links
- http://www.intersystems.com/
- Searchable Caché documentation
- cachemonitor.de - free SQL Query and Admin Tool for Caché
- Caché Wiki
|
|
|
|---|---|
| Database models · Database normalization · Database storage · Distributed DBMS · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Transaction processing | |
| Concepts | Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key |
| Objects | Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition |
| SQL | Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter |
| Implementations | Relational · Flat file · Deductive · Dimensional · Hierarchical · Network · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores |
| Components | Concurrency control · Query language · Query optimizer · Query plan · ODBC · JDBC |
| Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented | |


