The MGRID Healthcare Data Model (HDM) provides database support for the 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.
HDM includes the following features:
- No loss of information
- Complete, auditable information is stored
- Support for all HL7 message 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
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.