Skip to main content
Top
Published in: BMC Medical Informatics and Decision Making 1/2015

Open Access 01-12-2015 | Research article

Archetype relational mapping - a practical openEHR persistence solution

Authors: Li Wang, Lingtong Min, Rui Wang, Xudong Lu, Huilong Duan

Published in: BMC Medical Informatics and Decision Making | Issue 1/2015

Login to get access

Abstract

Background

One of the primary obstacles to the widespread adoption of openEHR methodology is the lack of practical persistence solutions for future-proof electronic health record (EHR) systems as described by the openEHR specifications. This paper presents an archetype relational mapping (ARM) persistence solution for the archetype-based EHR systems to support healthcare delivery in the clinical environment.

Methods

First, the data requirements of the EHR systems are analysed and organized into archetype-friendly concepts. The Clinical Knowledge Manager (CKM) is queried for matching archetypes; when necessary, new archetypes are developed to reflect concepts that are not encompassed by existing archetypes. Next, a template is designed for each archetype to apply constraints related to the local EHR context. Finally, a set of rules is designed to map the archetypes to data tables and provide data persistence based on the relational database.

Results

A comparison study was conducted to investigate the differences among the conventional database of an EHR system from a tertiary Class A hospital in China, the generated ARM database, and the Node + Path database. Five data-retrieving tests were designed based on clinical workflow to retrieve exams and laboratory tests. Additionally, two patient-searching tests were designed to identify patients who satisfy certain criteria. The ARM database achieved better performance than the conventional database in three of the five data-retrieving tests, but was less efficient in the remaining two tests. The time difference of query executions conducted by the ARM database and the conventional database is less than 130 %. The ARM database was approximately 6–50 times more efficient than the conventional database in the patient-searching tests, while the Node + Path database requires far more time than the other two databases to execute both the data-retrieving and the patient-searching tests.

Conclusions

