Development and usage of an anesthesia data warehouse: lessons learnt from a 10-year project.

J Clin Monit Comput

Univ. Lille, CHU Lille, ULR 2694 - METRICS: Évaluation des Technologies de Santé et des Pratiques Médicales, Lille, France.

Published: April 2023

This paper describes the development and implementation of an anesthesia data warehouse in the Lille University Hospital. We share the lessons learned from a ten-year project and provide guidance for the implementation of such a project. Our clinical data warehouse is mainly fed with data collected by the anesthesia information management system and hospital discharge reports. The data warehouse stores historical and accurate data with an accuracy level of the day for administrative data, and of the second for monitoring data. Datamarts complete the architecture and provide secondary computed data and indicators, in order to execute queries faster and easily. Between 2010 and 2021, 636 784 anesthesia records were integrated for 353 152 patients. We reported the main concerns and barriers during the development of this project and we provided 8 tips to handle them. We have implemented our data warehouse into the OMOP common data model as a complementary downstream data model. The next step of the project will be to disseminate the use of the OMOP data model for anesthesia and critical care, and drive the trend towards federated learning to enhance collaborations and multicenter studies.

Download full-text PDF

Source
http://www.ncbi.nlm.nih.gov/pmc/articles/PMC10068662PMC
http://dx.doi.org/10.1007/s10877-022-00898-yDOI Listing

Publication Analysis

Top Keywords

data warehouse
20
data
13
data model
12
anesthesia data
8
anesthesia
5
warehouse
5
project
5
development usage
4
usage anesthesia
4
warehouse lessons
4

Similar Publications

Comparative Effectiveness of Outpatient COVID-19 Therapies in Solid Organ Transplant Recipients.

Transpl Infect Dis

January 2025

Division of Public Health, Infectious Diseases, and Occupational Medicine, Mayo Clinic, Rochester, Minnesota, USA.

Background: Multiple outpatient therapies have been developed for COVID-19 in high-risk individuals, but solid organ transplant (SOT) recipients were not well represented in controlled clinical trials. To date, few comparative studies have evaluated outcomes between outpatient therapies in this population.

Methods: We performed a retrospective cohort study using de-identified administrative claims data from OptumLabs Data Warehouse.

View Article and Find Full Text PDF

Background: This study aimed to evaluate the predictive ability of two widely used early warning scoring systems, the Modified Early Warning Score (MEWS) and the National Early Warning Score (NEWS), for predicting stroke occurrence in hospitalized patients.

Methods: The study enrolled 5,474 patients admitted to the intensive care unit from the general ward using data from the Smart Clinical Data Warehouse (CDW). MEWS and NEWS were calculated based on vital signs and clinical parameters within four hours of stroke onset.

View Article and Find Full Text PDF

Objectives: We assessed HIV-1 drug resistance profiles among people living with HIV (PLWH) with detectable viral load (VL) and on dolutegravir-based antiretroviral therapy (ART) in Botswana.

Methods: The study utilised available 100 residual HIV-1 VL samples from unique PLWH in Francistown who had viraemia at-least 6 months after initiating ART in Botswana's national ART program from November 2023 to January 2024. Viraemia was categorized as low-level viraemia (LLV) (VL: 200-999 copies/mL) or virologic failure (VF) (VL ≥1000 copies/mL).

View Article and Find Full Text PDF

Peak serum lactate as a robust predictor of imminent death in life-sustaining treatment decisions: A study of 73,927 patients.

Sci Prog

January 2025

Department of Thoracic and Cardiovascular Surgery, Seoul National University Bundang Hospital, Seoul National University College of Medicine, Seoul, Republic of Korea.

Objective: The physician order for life-sustaining treatment has been implemented in clinical practice for several years. However, the determination that a patient is in the terminal phase of life, a prerequisite for the withdrawal of life-sustaining treatment, lacks objective criteria. This study aimed to evaluate whether hyperlactatemia could serve as a reliable objective indicator for determining the terminal phase.

View Article and Find Full Text PDF

Trends in outpatient dermatology appointment wait times for United States (US) veterans are poorly characterized. Given concerns surrounding prolonged wait times at Veterans Health Administration (VHA) medical facilities, the federal government introduced the Maintaining Internal Systems and Strengthening Outside Networks (MISSION) Act in 2018, allowing veterans to receive VHA-reimbursed community care if VHA specialty care appointments cannot be scheduled within 28 days. Considering this expanded access to community care, we characterized among US veterans the (1) overall demand for dermatology appointments, (2) trends in average wait times, and (3) facility/geographic variation in wait times.

View Article and Find Full Text PDF

Want AI Summaries of new PubMed Abstracts delivered to your In-box?

Enter search terms and have AI summaries delivered each week - change queries or unsubscribe any time!