EUVIMEDEUVIMED entdecken
Open Access · CC BY-NC 4.0

Design and Implementation of an ETL-Process to Transfer Wound-Related Data into a Standardized Common Data Model

Mareike Przysucha, Jens Hüsers, Daniil Liberman, Oliver Kersten, Aphrodite Schlüter, Sebastian Fraas, Dorothee Busch, Maurice Moelleken, Cornelia Erfurt-Berge, Joachim Dissemond, Ursula Hübner

Studies in Health Technology and Informatics · 2023

DOI: 10.3233/shti230723 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Studies in Health Technology and Informatics, 2023. Verfasst von Mareike Przysucha und 10 weiteren Autor:innen. Beteiligte Einrichtung: Health Informatics Research Group, Osnabrück University of AS, Germany. Hauptthemen laut MEDLINE: Quality of Life, Algorithms. Der Volltext ist frei zugänglich (Open Access, CC BY-NC 4.0).

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

For observational studies, which are relevant especially for chronic conditions like chronic wounds, the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) offers a standardized database schema. In this study an ETL process for the transition of wound related data was developed. After understanding the data in general and mapping the relevant codes to concepts available in OMOP, the ETL process was implemented. In a first step, a generic algorithm to convert data to a csv format was implemented in Java. The resulting csv file was then processed within KNIME to be loaded into an OMOP CDM conformant database. During the whole ETL process, HL7 FHIR CodeSystem and ConceptMap resources were used for coding and mapping. First clinical test cases to retrieve data were successfully processed as an example to demonstrate the feasibility and usefulness. They concerned wound size at the first visit and the main issues of patients in the wound quality of life questionnaire (n = 24). In general, the ETL process worked well, yet some challenges arose, like post coordinated SNOMED codes or conditions, which might occur more than once.

Schlagwörter

MeSH-Schlagwörter (MEDLINE)

Quality of LifeAlgorithmsHumansDatabases, FactualDrugs, GenericRecords

Stichwörter der Autor:innen

ETL ProcessOMOP CDMWound Care

Substanzen

Drugs, Generic

Autor:innen und Institutionen

  • Health Informatics Research Group, Osnabrück University of AS, Germany.
  • apenio GmbH & Co. KG, Germany.
  • Department of Dermatology, Uniklinikum Erlangen, Friedrich-Alexander University Erlangen-Nürnberg (FAU), Erlangen, Germany.
  • Department of Dermatology, Venerology and Allergology, University Hospital of Essen, Germany.

Zitieren

APA

Przysucha, M., Hüsers, J., Liberman, D., Kersten, O., Schlüter, A., Fraas, S., Busch, D., Moelleken, M., Erfurt-Berge, C., Dissemond, J., & Hübner, U. (2023). Design and Implementation of an ETL-Process to Transfer Wound-Related Data into a Standardized Common Data Model. Studies in Health Technology and Informatics. https://doi.org/10.3233/shti230723

Vancouver

Przysucha M, Hüsers J, Liberman D, Kersten O, Schlüter A, Fraas S, et al. Design and Implementation of an ETL-Process to Transfer Wound-Related Data into a Standardized Common Data Model. Studies in Health Technology and Informatics. 2023. doi:10.3233/shti230723

BibTeX
@article{Przysucha2023,
  author = {Przysucha, Mareike and Hüsers, Jens and Liberman, Daniil and Kersten, Oliver and Schlüter, Aphrodite and Fraas, Sebastian and Busch, Dorothee and Moelleken, Maurice and Erfurt-Berge, Cornelia and Dissemond, Joachim and Hübner, Ursula},
  title = {Design and Implementation of an ETL-Process to Transfer Wound-Related Data into a Standardized Common Data Model},
  journal = {Studies in Health Technology and Informatics},
  year = {2023},
  doi = {10.3233/shti230723}
}
Kostenlos starten →