Jump to content

InterSystems Caché

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by 192.112.251.48 (talk) at 21:17, 4 February 2009 (Competitors: changing link to hyperion). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Caché
Developer(s)InterSystems Corporation
Stable release
2008.2 / October 24, 2008
Operating systemmultiple
Typedatabase management and application development
WebsiteInterSystems.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.