InterSystems Caché ( ) is a commercial operational

database management system In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases span ...

from

InterSystems InterSystems Corporation is a privately held vendor of software systems and technology for high-performance database management, rapid application development, integration, and healthcare information systems. The vendor's products includInterS ...

, 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 MUMPS ("Massachusetts General Hospital Utility Multi-Programming System"), or M, is an imperative, high-level programming language with an integrated transaction processing key–value database. It was originally developed at Massachusetts Gener ...

Description

Internally, Caché stores data in multidimensional arrays capable of carrying hierarchically structured data. These are the same “global” data structures used by the

MUMPS MUMPS ("Massachusetts General Hospital Utility Multi-Programming System"), or M, is an imperative, high-level programming language with an integrated transaction processing key–value database. It was originally developed at Massachusetts Gen ...

programming language, which influenced the design of Caché, and are similar to those used by MultiValue (also known as PICK) systems. In most applications, however, object and/or SQL access methods are used. Caché ObjectScript,

Caché Basic Cache, caching, or caché may refer to: Places United States * Cache, Idaho, an unincorporated community * Cache, Illinois, an unincorporated community * Cache, Oklahoma, a city in Comanche County * Cache, Utah, Cache County, Utah * Cache County, ...

or T-SQL can be used to develop application business logic. External interfaces include native

object binding Several object binding times exist in object oriented systems. Java, for example, has late binding leading to more loosely coupled systems (at least for deployment Deployment may refer to: Engineering and software Concepts * Blue-green depl ...

for C++,

Java Java (; id, Jawa, ; jv, ꦗꦮ; su, ) is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea to the north. With a population of 151.6 million people, Java is the world's mo ...

EJB Jakarta Enterprise Beans (EJB; formerly Enterprise JavaBeans) is one of several Java APIs for modular construction of enterprise software. EJB is a server-side software component that encapsulates business logic of an application. An EJB web co ...

ActiveX ActiveX is a deprecated software framework created by Microsoft that adapts its earlier Component Object Model (COM) and Object Linking and Embedding (OLE) technologies for content downloaded from a network, particularly from the World Wide Web. ...

, and .NET. Caché supports JDBC and

ODBC In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. A ...

for relational access.

XML Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing arbitrary data. It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. ...

and web services are also supported. Caché Server Pages (CSP) technology allows tag-based creation of

web application A web application (or web app) is application software that is accessed using a web browser. Web applications are delivered on the World Wide Web to users with an active network connection. History In earlier computing models like client-serve ...

s that generate dynamic web pages, typically using data from a Caché database. Caché also includes InterSystems Zen, an implementation of

AJAX Ajax may refer to: Greek mythology and tragedy * Ajax the Great, a Greek mythological hero, son of King Telamon and Periboea * Ajax the Lesser, a Greek mythological hero, son of Oileus, the king of Locris * ''Ajax'' (play), by the ancient Gree ...

that enables component-based development of

rich web application A rich web application (originally called a rich Internet application, or RIA or installable Internet application) is a web application that has many of the characteristics of desktop application software. The concept is closely related to a sing ...

History

InterSystems was founded in 1979 to commercialize

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

Market

InterSystems claims Caché is the world's fastest

object database An object database or object-oriented database is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object databases are different from relational databases which are ...

. However, high performance is achieved only for transactional operations that have a significantly hierarchical nature. This database management system (DBMS) is used as part of hospital patient tracking,

electronic medical record An electronic health record (EHR) is the systematized collection of patient and population electronically stored health information in a digital format. These records can be shared across different health care settings. Records are shared throu ...

and medicine management systems, in products developed by companies such as

Epic Systems Epic Systems Corporation, or Epic, is an American privately held healthcare software company. According to the company, hospitals that use its software held medical records of 78% of patients in the United States and over 3% of patients worldwi ...

as well as the VistA system used by the U.S. Department of Veteran Affairs. Sungard includes Caché in the AddVantage

asset management Asset management is a systematic approach to the governance and realization of value from the things that a group or entity is responsible for, over their whole life cycles. It may apply both to tangible assets (physical objects such as buildings ...

software to finance industry customers such as banks. Telecommunications vendors

BT Group BT Group plc ( trading as BT and formerly British Telecom) is a British multinational telecommunications holding company headquartered in London, England. It has operations in around 180 countries and is the largest provider of fixed-line, bro ...

and

Vodacom Vodacom Group Limited is a South-Western African mobile communications company, providing voice, messaging, data and converged services to over 55 million customers. From its roots in South Africa, Vodacom has grown its operations to include ...

also use Caché. The DB-Engines website has ranked Caché as the most popular object-oriented DBMS every month since March 2013.

Platforms

Caché runs on

Windows Windows is a group of several proprietary graphical operating system families developed and marketed by Microsoft. Each family caters to a certain sector of the computing industry. For example, Windows NT for consumers, Windows Server for ...

Linux Linux ( or ) is a family of open-source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991, by Linus Torvalds. Linux is typically packaged as a Linux distribution, which i ...

, Solaris,

HP-UX HP-UX (from "Hewlett Packard Unix") is Hewlett Packard Enterprise's proprietary implementation of the Unix operating system, based on Unix System V (initially System III) and first released in 1984. Current versions support HPE Integrit ...

, AIX,

macOS macOS (; previously OS X and originally Mac OS X) is a Unix operating system developed and marketed by Apple Inc. since 2001. It is the primary operating system for Apple's Mac (computer), Mac computers. Within the market of ...

and

OpenVMS OpenVMS, often referred to as just VMS, is a multi-user, multiprocessing and virtual memory-based operating system. It is designed to support time-sharing, batch processing, transaction processing and workstation applications. Customers using Ope ...

platforms.

References

External links