Intersystem Cache — High Performence and Operations DBMS

Ponnumani Gurusamy
2 min readNov 18, 2019

About Intersystem Cache :

Intersystem Cache is a commercial operational database management system from intersystem, used to develop healthcare management, banking and financial, government sectors software applications.

InterSystems Cache is the world’s fastest object database. However, high performance is achieved only for transactional operations that have a significantly hierarchical nature

Cache stores data in multidimensional arrays capable of carrying hierarchically structured data. These are the same “global” data structures used by the MUMPS programming language. Cache is object oriented language, MUMPS is procedural language. All Cache code gets transpiled to MUMPS code (internally) before being compiled.InterSystems like to brand Cache as a post-relational database. In reality, it is:

  • pre-relational (NOSQL)
  • relational
  • and post-relational

Best RealTime Example:

A famous example of Cache’s abilities is the European Space Agency’s decision to use it in one of their missions. ESA’s GAIA observatory is tasked with surveying a billion stars in our galaxy, generating an astronomical amount of data in the process. It turns out that Cache was the only DBMS capable of storing and manipulating this vast amount of data in a reasonable amount of time on hardware that is not out of this world.

Industry wise Inter systems Users: (*image referred by enlyft site)

List of top companies are using Intersystem Products: (*image referred by enlyft site)

Add description

Countries wise Customer Count:(*image referred by enlyft site)

Add description

Comparison Between Intersystem Cache ,MSSQL and Oracle:

Add description

Advantages:

  1. Business logic is much simpler,
  2. Easier to get high performance
  3. We can store the data as three ways like Key-Value storage (MUMPS) ,Object Oriented storage and RDBMS storage.

Disadvantages:

  1. Smaller market for developers.
  2. Pretty much no code libraries.

References:

  1. https://www.intersystems.com
  2. https://enlyft.com/tech/products/intersystems

Thanks for Your Reading!!!

Yours,

Ponnumani Gurusamy.

--

--