以元数据为导向的方法来概括ETL过程中的转换
Sara Bachir1, Abishaa Vengadeswaran1, Holger Storf1
1Goethe University Frankfurt, University Medicine, Institute of Medical Informatics (IMI), Frankfurt am Main, Germany.
Studies in health technology and informatics
|May 17, 2025
概括
一种以元数据为导向的方法将临床数据二次使用的提取,转换,加载 (ETL) 过程概括为. 这通过通过元数据仓库 (MDR) 重复使用实现来增强数据集成.
科学领域:
- 医疗信息学 医疗信息学
- 数据管理数据管理
- 临床数据研究 临床数据研究
背景情况:
- 临床数据的二次使用越来越重要.
- 许多提取,转换,加载 (ETL) 过程存在于特定的数据集成需求.
- 以元数据为导向的方法为实现重用提供了一般化的ETL流程.
研究的目的:
- 为临床数据的二次使用一般化ETL流程.
- 通过元数据,使现有的ETL实现能够重复使用.
- 提高临床数据整合的效率和灵活性.
主要方法:
- 使用元数据存储库 (MDR) 存储数据属性.
- 纳入了ISO 21526元数据标准.
- 应用W3C PROV模型,用于数据治理和数据来源跟踪,在整个数据生命周期.
主要成果:
- 在MDR中表示源和目标系统数据结构.
- 定义的元素关系和转换规则.
- 开发了一个由MDR内容驱动的通用ETL实现,将特定的用例外部化.
结论:
- 一个基于规则的,元数据驱动的ETL实现将提取和加载阶段概括为.
- 需要进一步标准化转换过程.
- 对于非技术用户来说,一个用户友好的界面对于整合专业知识至关重要.
关键词:
数据整合数据集成在ETL过程中,ETL的过程.在MDR中使用MDR.以元数据为导向的方法.在 OMOP CDM 中,OMOP CDM 是一个 CDM 系统.这些都是元数据.基于规则的方法基于规则的方法.二次使用的二次用途.更多相关视频
09:43Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering
Published on: November 22, 2019
6.6K
07:26Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
Published on: March 19, 2018
9.6K
相关概念视频
Transformations of Functions III
92
Transformations modify the graphical representation of a function without changing its fundamental form. One common transformation is reflection, which flips the graph across a designated axis. When the vertical coordinates of all points are multiplied by the negative one, the entire graph is mirrored over the horizontal axis. This transformation reverses the vertical orientation of peaks and troughs, akin to signal inversion in electrical systems, where a waveform is flipped, but the timing of...
92
Transformation
551
Microbial communities are dynamic environments where cell lysis releases free DNA into the surroundings. Other cells can take up this extracellular DNA through a process known as transformation.When a cell incorporates this foreign DNA into its genome, resulting in genetic modification, the process is known as transformation. Cells capable of this process are termed competent. Competence can be natural, as observed in certain bacteria and archaea, or artificially induced in the...
551
Manipulation and Analysis
224
GIS manipulation and analysis functions are vital for decision-making and planning. These activities range from data retrieval tasks, such as selecting information based on specific criteria, to advanced analytical techniques that address complex spatial problems.One critical GIS analysis method is overlaying, which combines multiple data layers to examine impacts. For example, overlaying a river-dammed lake boundary with road networks can identify affected infrastructure. Another common...
224
Source Transformation
10.9K
Source transformation is a fundamental technique employed in circuit analysis, offering a valuable tool for simplifying complex electrical circuits. This technique involves the replacement of either a voltage source in series with a resistor by a current source in parallel with a resistor, or vice versa. The key concept here is that when the original sources are deactivated (turned off), the equivalent resistance at the circuit's end terminals remains the same.
It is essential to note that when...
It is essential to note that when...
10.9K
Drug Biotransformation: Overview
3.4K
Pharmaceutical substances known as xenobiotics are predominantly lipophilic and nonionized. This enables them to permeate lipid bilayers, such as cell membranes, and interact with intracellular target receptors. Lipophilic drugs have an advantage in crossing biological barriers and reaching their intended sites of action. However, lipophilic drugs often have a restricted capacity for renal expulsion or elimination from the body. When these drugs enter the kidneys and undergo glomerular...
3.4K
Drug Biotransformation: Overview
2.3K
Biotransformation, also known as drug metabolism, is a vital physiological process that chemically alters drugs, facilitating their elimination from the body and terminating their action. This process involves two main phases: phase I and phase II reactions. Phase I reactions, including oxidation, reduction, and hydrolysis, introduce or unmask polar functional groups on the drug molecule, thereby increasing its water solubility. By enhancing water solubility, the drug becomes more hydrophilic...
2.3K
