Metadata-Driven Approach to Generalisation of Transformations in ETL Processes
Studies in Health Technology and Informatics · 2025
DOI: 10.3233/shti250640 ↗Kurz gefasst
Fachartikel in der Zeitschrift Studies in Health Technology and Informatics, 2025. Verfasst von Sara Bachir und 3 weiteren Autor:innen. Beteiligte Einrichtung: Goethe University Frankfurt, University Medicine, Institute of Medical Informatics (IMI), Frankfurt am Main, Germany. Hauptthemen laut MEDLINE: Metadata, Information Storage and Retrieval, Electronic Health Records. Die Arbeit wurde bisher 1-mal zitiert (Crossref). Der Volltext ist frei zugänglich (Open Access, CC BY-NC 4.0).
Abstract (Originalsprache)
Introduction
The secondary use of clinical data becomes more important, whereby a large number of ETL routes for data integration are implemented for specific purposes. The metadata driven approach allows a generalization of ETL processes to reuse existing implementations.
Methods
The metadata stored in the MDR, which describes different attributes of data, is used for this purpose, based on the ISO 21526 and governance and provenance data were taken into account to record the history of the data throughout its lifecycle, based on the W3C PROV model.
Results
To achieve a metadata-driven approach the data structure of the source and target system are represented in a MDR. Afterwards, relations between elements have to be defined with respective transformation rules. These information are used by an generic ETL implementation, so that use case specific content is outsourced within the MDR.
Discussion
A rule-based approach of the MDD ETL implementation allows a generalization of the extract and load phase, however the transformation process has to be standardized further. Moreover, a user-friendly interface is essential for integrating expertise without technical skills.
Schlagwörter
MeSH-Schlagwörter (MEDLINE)
Stichwörter der Autor:innen
Autor:innen und Institutionen
- Goethe University Frankfurt, University Medicine, Institute of Medical Informatics (IMI), Frankfurt am Main, Germany.
Zitieren
APA
Bachir, S., Vengadeswaran, A., Storf, H., & Kadioglu, D. (2025). Metadata-Driven Approach to Generalisation of Transformations in ETL Processes. Studies in Health Technology and Informatics. https://doi.org/10.3233/shti250640
Vancouver
Bachir S, Vengadeswaran A, Storf H, Kadioglu D. Metadata-Driven Approach to Generalisation of Transformations in ETL Processes. Studies in Health Technology and Informatics. 2025. doi:10.3233/shti250640
BibTeX
@article{Bachir2025,
author = {Bachir, Sara and Vengadeswaran, Abishaa and Storf, Holger and Kadioglu, Dennis},
title = {Metadata-Driven Approach to Generalisation of Transformations in ETL Processes},
journal = {Studies in Health Technology and Informatics},
year = {2025},
doi = {10.3233/shti250640}
}
EUVIMED