从异质性到一致性：一种元数据驱动的ETL过程，用于将FHIR数据转换为OMOP CDM。

From Heterogeneity to Uniformity: A Metadata-Driven ETL Process for Transforming FHIR Data into OMOP CDM.

作者信息

Peng Yuan, Henke Elisa, Sedlmayr Martin

机构信息

Institute for Medical Informatics and Biometry, Faculty of Medicine and University Hospital Carl Gustav Carus, TUD Dresden University of Technology, Dresden, Germany.

出版信息

Stud Health Technol Inform. 2025 Apr 8;323:290-291. doi: 10.3233/SHTI250097.

DOI:10.3233/SHTI250097

PMID:40200494

Abstract

Heterogeneous data formats complicate unified analysis in multisite clinical studies. Standardizing data in the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) requires Extract-Transform-Load (ETL) processes, which are complex and time-consuming to develop, especially with different source data specifications. The aim of our work is to develop a generalized, metadata-driven ETL process to transform Fast Healthcare Interoperability Resources (FHIR) into OMOP CDM. In this paper, we present first results of the developed metadata-driven ETL process on the example of two different Patient FHIR specifications.

摘要

异构数据格式使多中心临床研究中的统一分析变得复杂。在观察性医疗结果合作组织（OMOP）通用数据模型（CDM）中对数据进行标准化需要提取-转换-加载（ETL）过程，而开发这些过程复杂且耗时，尤其是在面对不同的源数据规范时。我们工作的目标是开发一个通用的、元数据驱动的ETL过程，将快速医疗互操作性资源（FHIR）转换为OMOP CDM。在本文中，我们以两种不同的患者FHIR规范为例，展示了所开发的元数据驱动的ETL过程的初步结果。