Jump to content

InterSystems Caché: Difference between revisions

From Wikipedia, the free encyclopedia
Content deleted Content added
they only claim it's the fastest OBJECT database specifically, not the fastest database in general.
Jtbwikiman (talk | contribs)
m Market: Redlink
 
(148 intermediate revisions by 88 users not shown)
Line 1: Line 1:
{{third-party|date=December 2018}}
{{Infobox Software
{{Infobox software
|name = Caché
|developer = InterSystems Corporation
|name = InterSystems Caché
|developer = [[InterSystems]]
|latest_release_version = 2008.2
|latest_release_version = 2018.1.4
|latest_release_date = October 24, 2008
|latest_release_date = {{Start date and age|2020|05|17}}
|operating_system = multiple
|operating_system = multiple
|released = {{Start date and age|1997|df=no}}
|genre = database management and application development
|genre = database management and application development
|license = [[Proprietary software|Proprietary]]
|website = [http://www.InterSystems.com/Cache/ InterSystems.com/Cache]
|website = [http://www.intersystems.com/cache InterSystems.com]
}}
}}


'''InterSystems Caché''' ({{IPAc-en|k|æ|ʃ|eɪ}} {{respell|kashay}}) 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 (computer science)|object]] and [[SQL]] code. Caché also allows developers to directly manipulate its underlying data structures: hierarchical arrays known as [[M technology]].
'''InterSystems Caché''' is an object [[database management system]] from [[InterSystems|InterSystems Corporation]]. It provides [[Object (computer science)|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 [http://www.intersystems.com/cache/index.html]. Caché runs on [[Microsoft Windows|Windows]], [[Linux]], [[Solaris_operating_system|Sun Solaris]], [[HP-UX]], [[Tru64_UNIX|Tru64 UNIX]], [[AIX]], [[Mac OS X]] and [[OpenVMS]] platforms (old, still supported versions of Caché, also run on [[Aviion|Data General Aviion]] and [[UnixWare|SCO UnixWare]]).


==Description==
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 Systems|Epic]], [[IBM]], [[BT Group|BT]], and [[Vodacom]].
{{unreferenced section|date=July 2019}}
Internally, Caché stores data in [[multidimensional array]]s capable of carrying [[hierarchical database model|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 most{{How many|date=August 2014}} applications, however, [[Object (computer science)|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 programming language|Java]], [[EJB]], [[ActiveX]], and [[.NET Framework|.NET]]. Caché supports [[JDBC]] and [[ODBC]] for relational access. [[XML]] and [[web service]]s are also supported.
== 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 (computer science)|object]] and/or [[SQL]] access methods are used.


Caché Server Pages (CSP) technology allows [[tag-based language|tag-based]] creation of [[web application]]s that generate [[dynamic web page]]s, typically using data from a Caché database. Caché also includes InterSystems Zen, an implementation of [[AJAX]] that enables component-based development of [[rich web application]]s.
[[Caché ObjectScript]], [[Caché Basic]] or [[T-SQL]] can be used to develop application business logic. External interfaces include native object binding for [[C++]], [[Java programming language|Java]], [[EJB]], [[ActiveX]], and [[.NET Framework|.NET]]. Caché supports [[JDBC]] and [[ODBC]] for relational access. [[XML]] and [[Web Services]] are also supported.


==History==
[[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.
{{expand section|date=August 2014}}
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>{{Cite web|url=http://www.intersystems.com/who-we-are/our-passion/#company-milestones|title=Our Passion: Company milestones|access-date=August 5, 2014}}</ref>


== Competitors ==
==Market==
InterSystems claims Caché is the world's fastest [[object database]].<ref>{{cite web | url = http://www.intersystems.com/cache/index.html | title = InterSystems Caché – World's fastest database | publisher = [[InterSystems]] | access-date = February 24, 2009}}</ref> However, high performance is achieved only for transactional operations that have a significantly hierarchical nature.{{citation needed|date=August 2014}}
The main competitors are vendors of relational databases such as [[IBM_DB2|DB2]] from [[IBM]], [[MS-SQL]] from [[Microsoft]], [[MySQL]], [[oracle database|Oracle]], and Oracle's [[Hyperion_Solutions]] [[Essbase]].


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>{{cite web | url = http://www.intersystems.com/casestudies/by-industry.html | title = Case studies – By Industry | publisher = [[InterSystems]] | access-date = March 28, 2011}}</ref> [[Sungard]] includes Caché in the AddVantage [[asset management]] software to finance industry customers such as banks.<ref>{{cite web|author=InterSystems|title=SunGard’s AddVantage Exceeds Performance Benchmarks|url=http://www.intersystems.com/who-we-are/newsroom/news-item/sungards-addvantage-exceeds-performance-benchmarks/|date=June 19, 2002|access-date=August 5, 2014}}</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>
==External links==
*[http://www.intersystems.com/ InterSystems]
*[ftp://ftp.intersystems.com/ InterSystems FTP site]
*[http://groups.google.com/group/intersystems-public-cache/topics/ Caché Newsgroup](via Google Groups)
*[http://download.intersystems.com/download InterSystems Caché download] Free, non-expiring, fully-functional evaluation version of Caché
*[http://docs.intersystems.com/ InterSystems' Caché documentation site] HTML and .pdf docs for Caché v4.1 -> current release
*[http://www.nlm.cz/search Searchable Caché documentation]
*[http://www.cachemonitor.de cachemonitor.de] - free SQL Query and Admin Tool for Caché
*[http://www.cachewiki.org/index.php/Cach%C3%A9_Wiki Caché Wiki]
*[http://www.cache-hosting.com/ Caché Hosting] - Mutual web hosting solutions for Caché Web Applications


The [[DB-Engines ranking|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>{{cite web | url = https://db-engines.com/en/ranking_trend/object+oriented+dbms | title = Trend of Object Oriented DBMS Popularity
{{databases}}
| publisher = DB-Engines | access-date = May 12, 2024}}</ref>


==Platforms==
[[Category:Database management systems]]
Caché runs on [[Microsoft Windows|Windows]], [[Linux]], [[Solaris (operating system)|Solaris]], [[HP-UX]], [[AIX]], [[macOS]] and [[OpenVMS]] platforms.


==See also==
[[GT.M]], a related database system


==References==
{{database-software-stub}}
<references />


{{DEFAULTSORT:InterSystems Cache}}
[[de:Caché (Datenbank)]]
[[Category:Relational database management systems]]
[[it:Caché]]
[[Category:Object-oriented database management systems]]
[[ja:Caché]]
[[Category:Proprietary database management systems]]
[[nl:Caché]]
[[Category:MUMPS implementations]]
[[pt:Caché]]
[[ru:Caché (СУБД)]]

Latest revision as of 17:34, 21 August 2024

InterSystems Caché
Developer(s)InterSystems
Initial release1997; 27 years ago (1997)
Stable release
2018.1.4 / May 17, 2020; 4 years ago (2020-05-17)
Operating systemmultiple
Typedatabase management and application development
LicenseProprietary
WebsiteInterSystems.com

InterSystems Caché (/kæʃ/ kashay) 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.

Description

[edit]

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 most[quantify] 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.

History

[edit]

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.[1]

Market

[edit]

InterSystems claims Caché is the world's fastest object database.[2] However, high performance is achieved only for transactional operations that have a significantly hierarchical nature.[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.[3] Sungard includes Caché in the AddVantage asset management software to finance industry customers such as banks.[4] Telecommunications vendors BT Group and Vodacom also use Caché.[5]

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.[6]

Platforms

[edit]

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

See also

[edit]

GT.M, a related database system

References

[edit]
  1. ^ "Our Passion: Company milestones". Retrieved August 5, 2014.
  2. ^ "InterSystems Caché – World's fastest database". InterSystems. Retrieved February 24, 2009.
  3. ^ "Case studies – By Industry". InterSystems. Retrieved March 28, 2011.
  4. ^ InterSystems (June 19, 2002). "SunGard's AddVantage Exceeds Performance Benchmarks". Retrieved August 5, 2014.
  5. ^ Interystems case study: Vodacom. http://www.intersystems.fr/page/fr/case_study_vodacom
  6. ^ "Trend of Object Oriented DBMS Popularity". DB-Engines. Retrieved May 12, 2024.