InterSystems Caché

Revision as of 19:52, 28 January 2025 by imported>Discospinster (Reverted edit by Sardarnasir67 (talk) to last version by Jtbwikiman)
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

Template:Third-party {{#invoke:Infobox|infobox}}Template:Template other{{#invoke:Check for unknown parameters | check | showblankpositional=1 | unknown = Template:Main other | preview = Page using Template:Infobox software with unknown parameter "_VALUE_"|ignoreblank=y | AsOf | author | background | bodystyle | caption | collapsetext | collapsible | developer | discontinued | engine | engines | genre | included with | language | language count | language footnote | latest preview date | latest preview version | latest release date | latest release version | latest_preview_date | latest_preview_version | latest_release_date | latest_release_version | licence | license | logo | logo alt | logo caption | logo upright | logo size | logo title | logo_alt | logo_caption | logo_upright | logo_size | logo_title | middleware | module | name | operating system | operating_system | other_names | platform | programming language | programming_language | released | replaced_by | replaces | repo | screenshot | screenshot alt | screenshot upright | screenshot size | screenshot title | screenshot_alt | screenshot_upright | screenshot_size | screenshot_title | service_name | size | standard | title | ver layout | website | qid }}Template:Main other

InterSystems Caché (Template:IPAc-en Template:Respell) is a commercial operational database management system 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.

DescriptionEdit

{{ safesubst:#invoke:Unsubst||date=__DATE__ |$B= {{ safesubst:#invoke:Unsubst||date=__DATE__ |$B= Template:Ambox }} }} 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 (also known as PICK) systems. In mostTemplate:How many applications, however, object and/or SQL access methods are used.

Caché ObjectScript, Caché Basic or 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 generate dynamic 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 web applications.

HistoryEdit

Template:Expand section 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.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>

MarketEdit

InterSystems claims Caché is the world's fastest object database.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> However, high performance is achieved only for transactional operations that have a significantly hierarchical nature.Template:Citation needed

This database management system (DBMS) is used as part of hospital patient tracking, electronic medical record and medicine management systems, in products developed by companies such as Epic Systems as well as the VistA system used by the U.S. Department of Veteran Affairs.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> Sungard includes Caché in the AddVantage asset management software to finance industry customers such as banks.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref> Telecommunications vendors BT Group and Vodacom also use Caché.<ref>Interystems case study: Vodacom. http://www.intersystems.fr/page/fr/case_study_vodacom</ref>

The DB-Engines website ranked Caché as the most popular object-oriented DBMS every month from March 2013 to January 2023, when it was overtaken by InterSystems IRIS Data Platform.<ref>{{#invoke:citation/CS1|citation |CitationClass=web }}</ref>

PlatformsEdit

Caché runs on Windows, Linux, Solaris, HP-UX, AIX, macOS and OpenVMS platforms.

See alsoEdit

GT.M, a related database system

ReferencesEdit

<references />