An Extract-Transform-Load Process Design for the Incremental Loading of German Real-World Data Based on FHIR and OMOP CDM: Algorithm Development and Validation.

ABSTRACT:

Background

In the Medical Informatics in Research and Care in University Medicine (MIRACUM) consortium, an IT-based clinical trial recruitment support system was developed based on the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM). Currently, OMOP CDM is populated with German Fast Healthcare Interoperability Resources (FHIR) using an Extract-Transform-Load (ETL) process, which was designed as a bulk load. However, the computational effort that comes with an everyday full load is not efficient for daily recruitment.

Objective

The aim of this study is to extend our existing ETL process with the option of incremental loading to efficiently support daily updated data.

Methods

Based on our existing bulk ETL process, we performed an analysis to d

SUBMITTER: Henke E 

PROVIDER: S-EPMC10466444 | biostudies-literature | 2023 Aug

REPOSITORIES: biostudies-literature