arrow
Return

An Extract, Transform, Load Foundation for Biobank Data Interoperability

delete2025-12-01
delete1
PRE
AI
A
Antonella Cruoglio
R
Rossi, Federica
D
Davide Fragnito
R
Ramona Palombo
A
Alice Massacci
M
Martina Betti
M
Mattia D’Antonio
M
Massimiliano Borsani
C
Claudia Miele
G
Gennaro Ciliberto
M
Marialuisa Lavitrano
M
Matteo Pallocca *
DOI:10.1145/3769117delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Federated Search enables data accessibility under privacy-preserving regulations. One of the strategic objectives of the BBMRI-ERIC biobanking infrastructure is to make high-quality samples findable via Federated Search. The main prerequisites for biobanks to join the Federated Network are the conversion of a local database into a Common Data Model and the setup of a server node in which the database is loaded and made accessible for external queries. Data conversion is often the most critical step for institutions, as many of them lack the technical expertise needed to improve the FAIRness of their data. This is achieved through a local Extraction, Transformation and Loading process of data, usually extracted from a Biobank Information Management System. We hereby present a framework for the conversion of minimal information datasets into HL7-FHIR transaction bundles, allowing basic Biobank Interoperability, and enabling biobanks to be connected to the BBMRI-ERIC European Federated Platform. The toolkit consists of several Python modules, creating JSON files, ready to be uploaded to an internal FHIR server connected to the federated network, enabling data sharing and query execution. This tool has been successfully integrated in three BBMRI.it biobanks, allowing them to share their data correctly. In general, this tool will enforce data harmonization and standardization among research infrastructures, integrating the current pipeline into local information systems. The framework is available at https://github.com/bbdataeng/a-small-fire.
Keywords:
FAIR
federated search
biobank data quality
ETL
clinical bioinformatics

Journal

A
ACM Journal of Data and Information Quality
IF:
2.9
Papers:
15
Citations:
0

Organization

U
university of milano-bicocca
Scholars:
2.0W
Papers: 1.5W
Citations: 22
C
consiglio nazionale delle ricerche (cnr)
Scholars:
6.2W
Papers: 5.7W
Citations: 48