InterSystems Caché

InterSystems Caché is a commercial operational DBMS from InterSystems, used to develop software applications for healthcare management, banking and financial services, government, and other sectors. Customer software can use the database with object and SQL code. Caché also allows developers to directly manipulate its underlying data structures: hierarchical arrays known as M technology.

Internally, Caché stores data in multidimensional arrays capable of carrying hierarchically structured data. These are the same “global” data structures used by the MUMPS programming language, which influenced the design of Caché, 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 (CSP) 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.

InterSystems was founded in 1979 to commercialize MUMPS hierarchical databases. It launched Caché in 1997 as its flagship product and at that time ceased further development of its original MUMPS product line..