Design and Implementation of an ETLProcess to Transfer Wound-Related Data into a Standardized Common Data Model
Autor(en): | Przysucha, Mareike Hüsers, Jens Liberman, Daniil Kersten, Oliver Schlüter, Aphrodite Fraas, Sebastian Busch, Dorothee Moelleken, Maurice Erfurt-Berge, Cornelia Dissemond, Joachim Hübner, Ursula |
Herausgeber: | Rohrig, R. Grabe, N. Haag, M. Hubner, U. Sax, U. Schmidt, C.O. Sedlmayr, M. Zapf, A. |
Stichwörter: | algorithm; Algorithms; Chronic conditions; Chronic wounds; Common data model; Computer programming; Data handling; Database schemas; Databases, Factual; Design and implementations; Drugs, Generic; ETL Process; factual database; Generic algorithm; generic drug; human; Humans; information processing; Mapping; Medical informatics; Observational medical outcome partnership common data model; Observational study; OMOP CDM; quality of life; Records; Wound Care | Erscheinungsdatum: | 2023 | Herausgeber: | IOS Press BV | Journal: | Studies in Health Technology and Informatics | Volumen: | 307 | Startseite: | 258 – 266 | Zusammenfassung: | 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. © 2023 The authors and IOS Press. |
Beschreibung: | Cited by: 0; Conference name: 68th Annual Meeting of the German Association of Medical Informatics, Biometry, and Epidemiology: Science. Close to People, GMDS 2023; Conference date: 17 September 2023 through 21 September 2023; Conference code: 193054; All Open Access, Hybrid Gold Open Access |
ISBN: | 9781643684284 | ISSN: | 0926-9630 | DOI: | 10.3233/SHTI230723 | Externe URL: | https://www.scopus.com/inward/record.uri?eid=2-s2.0-85170628264&doi=10.3233%2fSHTI230723&partnerID=40&md5=dd6b57782630b6f63b40fe8b39707aac |
Show full item record