Integrating healthcare-related information using the entity-attribute-value storage model

Authors:
Dortje Löper;Meike Klettke;Ilvio Bruder;Andreas Heuer
Affiliations:
Database Research Group, University of Rostock, Rostock, Germany;Database Research Group, University of Rostock, Rostock, Germany;Database Research Group, University of Rostock, Rostock, Germany;Database Research Group, University of Rostock, Rostock, Germany
Venue:
HIS'12 Proceedings of the First international conference on Health Information Science
Year:
2012

Citing 2
Cited 0

Experiences with Mirth: an open source health care integration engine

Proceedings of the 30th international conference on Software engineering
Pivoting approaches for bulk extraction of Entity-Attribute-Value data

Computer Methods and Programs in Biomedicine

Quantified Score

Hi-index	0.00

Visualization

Abstract

For an optimal care of patients in home healthcare, it is essential to exchange healthcare-related information with other stakeholders. Unfortunately, paper-based documentation procedures as well as the heterogeneity between information systems inhibit a well-regulated communication. Therefore, a digital patient care record is introduced to establish the foundation for integrating healthcare-related information. To overcome the heterogeneity, standards for health information exchange such as HL7 CDA are used. This paper proposes a generic storage structure based on the entity-attribute-value (EAV) model for the patient care record. This approach offers flexibility concerning different standard types and the evolution in healthcare knowledge and processes. It also allows for highly sparsed data to be stored in a compact way. The underlying database structure is presented, the import process for extracting incoming reports is described and the export process for generating new outgoing standardized reports is briefly illustrated. First performance tests regarding the query response time are also given.