Standardized electronic health record data modeling and persistence: A comparative review

• Published in: Journal of biomedical informatics Vol. 114; p. 103670
• Main Authors: Gamal, Aya, Barakat, Sherif, Rezk, Amira
• Format: Journal Article
• Language: English
• Published: United States Elsevier Inc 01.02.2021
• Subjects: EHRs Data Modeling; Health care task; Interoperability; NoSQL; Standardized Electronic Health Record; Workload Characteristics; Workload Characteristics; NoSQL; EHRs Data Modeling; Standardized Electronic Health Record; Interoperability; Health care task
• ISSN: 1532-0464; 1532-0480
• DOI: 10.1016/j.jbi.2020.103670

[Display omitted] •Each storage model offers different performance according to application scenario.•EHRs usage scenarios are divided into two main tasks: primary use and secondary use.•NoSQL data models provide superior solutions for managing standardized EHRs data.•Polyglot stores are a hybrid database architecture solution. With the extensive adoption of electronic health records (EHRs) by several healthcare organizations, more efforts are needed to manage and utilize such massive, various, and complex healthcare data. Databases' performance and suitability to health care tasks are dramatically affected by how their data storage model and query capabilities are well-adapted to the use case scenario. On the other hand, standardized healthcare data modeling is one of the most favorable paths for achieving semantic interoperability, facilitating patient data integration from different healthcare systems. This paper compares the state-of-the-art of the most crucial database management systems used for storing standardized EHRs data. It discusses different database models' appropriateness for meeting different EHRs functions with different database specifications and workload scenarios. Insights into relevant literature show how flexible NoSQL databases (document, column, and graph) effectively deal with standardized EHRs data's distinctive features, especially in the distributed healthcare system, leading to better EHR.