Related Experiment Video
Updated: Jun 12, 2026
07:26
Executing Complexity-Increasing Queries in Relational (MySQL) and NoSQL (MongoDB and EXist) Size-Growing ISO/EN 13606 Standardized EHR Databases
Published on: March 19, 2018
Extraction of standardized archetyped data from Electronic Health Record systems based on the Entity-Attribute-Value
Georg Duftschmid1, Thomas Wrba, Christoph Rinner
1Center for Medical Statistics, Informatics and Intelligent Systems, Medical University of Vienna, Spitalgasse 23, 1090 Vienna, Austria. georg.duftschmid@meduniwien.ac.at
International Journal of Medical Informatics
|June 12, 2010
Summary
This study presents an efficient method for extracting Electronic Health Record data from Entity-Attribute-Value systems, ensuring ISO/EN 13606 compliance. The approach facilitates semantically interoperable data exchange using archetypes for structured health record content.
Area of Science:
- Health Informatics
- Computer Science
- Data Management
Background:
- The ISO/EN 13606 standard facilitates semantic interoperability of Electronic Health Record (EHR) data through archetypes.
- Practical implementations and efficient data extraction techniques for ISO/EN 13606-conformant EHR systems are not well-documented.
- Research-oriented EHR systems often utilize an internal Entity-Attribute-Value (EAV) data model.
Purpose of the Study:
- To propose and implement an efficient technique for archetype-compliant data extraction from EAV-based EHR systems.
- To ensure the extracted EHR data conforms to the ISO/EN 13606 standard for semantically interoperable exchange.
- To address the gap in literature regarding practical ISO/EN 13606 implementation strategies.
Main Methods:
- Developed an approach for mapping exported source documents from EAV systems to archetypes.
- Utilized standard XML technologies for the implementation of the data extraction process.
- Focused on EHR systems with an internal Entity-Attribute-Value data model.
Main Results:
- Successfully tested the approach on an EHR system used for clinical research at the Medical University of Vienna.
- Extracted source documents conforming to archetypes and the ISO/EN 13606 standard.
- Demonstrated the feasibility of generating archetype-conformant EHR extracts from an EAV system.
Conclusions:
- Effective extraction of EHR data from EAV-based systems is achievable using the proposed mapping approach.
- A prerequisite is the semantic overlap between the EHR system's data model and the archetypes, enabling mapping.
- The EHR system must provide an XML interface for exporting source documents, including mandatory data and metadata as per the ISO/EN 13606 Reference Model.
Related Concept Videos
01:30Methods of Documentation VII: EMR
Electronic Medical Records (EMRs) primarily center around electronically documenting patients' health information within a single healthcare organization or practice. They contain essential clinical data related to a patient's medical history, diagnoses, medications, treatment plans, lab results, and other pertinent information relevant to the specific encounter or episode of care. EMRs are designed to streamline documentation and workflow processes within individual healthcare settings,...
01:03Data Validation
Data validation is an essential part of a comprehensive assessment. Validation is confirming or verifying and opening the door to gathering more assessment data as it clarifies vague or unclear data. The process of checking and verifying the collected information is called data validation. The primary purpose of data validation is to ensure data is as free from error, bias, and misinterpretation as possible.
Nursing assessment guides are generally based on holistic models rather than medical...
Nursing assessment guides are generally based on holistic models rather than medical...
01:40Archival Research
Some researchers gain access to large amounts of data without interacting with a single research participant. Instead, they use existing records to answer various research questions. This type of research approach is known as archival research. Archival research relies on looking at past records or data sets to look for interesting patterns or relationships. For example, a researcher might access the academic records of all individuals who enrolled in college within the past ten years and...
01:19Purpose of Health Records II
Health records serve various essential purposes in the healthcare system. Here are some key purposes:
01:45ER Retrieval Pathway
In the secretory pathway, vesicles transport proteins from one cellular compartment to another in forward transport to deliver the protein to its correct location. Occasionally, misfolded proteins and incorrect proteins escape their original compartments, and a retrieval pathway is used to return the escaped proteins to their original compartment.
The ER uses many checkpoints to prevent the entry of incorrectly folded or a resident protein as cargo onto a transport vesicle. These mechanisms...
The ER uses many checkpoints to prevent the entry of incorrectly folded or a resident protein as cargo onto a transport vesicle. These mechanisms...
01:23Mechanistic Models: Compartment Models in Individual and Population Analysis
Mechanistic models are utilized in individual analysis using single-source data, but imperfections arise due to data collection errors, preventing perfect prediction of observed data. The mathematical equation involves known values (Xi), observed concentrations (Ci), measurement errors (εi), model parameters (ϕj), and the related function (ƒi) for i number of values. Different least-squares metrics quantify differences between predicted and observed values. The ordinary least squares (OLS)...