Caché (software)
Encyclopedia
InterSystems Caché is a commercial 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. 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 hospitals, who use it to run their electronic medical record
systems; financial institutions like Sungard; and others including Epic, IBM
, BT
, and Vodacom
.
programming language in which Caché is implemented, 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.
from IBM
, Sybase
from SAP
, MS-SQL from Microsoft
, MySQL
, Oracle
, and Oracle's Hyperion Solutions
Essbase
.
Database management system
A database management system is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators and other specialists. A database is an integrated...
from InterSystems Corporation
InterSystems
InterSystems Corporation is a privately held vendor of software for high-performance database management, rapid application development, integration, and healthcare information systems...
. It provides object
Object (computer science)
In computer science, an object is any entity that can be manipulated by the commands of a programming language, such as a value, variable, function, or data structure...
and SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
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. Caché runs on Windows
Microsoft Windows
Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
, Linux
Linux
Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
, Sun Solaris
Solaris Operating System
Solaris is a Unix operating system originally developed by Sun Microsystems. It superseded their earlier SunOS in 1993. Oracle Solaris, as it is now known, has been owned by Oracle Corporation since Oracle's acquisition of Sun in January 2010....
, HP-UX
HP-UX
HP-UX is Hewlett-Packard's proprietary implementation of the Unix operating system, based on UNIX System V and first released in 1984...
, Tru64 UNIX
Tru64 UNIX
Tru64 UNIX is a 64-bit UNIX operating system for the Alpha instruction set architecture , currently owned by Hewlett-Packard . Previously, Tru64 UNIX was a product of Compaq, and before that, Digital Equipment Corporation , where it was known as Digital UNIX .As its original name suggests, Tru64...
, AIX, Mac OS X
Mac OS X
Mac OS X is a series of Unix-based operating systems and graphical user interfaces developed, marketed, and sold by Apple Inc. Since 2002, has been included with all new Macintosh computer systems...
and OpenVMS
OpenVMS
OpenVMS , previously known as VAX-11/VMS, VAX/VMS or VMS, is a computer server operating system that runs on VAX, Alpha and Itanium-based families of computers. Contrary to what its name suggests, OpenVMS is not open source software; however, the source listings are available for purchase...
platforms (old, still supported versions of Caché, also run on Data General AViiON and SCO UnixWare
UnixWare
UnixWare is a Unix operating system maintained by The SCO Group . UnixWare is typically deployed as a server rather than desktop. Binary distributions of UnixWare are available for x86 architecture computers. It was originally released by Univel, a jointly owned venture of AT&T's Unix System...
).
Notable customers of this DBMS are many hospitals, who use it to run their electronic medical record
Electronic medical record
An electronic medical record is a computerized medical record created in an organization that delivers care, such as a hospital or physician's office...
systems; financial institutions like Sungard; and others including Epic, IBM
IBM
International Business Machines Corporation or IBM is an American multinational technology and consulting corporation headquartered in Armonk, New York, United States. IBM manufactures and sells computer hardware and software, and it offers infrastructure, hosting and consulting services in areas...
, BT
BT Group
BT Group plc is a global telecommunications services company headquartered in London, United Kingdom. It is one of the largest telecommunications services companies in the world and has operations in more than 170 countries. Through its BT Global Services division it is a major supplier of...
, and Vodacom
Vodacom
Vodacom is a pan-African mobile telecommunications company, and was the 1st cellular network in South Africa. It provides GSM service to more than 35 million customers in South Africa, Tanzania, Lesotho, Mozambique and the Democratic Republic of the Congo. Revenue for the year ended 31 March 2008...
.
Architecture
Internally, Caché stores data in multidimensional arrays capable of carrying hierarchically structured data. These are the same “global” data structures used by the MUMPSMUMPS
MUMPS , or alternatively M, is a programming language created in the late 1960s, originally for use in the healthcare industry. It was designed for the production of multi-user database-driven applications...
programming language in which Caché is implemented, and are similar to those used by MultiValue
MultiValue
MultiValue is a type of multidimensional database, typically considered synonymous with PICK, a database originally developed as the Pick operating system....
(aka PICK) systems. In most applications, however, object
Object (computer science)
In computer science, an object is any entity that can be manipulated by the commands of a programming language, such as a value, variable, function, or data structure...
and/or SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
access methods are used.
Caché ObjectScript
Caché ObjectScript
Caché ObjectScript is a part of the Caché database system sold by Intersystems Corp. The language is a functional superset of the ANSI-standard M programming language. MUMPS programmers can run existing MUMPS routines under Caché with little or no change...
, Caché Basic
Caché Basic
Caché Basic is an object-oriented scripting language designed for development of web-based database applications. Developers familiar with Visual Basic will not find it too difficult to develop applications using Caché Basic....
or T-SQL can be used to develop application business logic. External interfaces include native object binding for C++
C++
C++ is a statically typed, free-form, multi-paradigm, compiled, general-purpose programming language. It is regarded as an intermediate-level language, as it comprises a combination of both high-level and low-level language features. It was developed by Bjarne Stroustrup starting in 1979 at Bell...
, Java, EJB, ActiveX
ActiveX
ActiveX is a framework for defining reusable software components in a programming language-independent way. Software applications can then be composed from one or more of these components in order to provide their functionality....
, and .NET
.NET Framework
The .NET Framework is a software framework that runs primarily on Microsoft Windows. It includes a large library and supports several programming languages which allows language interoperability...
. Caché supports JDBC and ODBC for relational access. XML
XML
Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards....
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
Ajax
- Mythology :* Ajax , son of Telamon, ruler of Salamis and a hero in the Trojan War, also known as "Ajax the Great"* Ajax the Lesser, son of Oileus, ruler of Locris and the leader of the Locrian contingent during the Trojan War.- People :...
that enables component-based development of Rich Internet Applications.
Competitors
The main competitors are vendors of relational databases such as DB2IBM DB2
The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions...
from IBM
IBM
International Business Machines Corporation or IBM is an American multinational technology and consulting corporation headquartered in Armonk, New York, United States. IBM manufactures and sells computer hardware and software, and it offers infrastructure, hosting and consulting services in areas...
, Sybase
Sybase
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....
from SAP
SAP AG
SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software...
, MS-SQL from Microsoft
Microsoft
Microsoft Corporation is an American public multinational corporation headquartered in Redmond, Washington, USA that develops, manufactures, licenses, and supports a wide range of products and services predominantly related to computing through its various product divisions...
, MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
, Oracle
Oracle database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
, and Oracle's Hyperion Solutions
Hyperion Solutions
Hyperion Solutions Corporation was a business performance management software company, located in Santa Clara, California, USA, which was acquired by Oracle Corporation in 2007...
Essbase
Essbase
Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998...
.
External links
- InterSystems
- [ftp://ftp.intersystems.com/ InterSystems FTP site]
- Caché Newsgroup (via Google Groups)
- InterSystems Caché download Free, non-expiring, fully functional evaluation version of Caché
- InterSystems' Caché documentation site
- Searchable Caché documentation