Skip to main page content
U.S. flag

An official website of the United States government

Dot gov

The .gov means it’s official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you’re on a federal government site.

Https

The site is secure.
The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.

Access keys NCBI Homepage MyNCBI Homepage Main Content Main Navigation
. 2023:8:7.
doi: 10.1186/s41231-023-00140-0. Epub 2023 Mar 2.

Accessing and utilizing clinical and genomic data from an electronic health record data warehouse

Cosby G Arnold  1 , Brandon Sonn  2 , Frederick J Meyers  3 , Alexis Vest  2 , Richie Puls  2 , Estelle Zirkler  4 , Michelle Edelmann  4 , Ian M Brooks  4 , Andrew A Monte  1   5
Affiliations

Accessing and utilizing clinical and genomic data from an electronic health record data warehouse

Cosby G Arnold et al. Transl Med Commun. 2023.

Abstract

Electronic health records (EHRs) and linked biobanks have tremendous potential to advance biomedical research and ultimately improve the health of future generations. Repurposing EHR data for research is not without challenges, however. In this paper, we describe the processes and considerations necessary to successfully access and utilize a data warehouse for research. Although imperfect, data warehouses are a powerful tool for harnessing a large amount of data to phenotype disease. They will have increasing relevance and applications in clinical research with growing sophistication in processes for EHR data abstraction, biobank integration, and cross-institutional linkage.

Keywords: Big data; Data warehouse; Electronic health record; Genomics.

PubMed Disclaimer

Conflict of interest statement

Competing interests The authors declare that they have no competing interests.

Figures

Fig. 1
Fig. 1
Process overview for working with EHR data warehouse. ABC, Access to Biobank Committee; TIS, Translational Informatics Services; HDC, health data compass; EHR, electronic health record
See this image and copyright information in PMC

References

    1. Weiskopf NG, Weng C. Methods and dimensions of electronic health record data quality assessment: enabling reuse for clinical research. J Am Med Inform Assoc. 2013;20(1):144–51. 10.1136/amiajnl-2011-000681. - DOI - PMC - PubMed
    1. Wei WQ, Denny JC. Extracting research-quality phenotypes from electronic health records to support precision medicine. Genome Med. 2015;7(1):41. 10.1186/s13073-015-0166-y. - DOI - PMC - PubMed
    1. Kahn MG, Mui JY, Ames MJ, et al. Migrating a research data warehouse to a public cloud: challenges and opportunities. J Am Med Inform Assoc. 2022;29(4):592–600. 10.1093/jamia/ocab278. - DOI - PMC - PubMed
    1. Bayley KB, Belnap T, Savitz L, Masica AL, Shah N, Fleming NS. Challenges in using electronic health record data for CER: experience of 4 learning organizations and solutions applied. Med Care. 2013;51(8 Suppl 3):S80–6. 10.1097/MLR.0b013e31829b1d48. - DOI - PubMed
    1. Kharrazi H, Chi W, Chang HY, et al. Comparing population-based risk-stratification model performance using demographic, diagnosis and medication data extracted from outpatient electronic health records versus administrative claims. Med Care. 2017;55(8):789–96. 10.1097/mlr.0000000000000754. - DOI - PubMed