Related Experiment Video
Updated: Sep 20, 2025

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
Optimizing Medication Querying Using Ontology-Driven Approach with OMOP: with an application to a large-scale
Xiaojin Li1,2, Yan Huang1,2, Licong Cui3,2
1McGovern Medical School, The University of Texas Health Science Center at Houston, Houston, Texas 77030, USA.
This study introduces an ontology-driven medication query (ODMQ) approach to optimize electronic health record (EHR) data retrieval. ODMQ enhances medication information searching accuracy and efficiency, reducing manual effort for clinical research.
Area of Science:
- Health Informatics
- Clinical Data Management
- Pharmacology
Background:
- Efficient querying of medication information in Electronic Health Records (EHR) is vital for patient care and clinical research.
- Large EHR datasets present challenges in data volume and complexity for medication information retrieval.
- Existing methods may lack comprehensiveness in identifying relevant medication terms.
Purpose of the Study:
- To propose and validate an ontology-driven medication query (ODMQ) optimization approach.
- To enhance the accuracy and efficiency of medication information retrieval from EHR datasets.
- To improve the scope of medication term identification beyond traditional methods.
Main Methods:
- Leveraging the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM).
- Integrating semantic ontology structures to broaden medication term scope (drug names, National Drug Codes, generics).
- Validating ODMQ efficacy using real-world COVID-19 EHR data and manual review for relevance.
Main Results:
- ODMQ significantly reduces manual search time and enhances query capabilities.
- Demonstrated improved query performance in real-world COVID-19 EHR data.
- Ensured expanded search terms are relevant through comprehensive manual review.
Conclusions:
- The ontology-driven medication query (ODMQ) approach effectively optimizes medication information retrieval from EHRs.
- ODMQ enhances query accuracy, efficiency, and comprehensiveness compared to traditional methods.
- The approach includes an intuitive interface and visualization tools for result validation.
More Related Videos
Related Concept Videos
Methods of Documentation II: POMR
Analysis of Population Pharmacokinetic Data
Health Information Technology and Healthcare Information System
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
Issues And Trends In Healthcare Delivery System
Cost Containment
Payment for healthcare services has historically promoted adoption of costly and often unnecessary or inefficient...
Prescription, Nonprescription and Orphan Drugs
The misuse and addiction to prescription drugs is a growing problem that can affect people of all age groups, specifically teenagers. This can happen when prescription medications are used in ways not intended by the prescriber, such as taking someone else's prescription or using medication for...
Nursing Clinical Information System
A Nursing Clinical Information System (NCIS) is a specialized type of healthcare information system tailored to meet the unique needs of nursing practice. It incorporates the principles of nursing informatics to streamline information management and improve the quality of care delivery.
Critical attributes of NCIS include:

