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

Area of Science:

• Medical Informatics
• Health Services Research

Background:

• Electronic medical records (EMRs) from anesthesia information management systems (AIMS) require structured reuse for observational studies.
• Lille University Hospital utilizes a dedicated data warehouse for AIMS data since 2010.

Purpose of the Study:

• To describe a framework for operating an anesthesia data warehouse for research purposes.
• To facilitate the reuse of anesthesia EMR data for observational studies.

Main Methods:

• A structured framework involving three key meetings: study objectives, statistical protocol validation, and results discussion.
• Coordination by a data scientist to manage meetings and milestones.
• Anesthesia data reuse is strictly governed by this framework.

Main Results:

• In a 6-month period, 27 projects were integrated into the framework, resulting in 5 scientific communications.
• The framework fostered collaboration and an empowerment process among clinicians, computer scientists, and statisticians.
• Increased efficiency in data extraction and analysis workflows was observed.

Conclusions:

• The developed framework effectively structures anesthesia data warehouse operations for research.
• This collaborative model promotes reproducible research and encourages scientific publications.
• Implementation of the framework is expected to further enhance collaborative publication output.