InterSystems Caché
Developer(s) | InterSystems Corporation |
---|---|
Stable release | 2008.2
/ October 24, 2008 |
Operating system | multiple |
Type | 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. The company claims Caché is the world’s fastest object database [1]. Caché runs on Windows, Linux, Sun Solaris, HP-UX, Tru64 UNIX, AIX, Mac OS X and OpenVMS platforms (old, still supported versions of Caché, also run on Data General Aviion and SCO UnixWare).
Notable customers of this DBMS are many US hospitals, who run their Electronic Medical Record systems using Caché, financial institutions like Ameritrade and Sungard, and others including Epic, IBM, BT, and Vodacom.
Architecture
Internally, Caché stores data in multidimensional arrays capable of carrying hierarchically structured data. These are the same “global” data structures used by the MUMPS database language, and are 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.
Competitors
The main competitors are vendors of relational databases such as DB2 from IBM, MS-SQL from Microsoft, MySQL, Oracle, and Oracle's Hyperion_Solutions Essbase.
External links
- InterSystems
- InterSystems FTP site
- Caché Newsgroup(via Google Groups)
- InterSystems Caché download Free, non-expiring, fully-functional evaluation version of Caché
- InterSystems' Caché documentation site HTML and .pdf docs for Caché v4.1 -> current release
- Searchable Caché documentation
- cachemonitor.de - free SQL Query and Admin Tool for Caché
- Caché Wiki
- Caché Hosting - Mutual web hosting solutions for Caché Web Applications