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
. 2024 Jun 20;31(7):1522-1528.
doi: 10.1093/jamia/ocae111.

Understanding enterprise data warehouses to support clinical and translational research: impact, sustainability, demand management, and accessibility

Thomas R Campion Jr  1 , Catherine K Craven  2 , David A Dorr  3   4 , Elmer V Bernstam  5   6 , Boyd M Knosp  7
Affiliations

Understanding enterprise data warehouses to support clinical and translational research: impact, sustainability, demand management, and accessibility

Thomas R Campion Jr et al. J Am Med Inform Assoc. .

Abstract

Objectives: Healthcare organizations, including Clinical and Translational Science Awards (CTSA) hubs funded by the National Institutes of Health, seek to enable secondary use of electronic health record (EHR) data through an enterprise data warehouse for research (EDW4R), but optimal approaches are unknown. In this qualitative study, our goal was to understand EDW4R impact, sustainability, demand management, and accessibility.

Materials and methods: We engaged a convenience sample of informatics leaders from CTSA hubs (n = 21) for semi-structured interviews and completed a directed content analysis of interview transcripts.

Results: EDW4R have created institutional capacity for single- and multi-center studies, democratized access to EHR data for investigators from multiple disciplines, and enabled the learning health system. Bibliometrics have been challenging due to investigator non-compliance, but one hub's requirement to link all study protocols with funding records enabled quantifying an EDW4R's multi-million dollar impact. Sustainability of EDW4R has relied on multiple funding sources with a general shift away from the CTSA grant toward institutional and industry support. To address EDW4R demand, institutions have expanded staff, used different governance approaches, and provided investigator self-service tools. EDW4R accessibility can benefit from improved tools incorporating user-centered design, increased data literacy among scientists, expansion of informaticians in the workforce, and growth of team science.

Discussion: As investigator demand for EDW4R has increased, approaches to tracking impact, ensuring sustainability, and improving accessibility of EDW4R resources have varied.

Conclusion: This study adds to understanding of how informatics leaders seek to support investigators using EDW4R across the CTSA consortium and potentially elsewhere.

Keywords: CTSA; EHR; data warehouse; secondary use.

PubMed Disclaimer

Conflict of interest statement

The authors have no competing interests to report.

References

    1. Knosp BM, Dorr DA, Campion TR. Maturity in enterprise data warehouses for research operations: analysis of a pilot study. J Clin Transl Sci. 2023;7(1):e70. - PMC - PubMed
    1. Obeid JS, Beskow LM, Rape M, et al. A survey of practices for the use of electronic health records to support research recruitment. J Clin Transl Sci. 2017;1(4):246-252. - PMC - PubMed
    1. MacKenzie SL, Wyatt MC, Schuff R, Tenenbaum JD, Anderson N. Practices and perspectives on building integrated data repositories: results from a 2010 CTSA survey. J Am Med Inform Assoc. 2012; 19(e1):e119–e124. - PMC - PubMed
    1. Campion TR, Craven CK, Dorr DA, Knosp BM. Understanding enterprise data warehouses to support clinical and translational research. J Am Med Inform Assoc. 2020;27(9):1352-1358. - PMC - PubMed
    1. Knosp BM, Craven CK, Dorr DA, Bernstam EV, Campion TR. Understanding enterprise data warehouses to support clinical and translational research: enterprise information technology relationships, data governance, workforce, and cloud computing. J Am Med Inform Assoc. 2022;29(4):671-676. - PMC - PubMed