Skip to main content

Data Model

HealthShare® Health Connect provides a single, integrated data dictionary that can be accessed using one of several data models. Within Health Connect, data can be modeled and stored as tables, objects, multidimensional arrays, or documents. Different models can seamlessly access the same data without the need for performance-killing mapping between models, and can be simultaneously used on the same data with full concurrency. Health Connect data models include:

  • Multidimensional access: All data in an Health Connect database is stored in efficient, tree-based sparse multidimensional arrays called globals. Because they are accessed directly with no file system layer needed, Health Connect globals provide very fast, flexible storage and retrieval. Globals underlie the Health Connect object and SQL interfaces, support the Key/Value and No SQL paradigms, and allow Health Connect to easily handle dynamic data types such as XML or JSON.

  • Object access: The Health Connect object model is based on the ODMG (Object Database Management Group) standard and supports many advanced features, including multiple inheritance. There are several ways to create, store, and manipulate objects in Health Connect databases, and applications can do so using every commonly used object technology.

  • SQL access: In addition to direct, high-performance access to Health Connect databases, InterSystems SQL provides high-performance access through ODBC and JDBC (using a pure Java-based driver). It also provides a Relational Gateway to facilitate importing data from relational databases.

  • Document access: DocDB is an Health Connect facility for storing and retrieving data based on JSON (JavaScript Object Notation), which provides support for web-based data exchange, and is compatible with, but separate from, traditional SQL table and field (class and property) data storage and retrieval. Health Connect provides support for developing DocDB databases and applications in REST and in ObjectScript, as well as SQL support for creating or querying DocDB data.

Get acquainted

Why Multi-Model?

Try it

Multi-Model QuickStart