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
Review
. 2023 Jul 6;2(7):e0000298.
doi: 10.1371/journal.pdig.0000298. eCollection 2023 Jul.

Good practices for clinical data warehouse implementation: A case study in France

Matthieu Doutreligne  1   2 , Adeline Degremont  1 , Pierre-Alain Jachiet  1 , Antoine Lamer  3   4 , Xavier Tannier  5
Affiliations
Review

Good practices for clinical data warehouse implementation: A case study in France

Matthieu Doutreligne et al. PLOS Digit Health. .

Erratum in

Abstract

Real-world data (RWD) bears great promises to improve the quality of care. However, specific infrastructures and methodologies are required to derive robust knowledge and brings innovations to the patient. Drawing upon the national case study of the 32 French regional and university hospitals governance, we highlight key aspects of modern clinical data warehouses (CDWs): governance, transparency, types of data, data reuse, technical tools, documentation, and data quality control processes. Semi-structured interviews as well as a review of reported studies on French CDWs were conducted in a semi-structured manner from March to November 2022. Out of 32 regional and university hospitals in France, 14 have a CDW in production, 5 are experimenting, 5 have a prospective CDW project, 8 did not have any CDW project at the time of writing. The implementation of CDW in France dates from 2011 and accelerated in the late 2020. From this case study, we draw some general guidelines for CDWs. The actual orientation of CDWs towards research requires efforts in governance stabilization, standardization of data schema, and development in data quality and data documentation. Particular attention must be paid to the sustainability of the warehouse teams and to the multilevel governance. The transparency of the studies and the tools of transformation of the data must improve to allow successful multicentric data reuses as well as innovations in routine care.

PubMed Disclaimer

Conflict of interest statement

I have read the journal’s policy and the authors of this manuscript have the following competing interests: The first author did a (non-paid) visiting in Leo Anthony Celi’s lab during the first semester of 2023.

Figures

Fig 1
Fig 1
CDW: Four steps of data flow from the Hospital Information System: (1) collection, (2) transformations, and (3) provisioning. CDW, clinical data warehouse.
Fig 2
Fig 2. Repartition of CDWs in France.
Base map and data from OpenStreetMap and OpenStreetMap Foundation. Link to the base layer of the map: https://github.com/mapnik/mapnik. CDW, clinical data warehouse.
Fig 3
Fig 3. The French CDWs implementations date back to the first academic works in data reuse in early 2010s and accelerated recently.
CDW, clinical data warehouse.
Fig 4
Fig 4. Percentage of studies by objective.
See this image and copyright information in PMC

References

    1. Jha AK, DesRoches CM, Campbell EG, Donelan K, Rao SR, Ferris TG, et al.. Use of electronic health records in U.S. hospitals. N Engl J Med. 2009;360:1628–1638. doi: 10.1056/NEJMsa0900592 - DOI - PubMed
    1. Sheikh A, Jha A, Cresswell K, Greaves F, Bates DW. Adoption of electronic health records in UK hospitals: lessons from the USA. Lancet (London, England). 2014;384(9937):8–9. doi: 10.1016/S0140-6736(14)61099-0 - DOI - PubMed
    1. Kim YG, Jung K, Park YT, Shin D, Cho SY, Yoon D, et al.. Rate of electronic health record adoption in South Korea: A nation-wide survey. Int J Med Inform. 2017;101:100–107. doi: 10.1016/j.ijmedinf.2017.02.009 - DOI - PubMed
    1. Esdar M, Hüsers J, Weiß JP, Rauch J, Hübner U. Diffusion dynamics of electronic health records: A longitudinal observational study comparing data from hospitals in Germany and the United States. Int J Med Inform. 2019:131. doi: 10.1016/j.ijmedinf.2019.103952 - DOI - PubMed
    1. Kanakubo T, Kharrazi H. Comparing the Trends of Electronic Health Record Adoption Among Hospitals of the United States and Japan. J Med Syst. 2019;43:224. doi: 10.1007/s10916-019-1361-y - DOI - PubMed

LinkOut - more resources