文献检索文档翻译深度研究
Suppr Zotero 插件Zotero 插件
邀请有礼套餐&价格历史记录

新学期,新优惠

限时优惠:9月1日-9月22日

30天高级会员仅需29元

1天体验卡首发特惠仅需5.99元

了解详情
不再提醒
插件&应用
Suppr Zotero 插件Zotero 插件浏览器插件Mac 客户端Windows 客户端微信小程序
高级版
套餐订阅购买积分包
AI 工具
文献检索文档翻译深度研究
关于我们
关于 Suppr公司介绍联系我们用户协议隐私条款
关注我们

Suppr 超能文献

核心技术专利:CN118964589B侵权必究
粤ICP备2023148730 号-1Suppr @ 2025

An ETL-process design for data harmonization to participate in international research with German real-world data based on FHIR and OMOP CDM.

作者信息

Peng Yuan, Henke Elisa, Reinecke Ines, Zoch Michéle, Sedlmayr Martin, Bathelt Franziska

机构信息

Institute for Medical Informatics and Biometry at Carl Gustav Carus Faculty of Medicine at Technische Universität Dresden, Germany.

Institute for Medical Informatics and Biometry at Carl Gustav Carus Faculty of Medicine at Technische Universität Dresden, Germany.

出版信息

Int J Med Inform. 2023 Jan;169:104925. doi: 10.1016/j.ijmedinf.2022.104925. Epub 2022 Nov 10.


DOI:10.1016/j.ijmedinf.2022.104925
PMID:36395615
Abstract

BACKGROUND: International studies are increasingly needed in order to gain more unbiased evidence from real-world data. To achieve this goal across the European Union, the EMA set up the DARWIN EU project based on OMOP CDM established by the OHDSI community. The harmonization of heterogeneous local health data in OMOP CDM is an essential step to participate in such networks. Using the widespread communication standard HL7 FHIR can reduce the complexity of the transformation process to OMOP CDM. Enabling German university hospitals to participate in such networks requires an Extract, Transform and Load (ETL)-process that satisfies the following criteria: 1) transforming German patient data from FHIR to OMOP CDM, 2) processing huge amount of data at once and 3) flexibility to cope with changes in FHIR profiles. METHOD: A mapping of German patient data from FHIR to OMOP CDM was accomplished, validated by an interdisciplinary team and checked through the OHDSI Data Quality Dashboard (DQD). To satisfy criteria 2-3, we decided to use SpringBatch-Framework according to its chunk-oriented design and reusable functions for processing large amounts of data. RESULTS: We have successfully developed an ETL-process that fulfills the defined criteria of transforming German patient data from FHIR into OMOP CDM. To measure the validity of the mapping conformance and performance of the ETL-process, it was tested with 392,022 FHIR resources. The ETL execution lasted approximately-one minute and the DQD result shows 99% conformance in OMOP CDM. CONCLUSIONS: Our ETL-process has been successfully tested and integrated at 10 German university hospitals. The data harmonization utilizing international recognized standards like FHIR and OMOP fosters their ability to participate in international observational studies. Additionally, the ETL process can help to prepare more German hospitals with their data harmonization journey based on existing standards.

摘要

相似文献

[1]
An ETL-process design for data harmonization to participate in international research with German real-world data based on FHIR and OMOP CDM.

Int J Med Inform. 2023-1

[2]
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.

JMIR Med Inform. 2023-8-21

[3]
Towards the Representation of Genomic Data in HL7 FHIR and OMOP CDM.

Stud Health Technol Inform. 2021-9-21

[4]
Developing an ETL tool for converting the PCORnet CDM into the OMOP CDM to facilitate the COVID-19 data integration.

J Biomed Inform. 2022-3

[5]
MENDS-on-FHIR: leveraging the OMOP common data model and FHIR standards for national chronic disease surveillance.

JAMIA Open. 2024-5-29

[6]
MENDS-on-FHIR: Leveraging the OMOP common data model and FHIR standards for national chronic disease surveillance.

medRxiv. 2023-11-22

[7]
Data Integration into OMOP CDM for Heterogeneous Clinical Data Collections via HL7 FHIR Bundles and XSLT.

Stud Health Technol Inform. 2020-6-16

[8]
Assessing the Use of German Claims Data Vocabularies for Research in the Observational Medical Outcomes Partnership Common Data Model: Development and Evaluation Study.

JMIR Med Inform. 2023-11-7

[9]
FHIR-Ontop-OMOP: Building clinical knowledge graphs in FHIR RDF with the OMOP Common data Model.

J Biomed Inform. 2022-10

[10]
Eos and OMOCL: Towards a seamless integration of openEHR records into the OMOP Common Data Model.

J Biomed Inform. 2023-8

引用本文的文献

[1]
Leveraging Interoperable Electronic Health Record (EHR) Data for Distributed Analyses in Clinical Research: Technical Implementation Report of the HELP Study.

JMIR Med Inform. 2025-7-30

[2]
Data Interoperability in Context: The Importance of Open-Source Implementations When Choosing Open Standards.

J Med Internet Res. 2025-4-15

[3]
Converting Health Level 7 Clinical Document Architecture (CDA) documents to Observational Medical Outcomes Partnership Common Data Model (OMOP CDM) by leveraging CDA Template definitions.

JAMIA Open. 2025-3-26

[4]
Mapping Emergency Medicine Data to the Observational Medical Outcomes Partnership Common Data Model: A Gap Analysis of the American College of Emergency Physicians Clinical Emergency Data Registry.

J Am Coll Emerg Physicians Open. 2025-1-10

[5]
An ontology-based rare disease common data model harmonising international registries, FHIR, and Phenopackets.

Sci Data. 2025-2-8

[6]
Application of an Externally Developed Algorithm to Identify Research Cases and Controls from EHR Data: Trials and Triumphs.

Appl Clin Inform. 2025-3

[7]
ETL: From the German Health Data Lab data formats to the OMOP Common Data Model.

PLoS One. 2025-1-6

[8]
Advancing healthcare through data: the BETTER project's vision for distributed analytics.

Front Med (Lausanne). 2024-10-2

[9]
FOUNTAIN: a modular research platform for integrated real-world evidence generation.

BMC Med Res Methodol. 2024-10-1

[10]
Streamlining intersectoral provision of real-world health data: a service platform for improved clinical research and patient care.

Front Med (Lausanne). 2024-6-5

文献AI研究员

20分钟写一篇综述,助力文献阅读效率提升50倍

立即体验

用中文搜PubMed

大模型驱动的PubMed中文搜索引擎

马上搜索

推荐工具

医学文档翻译智能文献检索