Evidence map›Paper›PMID 41169627›Full record

ArticleLearning health systems2025

Streamlining electronic medical record data extraction and validation in digital hospitals: A systematic review to identify optimal approaches and methods.

Han Chang Lim, Howard Wong, Reji Philip, Anton Van Der Vegt, Kim-Kwang Raymond Choo, Jason D Pole, Clair Sullivan

Abstract read
In one paragraph

Article in Learning health systems, 2025. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 3 papers.

0numbers the graph read from it
0cells of the map it votes in
3citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

3 citing papers in PubMed.

  1. Article
  2. Article
  3. Article
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

7 authors.

Han Chang LimQueensland Digital Health Centre, Centre for Health Services Research, Faculty of Medicine The University of Queensland Herston Queensland Australia.ORCID https://orcid.org/0000-0003-3293-6164
Howard WongQueensland Digital Health Centre, Centre for Health Services Research, Faculty of Medicine The University of Queensland Herston Queensland Australia.
Reji PhilipQueensland Digital Health Centre, Centre for Health Services Research, Faculty of Medicine The University of Queensland Herston Queensland Australia.
Anton Van Der VegtQueensland Digital Health Centre, Centre for Health Services Research, Faculty of Medicine The University of Queensland Herston Queensland Australia.
Kim-Kwang Raymond ChooDepartment of Information Systems and Cyber Security The University of Texas at San Antonio San Antonio Texas USA.
Jason D PoleQueensland Digital Health Centre, Centre for Health Services Research, Faculty of Medicine The University of Queensland Herston Queensland Australia.
Clair SullivanQueensland Digital Health Centre, Centre for Health Services Research, Faculty of Medicine The University of Queensland Herston Queensland Australia.

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

Objective: Extracting and curating data from large clinical information systems is challenging, and the optimal methodology is often unclear. This review was to systematically investigate and appraise the research literature to assess existing methods used by healthcare organizations to extract data from the electronic medical record (EMR). The Observational Medical Outcomes Partnership (OMOP) common data model (CDM) is used as a comparator for the various methods of data extraction. Our specific research question was: what lessons can be learned from healthcare organizations' experiences with data extraction from EMRs using OMOP CDM as a standardized use case? Methods: We searched PubMed, Web of Science, Embase, the snowballing citation, and potentially relevant gray literature via Google Scholar for EMR data extraction and validation with OMOP CDM as the standardized use case for studies published between June 2017 and December 2022. A total of 316 candidate articles were examined, but only nine met the inclusion criteria. Two authors screened and assessed articles based on predetermined criteria to examine prevalent techniques and challenges through thematic synthesis and data analysis. Results: Among all the included articles, the most frequently discussed challenges in EMR data extraction and validation are the lack of a standardized process, data structure, and skilled personnel. Five of nine studies scored above 70% in the article quality assessment process. Three studies used Observational Health Data Sciences and Informatics's suite, and two utilized Staged Optimization of Curation, Regularization, and Annotation of clinical text alongside the semantic transformation framework. Discussion: The study revealed the importance of standardizing a uniform approach, consistent processes, and tools for EMR data extraction and validation. The identified methods and techniques could streamline the EMR data extraction processes. Our future work will empirically evaluate these methods in collaboration with real-world healthcare organizations.

Indexed as

data analyticsdata extractiondata validationdigital hospitalelectronic health records and systemselectronic medical recordsETLhospital information systemsOMOP CDMroutinely collected health data

Identifiers

PMID41169627
PMCPMC12569454

What OpenQuestion holds

Textmetadata
LicenceCC BY-NC
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.