Afficher la notice abrégée

dc.rights.licenseopenen_US
hal.structure.identifierBordeaux population health [BPH]
dc.contributor.authorGRIFFIER, Romain
IDREF: 252908562
hal.structure.identifierBordeaux population health [BPH]
dc.contributor.authorMOUGIN, Fleur
IDREF: 116242337
hal.structure.identifierBordeaux population health [BPH]
dc.contributor.authorJOUHET, Vianney
dc.date.accessioned2025-07-08T10:44:44Z
dc.date.available2025-07-08T10:44:44Z
dc.date.issued2025-04-24
dc.identifier.issn2291-9694en_US
dc.identifier.urihttps://oskar-bordeaux.fr/handle/20.500.12278/207265
dc.description.abstractEnBackground: 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 performjoins 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 demonstratethat 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.
dc.language.isoENen_US
dc.rightsAttribution 3.0 United States*
dc.rights.urihttp://creativecommons.org/licenses/by/3.0/us/*
dc.subject.enClinical Data Warehouse
dc.subject.enHealth Data Integration
dc.subject.enI2b2
dc.subject.enElasticsearch
dc.subject.enMedical Informatics
dc.subject.enData Persistence
dc.title.enIntegrating 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
dc.title.alternativeJMIR Med Informen_US
dc.typeArticle de revueen_US
dc.identifier.doi10.2196/65753en_US
dc.subject.halSciences du Vivant [q-bio]/Santé publique et épidémiologieen_US
dc.identifier.pubmed40273445en_US
bordeaux.journalJMIR Medical Informaticsen_US
bordeaux.pagee65753en_US
bordeaux.volume13en_US
bordeaux.hal.laboratoriesBordeaux Population Health Research Center (BPH) - UMR 1219en_US
bordeaux.institutionUniversité de Bordeauxen_US
bordeaux.institutionINSERMen_US
bordeaux.teamAHEAD_BPHen_US
bordeaux.peerReviewedouien_US
bordeaux.inpressnonen_US
hal.identifierhal-05150618
hal.version1
hal.date.transferred2025-07-08T10:44:46Z
hal.popularnonen_US
hal.audienceInternationaleen_US
hal.exporttrue
dc.rights.ccPas de Licence CCen_US
bordeaux.COinSctx_ver=Z39.88-2004&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.jtitle=JMIR%20Medical%20Informatics&rft.date=2025-04-24&rft.volume=13&rft.spage=e65753&rft.epage=e65753&rft.eissn=2291-9694&rft.issn=2291-9694&rft.au=GRIFFIER,%20Romain&MOUGIN,%20Fleur&JOUHET,%20Vianney&rft.genre=article


Fichier(s) constituant ce document

Thumbnail
Thumbnail

Ce document figure dans la(les) collection(s) suivante(s)

Afficher la notice abrégée