EUVIMEDEUVIMED entdecken
Open Access

Integrating Health Care Data in an Informatics for Integrating Biology & the Bedside (i2b2) Model Persisted Through Elasticsearch: Design, Implementation, and Evaluation in a French University Hospital

Romain Griffier iD, Fleur Mougin iD, Vianney Jouhet iD

JMIR Medical Informatics · 2025

DOI: 10.2196/65753 ↗

Kurz gefasst

Fachartikel in der Zeitschrift JMIR Medical Informatics, 2025. Verfasst von Romain Griffier und 2 weiteren Autor:innen. Beteiligte Einrichtung: Service d'Information Médicale, Informatique et Archivistique Médicale (IAM), Pôle de Santé Publique, Bordeaux University Hospital, Bordeaux, France. Hauptthemen laut MEDLINE: Medical Informatics, Data Warehousing. Die Arbeit nennt 59 Literaturangaben. Der Volltext ist frei in PubMed Central verfügbar.

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Background

The volume of digital data in health care is continually growing. In addition to its use in health care, the health data collected can also serve secondary purposes, such as research. In this context, clinical data warehouses (CDWs) provide the infrastructure and organization necessary to enhance the secondary use of health data. Various data models have been proposed for structuring data in a CDW, including the Informatics for Integrating Biology & the Bedside (i2b2) model, which relies on a relational database. However, this persistence approach can lead to performance issues when executing queries on massive data sets.

Objective

This study aims to describe the necessary transformations and their implementation to enable i2b2’s search engine to perform the phenotyping task using data persistence in a NoSQL Elasticsearch database.

Methods

This study compares data persistence in a standard relational database with a NoSQL Elasticsearch database in terms of query response and execution performance (focusing on counting queries based on structured data, numerical data, and free text, including temporal filtering) as well as material resource requirements. Additionally, the data loading and updating processes are described.

Results

We propose adaptations to the i2b2 model to accommodate the specific features of Elasticsearch, particularly its inability to perform joins between different indexes. The implementation was tested and evaluated within the CDW of Bordeaux University Hospital, which contains data on 2.5 million patients and over 3 billion observations. Overall, Elasticsearch achieves shorter query execution times compared with a relational database, with particularly significant performance gains for free-text searches. Additionally, compared with an indexed relational database (including a full-text index), Elasticsearch requires less disk space for storage.

Conclusions

We demonstrate that implementing i2b2 with Elasticsearch is feasible and significantly improves query performance while reducing disk space usage. This implementation is currently in production at Bordeaux University Hospital.

Schlagwörter

MeSH-Schlagwörter (MEDLINE)

Medical InformaticsData WarehousingHumansHospitals, UniversityFranceDatabases, FactualElectronic Health Records

Stichwörter der Autor:innen

Elasticsearchclinical data warehousedata persistencehealth data integrationi2b2medical informatics

Autor:innen und Institutionen

  • Service d'Information Médicale, Informatique et Archivistique Médicale (IAM), Pôle de Santé Publique, Bordeaux University Hospital, Bordeaux, France.
  • Team AHeaD, Inserm Bordeaux Population Health Research Center, UMR 1219, Bordeaux University, Bordeaux, France.

ORCID-Profile: Romain Griffier, Fleur Mougin, Vianney Jouhet

Zitieren

APA

Griffier, R., Mougin, F., & Jouhet, V. (2025). Integrating Health Care Data in an Informatics for Integrating Biology & the Bedside (i2b2) Model Persisted Through Elasticsearch: Design, Implementation, and Evaluation in a French University Hospital. JMIR Medical Informatics. https://doi.org/10.2196/65753

Vancouver

Griffier R, Mougin F, Jouhet V. Integrating Health Care Data in an Informatics for Integrating Biology & the Bedside (i2b2) Model Persisted Through Elasticsearch: Design, Implementation, and Evaluation in a French University Hospital. JMIR Medical Informatics. 2025. doi:10.2196/65753

BibTeX
@article{Griffier2025,
  author = {Griffier, Romain and Mougin, Fleur and Jouhet, Vianney},
  title = {Integrating Health Care Data in an Informatics for Integrating Biology & the Bedside (i2b2) Model Persisted Through Elasticsearch: Design, Implementation, and Evaluation in a French University Hospital},
  journal = {JMIR Medical Informatics},
  year = {2025},
  doi = {10.2196/65753}
}
Kostenlos starten →