EUVIMEDEUVIMED entdecken
Open Access · CC BY-NC 4.0

Metadata-Driven Approach to Generalisation of Transformations in ETL Processes

Sara Bachir, Abishaa Vengadeswaran, Holger Storf, Dennis Kadioglu

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).

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

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)

MetadataInformation Storage and RetrievalElectronic Health RecordsHumans

Stichwörter der Autor:innen

Data IntegrationETL processMDRMetadata-driven approachOMOP CDMmetadatarule-based approachsecondary use

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}
}
Kostenlos starten →