Development and usage of an anesthesia data warehouse: lessons learnt from a 10-year project.
J Clin Monit Comput
; 37(2): 461-472, 2023 04.
Article
em En
| MEDLINE
| ID: mdl-35933465
ABSTRACT
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.
Palavras-chave
Texto completo:
1
Coleções:
01-internacional
Base de dados:
MEDLINE
Assunto principal:
Data Warehousing
/
Anestesia
Tipo de estudo:
Clinical_trials
/
Guideline
/
Prognostic_studies
Limite:
Humans
Idioma:
En
Revista:
J Clin Monit Comput
Assunto da revista:
INFORMATICA MEDICA
/
MEDICINA
Ano de publicação:
2023
Tipo de documento:
Article
País de afiliação:
França