Related Experiment Video
Updated: Dec 18, 2025
10:23
Author Spotlight: A Machine-Vision Approach to Transmission Electron Microscopy Workflows, Results Analysis and Data Management
Published on: June 23, 2023
3.4K
Metadata-Driven Approach to Generalisation of Transformations in ETL Processes
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
Summary
A metadata-driven approach generalizes Extract, Transform, Load (ETL) processes for clinical data secondary use. This enhances data integration by reusing implementations through a metadata repository (MDR).
Area of Science:
- Health Informatics
- Data Management
- Clinical Data Research
Background:
- Secondary use of clinical data is increasingly vital.
- Numerous Extract, Transform, Load (ETL) processes exist for specific data integration needs.
- A metadata-driven approach offers generalized ETL processes for implementation reuse.
Purpose of the Study:
- To generalize ETL processes for clinical data secondary use.
- To enable reuse of existing ETL implementations through metadata.
- To improve efficiency and flexibility in clinical data integration.
Main Methods:
- Utilized a metadata repository (MDR) storing data attributes.
- Incorporated ISO 21526 standards for metadata.
- Applied W3C PROV model for governance and data provenance tracking throughout the data lifecycle.
Main Results:
- Represented source and target system data structures within the MDR.
- Defined element relationships and transformation rules.
- Developed a generic ETL implementation driven by MDR content, externalizing use-case specifics.
Conclusions:
- A rule-based, metadata-driven ETL implementation generalizes extract and load phases.
- Further standardization of the transformation process is required.
- A user-friendly interface is crucial for non-technical users to integrate expertise.
Keywords:
Data IntegrationETL processMDRMetadata-driven approachOMOP CDMmetadatarule-based approachsecondary useMore Related Videos
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
Related Concept Videos
01:20Transformations 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
01:26Transformation
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
01:21Manipulation 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
01:15Source 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
01:16Drug 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
01:28Drug 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