HDM - Healthcare Data Model

The MGRID Healthcare Data Model (HDM) provides database support for the HL7v2, HL7v3 and HL7 FHIR standards. After loading data, the HDM is the source of information for reporting and analytics use cases which require data from multiple sources or longer periods of time.

Benefits of the HDM are:

  • No loss of information
  • Complete, auditable information is stored
  • Support for all HL7 standards
  • Full SQL support for query of data: JSON data types combined with SQL JOIN, UNION, CTE queries and other set operators
  • Database support for reasoning with physical quantities, coded values and time intervals

The MGRID Healthcare Data Model is the only model that provides seamless access to all HL7 standards from the same unified interface:

  • HL7v2 - Data received from a HL7v2 connector is transformed into JSON and stored.
  • HL7v3 - HDM supports R1 and R2 datatypes, all RIM versions.
  • HL7 FHIR - HDM supports all FHIR Resources in JSON format.

Together, these standards cover the following domains:

  • Accounting and Billing
  • Cardiology
  • Care Provision
  • Claims & Reimbursement
  • Clinical Decision Support
  • Clinical Document Architecture
  • Clinical Genomics
  • Clinical Statement
  • Common Message Element Types
  • Common Product Model
  • Composite Privacy Consent
  • Directive
  • Detailed Clinical Models
  • Diet and Nutrition Orders
  • eMeasures
  • Emergency Medical Services
  • Immunization
  • Laboratory
  • Medical Records
  • Patient Administration
  • Personnel Management
  • Pharmacy
  • Preoperative
  • Anesthesiology
  • Registries
  • Regulated Products
  • Regulated Reporting
  • Regulated Studies
  • Scheduling
  • Shared Messages
  • Specimen Domain
  • Therapeutic Devices
  • Tuberculosis
  • Virtual Medical Record
  • Vital Records

Performance and scalability

The MGRID HDM is available on PostgreSQL and Pivotal Big Data Suite databases. PostgreSQL is a highly versatile and server suitable for OLTP deployments, and has been reported to reach over 300.000 TPS on a single node server. For Extract, Load, Transform deployments where the transform step from source data to query format data is performed on-the-fly, Pivotal Greenplum distributed parallel database server ensures query performance for large databases.

Healthcare Data Model