From Data Extraction to Analysis: Proposal of a Methodology to Optimize Hospital Data Reuse Process

摘要

In the Lille University Hospital (North of France), data from the Anesthesia Information Management System (Diane) are linked to the Hospital Information System and stored in a dedicated data warehouse since 2010. These electronic medical records need to be reused and analyzed for observational studies. The aim of this paper is to describe the framework developed to structure the operation of that anesthesia data warehouse for research purposes. The presented framework is structured around three meetings between clinicians, computer scientists, and statisticians. The data scientist acts as a coordinator, leads meetings, and checks each milestone. Reuse of anesthesia-related electronic medical record for research purposes is only allowed through this framework. The aim of the first meeting is to decide the primary and secondary objectives of the study. The aim of the second meeting is to validate the statistical protocol. The data are extracted and the statistical analyses are performed. Finally, the results are presented, explained and discussed during the third meeting. During a 6 months period, 27 projects were included in the framework leading to 5 scientific communications. As a result, case studies with extraction and/or analysis situations are presented. This collaboration led to an empowerment process between all three actors, which increased efficiency of the workflow. Implementation of this framework will keep encouraging collaborative publication in order to provide reproducible research evidence.