The ARM approach is capable of generating relational databases using archetypes and templates for archetype-based EHR systems, thus successfully adapting to changes in data requirements. ARM performance is similar to that of conventionally-designed EHR systems, and can be applied in a practical clinical environment. System components such as ARM can greatly facilitate the adoption of openEHR architecture within EHR systems.
Literature
2.
go back to reference Mandl KD, Kohane IS. Escaping the EHR Trap — The Future of Health IT. N Engl J Med. 2012;366:2240–2.CrossRefPubMed Mandl KD, Kohane IS. Escaping the EHR Trap — The Future of Health IT. N Engl J Med. 2012;366:2240–2.CrossRefPubMed
3.
go back to reference Kalra D, Beale T, Heard S. The openEHR Foundation. Stud Health Technol Inform. 2005;115:153–73.PubMed Kalra D, Beale T, Heard S. The openEHR Foundation. Stud Health Technol Inform. 2005;115:153–73.PubMed
4.
go back to reference Beale T, Heard S. Architecture Overview. openEHR; 2008. Beale T, Heard S. Architecture Overview. openEHR; 2008.
5.
go back to reference Beale T. Archetypes: Constraint-Based Domain Models for Future-Proof Information Systems. OOPSLA 2002 workshop on behavioural semantics; 2002. Beale T. Archetypes: Constraint-Based Domain Models for Future-Proof Information Systems. OOPSLA 2002 workshop on behavioural semantics; 2002.
6.
go back to reference Beale T, Heard S. Archetype Definitions and Principles. openEHR; 2007. Beale T, Heard S. Archetype Definitions and Principles. openEHR; 2007.
7.
go back to reference Muñoz A, Somolinos R, Pascual M, Fragua JA, González MA, Monteagudo JL, et al. Proof-of-concept Design and Development of an EN13606-based Electronic Health Care Record Service. J Am Med Inform Assoc. 2007;14:118–29.CrossRefPubMedPubMedCentral Muñoz A, Somolinos R, Pascual M, Fragua JA, González MA, Monteagudo JL, et al. Proof-of-concept Design and Development of an EN13606-based Electronic Health Care Record Service. J Am Med Inform Assoc. 2007;14:118–29.CrossRefPubMedPubMedCentral
8.
go back to reference Bernstein K, Bruun-Rasmussen M, Vingtoft S, Andersen SK, Nøhr C. Modelling and implementing electronic health records in Denmark. Int J Med Inf. 2005;74:213–20 [MIE 2003].CrossRef Bernstein K, Bruun-Rasmussen M, Vingtoft S, Andersen SK, Nøhr C. Modelling and implementing electronic health records in Denmark. Int J Med Inf. 2005;74:213–20 [MIE 2003].CrossRef
9.
go back to reference Garde S, Knaup P, Hovenga E, Heard S. Towards semantic interoperability for electronic health records. Methods Inf Med. 2007;46:332–43.PubMed Garde S, Knaup P, Hovenga E, Heard S. Towards semantic interoperability for electronic health records. Methods Inf Med. 2007;46:332–43.PubMed
10.
go back to reference Freriks G, de Moor G, Kalra D. Archetype Paradigm: An ICT Revolution Is Needed. 2007. Freriks G, de Moor G, Kalra D. Archetype Paradigm: An ICT Revolution Is Needed. 2007.
12.
go back to reference Duftschmid G, Chaloupka J, Rinner C. Towards plug-and-play integration of archetypes into legacy electronic health record systems: the ArchiMed experience. BMC Med Inform Decis Mak. 2013;13:11.CrossRefPubMedPubMedCentral Duftschmid G, Chaloupka J, Rinner C. Towards plug-and-play integration of archetypes into legacy electronic health record systems: the ArchiMed experience. BMC Med Inform Decis Mak. 2013;13:11.CrossRefPubMedPubMedCentral
13.
14.
go back to reference Atalag K, Yang HY, Tempero E, Warren J. Model driven development of clinical information sytems using openEHR. Stud Health Technol Inform. 2011;169:849–53.PubMed Atalag K, Yang HY, Tempero E, Warren J. Model driven development of clinical information sytems using openEHR. Stud Health Technol Inform. 2011;169:849–53.PubMed
15.
go back to reference Martínez-Costa C, Menárguez-Tortosa M, Fernández-Breis JT, Maldonado JA. A model-driven approach for representing clinical archetypes for Semantic Web environments. J Biomed Inform. 2009;42:150–64.CrossRefPubMed Martínez-Costa C, Menárguez-Tortosa M, Fernández-Breis JT, Maldonado JA. A model-driven approach for representing clinical archetypes for Semantic Web environments. J Biomed Inform. 2009;42:150–64.CrossRefPubMed
16.
go back to reference van der Linden H, Austin T, Talmon J. Generic screen representations for future-proof systems, is it possible? There is more to a GUI than meets the eye. Comput Methods Programs Biomed. 2009;95:213–26.CrossRefPubMed van der Linden H, Austin T, Talmon J. Generic screen representations for future-proof systems, is it possible? There is more to a GUI than meets the eye. Comput Methods Programs Biomed. 2009;95:213–26.CrossRefPubMed
18.
go back to reference Patrick J, Ly R, Truran D. Evaluation of a Persistent Store for OpenEHR. HIC 2006 HINZ 2006 Proc 2006;83–89. Patrick J, Ly R, Truran D. Evaluation of a Persistent Store for OpenEHR. HIC 2006 HINZ 2006 Proc 2006;83–89.
19.
go back to reference Chen RS, Nadkarni P, Marenco L, Levin F, Erdos J, Miller PL. Exploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation. J Am Med Inform Assoc JAMIA. 2000;7:475–87.CrossRefPubMed Chen RS, Nadkarni P, Marenco L, Levin F, Erdos J, Miller PL. Exploring Performance Issues for a Clinical Database Organized Using an Entity-Attribute-Value Representation. J Am Med Inform Assoc JAMIA. 2000;7:475–87.CrossRefPubMed
20.
go back to reference Freire SM, Sundvall E, Karlsson D, Lambrix P. Performance of XML Databases for Epidemiological Queries in Archetype-Based EHRs. 2012:51–57. Freire SM, Sundvall E, Karlsson D, Lambrix P. Performance of XML Databases for Epidemiological Queries in Archetype-Based EHRs. 2012:51–57.
22.
go back to reference Beeler GW. HL7 Version 3—An object-oriented methodology for collaborative standards development. Int J Med Inf. 1998;48:151–61.CrossRef Beeler GW. HL7 Version 3—An object-oriented methodology for collaborative standards development. Int J Med Inf. 1998;48:151–61.CrossRef
23.
go back to reference Ireland C, Bowers D, Newton M, Waugh K. Understanding object-relational mapping: A framework based approach. Int J Adv Softw. 2009;2:202–16. Ireland C, Bowers D, Newton M, Waugh K. Understanding object-relational mapping: A framework based approach. Int J Adv Softw. 2009;2:202–16.
24.
go back to reference Wang L, Min L, Lu X, Duan H. Archetype Relational Mapping Based on openEHR. Chin J Biomed Eng. 2014;33:432–7. Wang L, Min L, Lu X, Duan H. Archetype Relational Mapping Based on openEHR. Chin J Biomed Eng. 2014;33:432–7.
25.
go back to reference Eggebraaten TJ, Tenner JW, Dubbels JC. A health-care data model based on the HL7 Reference Information Model. IBM Syst J. 2007;46:5–18.CrossRef Eggebraaten TJ, Tenner JW, Dubbels JC. A health-care data model based on the HL7 Reference Information Model. IBM Syst J. 2007;46:5–18.CrossRef
26.
go back to reference Beale T, Heard S. Template Object Model. openEHR; 2007. Beale T, Heard S. Template Object Model. openEHR; 2007.
27.
go back to reference Garde S, Hovenga E, Buck J, Knaup P. Expressing clinical data sets with openEHR archetypes: A solid basis for ubiquitous computing. Int J Med Inf. 2007;76:S334–41.CrossRef Garde S, Hovenga E, Buck J, Knaup P. Expressing clinical data sets with openEHR archetypes: A solid basis for ubiquitous computing. Int J Med Inf. 2007;76:S334–41.CrossRef
28.
go back to reference Buck J, Garde S, Kohl CD, Knaup-Gregori P. Towards a comprehensive electronic patient record to support an innovative individual care concept for premature infants using the openEHR approach. Int J Med Inf. 2009;78:521–31.CrossRef Buck J, Garde S, Kohl CD, Knaup-Gregori P. Towards a comprehensive electronic patient record to support an innovative individual care concept for premature infants using the openEHR approach. Int J Med Inf. 2009;78:521–31.CrossRef
29.
go back to reference Späth MB, Grimson J. Applying the archetype approach to the database of a biobank information management system. Int J Med Inf. 2011;80:205–26.CrossRef Späth MB, Grimson J. Applying the archetype approach to the database of a biobank information management system. Int J Med Inf. 2011;80:205–26.CrossRef
30.
go back to reference Beale T. Archetype Semantics. openEHR; 2007. Beale T. Archetype Semantics. openEHR; 2007.
Metadata
Title
Archetype relational mapping - a practical openEHR persistence solution
Authors
Li Wang
Lingtong Min
Rui Wang
Xudong Lu
Huilong Duan
Publication date
01-12-2015
Publisher
BioMed Central
Published in
BMC Medical Informatics and Decision Making / Issue 1/2015
Electronic ISSN: 1472-6947
DOI
https://doi.org/10.1186/s12911-015-0212-0

Other articles of this Issue 1/2015

BMC Medical Informatics and Decision Making 1/2015 Go to the issue