针对将医疗保健数据转换为OMOP共同数据模型 (CDM) 的ETL工具进行比较研究
Adnan Jouned1, Heike Düsseldorf1, Florian Katsch1,2
1Institute of Medical Information Management, Center for Medical Data Science, Medical University of Vienna, Vienna, Austria.
Studies in health technology and informatics
|May 17, 2025
概括
标准化复杂的医疗保健数据对于研究至关重要. 这项研究发现,Pentaho,Apache NiFi和定制工具有效地将数据转化为OMOP通用数据模型 (CDM),对于不同用户专业水平的可用性有所不同.
科学领域:
- 医疗信息学 医疗信息学
- 数据科学数据科学数据科学
- 生物医学研究生物医学研究
背景情况:
- 医疗保健数据的复杂性需要对研究进行标准化.
- 观察医疗结果伙伴关系 (OMOP) 共同数据模型 (CDM) 促进一致的数据分析.
- 有效的提取,转换,加载 (ETL) 过程对于数据标准化至关重要.
研究的目的:
- 评估Pentaho,Apache NiFi和一个定制ETL工具的适用性,用于将医疗保健数据转换为OMOP CDM.
- 根据包括连接性,可用性,性能和灵活性在内的标准来比较这些工具.
- 为选择适合OMOP CDM数据转换的ETL工具提供见解.
主要方法:
- 文献审查以确定ETL工具的评估标准.
- 对Pentaho,Apache NiFi和一个定制的ETL工具进行比较分析.
- 基于连接性,互操作性,用户界面,性能和技术灵活性进行评估.
主要成果:
- 所有评估的ETL工具 (Pentaho,Apache NiFi,定制) 都适合用于基本的OMOP CDM数据转换.
- Pentaho提供了卓越的易用性,使非专家用户受益.
- 阿帕奇NiFi更适合高级用户,而自定义工具则以开发成本为代价提供灵活性.
结论:
- 选择用于OMOP CDM转换的ETL工具取决于用户的专业知识和项目要求.
- 五角大楼,Apache NiFi和定制解决方案为标准化医疗保健数据提供了可行的选择.
- 有效的ETL工具选择可以提高卫生研究的效率和可重复性.
相关概念视频
Data Validation
6.4K
Data validation is an essential part of a comprehensive assessment. Validation is confirming or verifying and opening the door to gathering more assessment data as it clarifies vague or unclear data. The process of checking and verifying the collected information is called data validation. The primary purpose of data validation is to ensure data is as free from error, bias, and misinterpretation as possible.
Nursing assessment guides are generally based on holistic models rather than medical...
Nursing assessment guides are generally based on holistic models rather than medical...
6.4K
Methods of Documentation II: POMR
1.4K
The Problem-Oriented Medical Record (POMR) revolutionized medical record-keeping by introducing a systematic approach focusing on the patient's problems rather than merely listing symptoms. Dr. Lawrence Weed's introduction of this method in the 1960s marked a significant advancement in medical documentation. The POMR framework consists of four key components: the database, problem list, plan of care, and progress notes.
1.4K
Methods of Documentation VI: Case Management Model
924
The case management model is a multidisciplinary approach that involves healthcare professionals from diverse disciplines, such as physicians, nurses, therapists, social workers, and pharmacists, working collaboratively to address the various needs of patients. Each healthcare professional brings unique expertise and perspectives, contributing to a more comprehensive understanding of the patient's condition and tailoring treatment plans accordingly.
For example, a patient with a chronic...
For example, a patient with a chronic...
924
Health Information Technology and Healthcare Information System
1.6K
Health Information Technology (HIT)
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
1.6K
Comparing the Survival Analysis of Two or More Groups
712
Survival analysis is a cornerstone of medical research, used to evaluate the time until an event of interest occurs, such as death, disease recurrence, or recovery. Unlike standard statistical methods, survival analysis is particularly adept at handling censored data—instances where the event has not occurred for some participants by the end of the study or remains unobserved. To address these unique challenges, specialized techniques like the Kaplan-Meier estimator, log-rank test, and...
712


