dx.doi.org
Design and Implementation of an ETL-Process to Transfer Wound-Related Data into a Standardized Common Data Model
September 2023 • Mareike Przysucha, Jens Hüsers, Daniil Liberman, Oliver Kersten, A. Dieter Schlüter, Sebastian Fraas, Dorothee Busch, Maurice Moelleken, Cornelia Erf…
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 implemen…