Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Concept Videos

Mass Analyzers: Common Types01:19

Mass Analyzers: Common Types

660
The quadrupole mass analyzer consists of four cylindrical metal rods arranged in a diamond carrying a DC voltage and a radio-frequency AC voltage. The motion of ions through the quadrupole depends on the field strength, causing only ions of a certain m/z to resonate successfully and strike the detector at a given field strength. Though the transmission rate for these analyzers is high, the exact elemental composition of the sample is not determined because of low resolution; however, they are...
660
Mechanistic Models: Compartment Models in Individual and Population Analysis01:23

Mechanistic Models: Compartment Models in Individual and Population Analysis

68
Mechanistic models are utilized in individual analysis using single-source data, but imperfections arise due to data collection errors, preventing perfect prediction of observed data. The mathematical equation involves known values (Xi), observed concentrations (Ci), measurement errors (εi), model parameters (ϕj), and the related function (ƒi) for i number of values. Different least-squares metrics quantify differences between predicted and observed values. The ordinary least...
68
Levels of Use of a GIS01:29

Levels of Use of a GIS

73
Geographic Information Systems (GIS) operate across three levels of application, each representing an increasing degree of complexity: data management, analysis, and prediction. These levels reflect the expanding functionality and versatility of GIS technology in handling spatial data for diverse purposes.Data ManagementAt its foundational level, GIS serves as a tool for data management, enabling the input, storage, retrieval, and organization of spatial data. This level is often employed in...
73
Olefin Metathesis Polymerization: Acyclic Diene Metathesis (ADMET)00:53

Olefin Metathesis Polymerization: Acyclic Diene Metathesis (ADMET)

2.0K
Acyclic diene metathesis polymerization or ADMET polymerization involves cross-metathesis of terminal dienes, such as 1,8-nonadiene, to give linear unsaturated polymer and ethylene. As ADMET is a reversible process, the formed ethylene gas must be removed from the reaction mixture to complete the polymerization process.
Similar to cross-metathesis, ADMET also involves the formation of metallacyclobutane intermediate by [2+2] cycloaddition of one of the double bonds of a terminal diene with...
2.0K
Data Validation01:03

Data Validation

5.1K
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...
5.1K
Methods of Documentation II: POMR01:26

Methods of Documentation II: POMR

1.0K
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.0K

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Towards Data Quality Assessment and Standardized Representability of German Healthcare Claims Data for Secondary Use.

Studies in health technology and informatics·2026
Same author

Evaluating Prompt Strategies for LLM-Based De-Identification of German Discharge Letters: A Feasibility Study Using GraSCCo.

Studies in health technology and informatics·2026
Same author

Crique: A System for Automatic Extraction and Formalization of Eligibility Criteria for Clinical Trials.

Studies in health technology and informatics·2026
Same author

Adapting the Medical Core Data Set Framework for Nursing: A Conceptual Review of the German Medical Informatics Initiative.

Studies in health technology and informatics·2026
Same author

Meet NUM-ENRICH: A Collaborative National Effort to Extend and Harmonize Research Infrastructures Within the German Network University Medicine.

Studies in health technology and informatics·2026
Same author

ETL Application with R Shiny Visualization.

Studies in health technology and informatics·2026

Related Experiment Video

Updated: Jul 30, 2025

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
07:26

Executing 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.4K

Towards ETL Processes to OMOP CDM Using Metadata and Modularization.

Yuan Peng1, Elisa Henke1, Martin Sedlmayr1

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

Studies in Health Technology and Informatics
|May 19, 2023
PubMed
Summary
This summary is machine-generated.

We developed a flexible Extract-Transform-Load (ETL) process for the OMOP Common Data Model (CDM). This metadata-driven approach standardizes diverse clinical data for research, regardless of source format, version, or context.

Keywords:
ETLMetadataOMOP CDMdata harmonizationinteroperability

More Related Videos

Cloud-Based Phrase Mining and Analysis of User-Defined Phrase-Category Association in Biomedical Publications
09:20

Cloud-Based Phrase Mining and Analysis of User-Defined Phrase-Category Association in Biomedical Publications

Published on: February 23, 2019

8.8K
Data Communication Based on MQTT in a Polymer Extrusion Process
08:15

Data Communication Based on MQTT in a Polymer Extrusion Process

Published on: July 15, 2022

3.5K

Related Experiment Videos

Last Updated: Jul 30, 2025

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
07:26

Executing 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.4K
Cloud-Based Phrase Mining and Analysis of User-Defined Phrase-Category Association in Biomedical Publications
09:20

Cloud-Based Phrase Mining and Analysis of User-Defined Phrase-Category Association in Biomedical Publications

Published on: February 23, 2019

8.8K
Data Communication Based on MQTT in a Polymer Extrusion Process
08:15

Data Communication Based on MQTT in a Polymer Extrusion Process

Published on: July 15, 2022

3.5K

Area of Science:

  • Biomedical Informatics
  • Health Data Science
  • Clinical Research Data Management

Background:

  • Analyzing large clinical datasets is crucial for medical research and cohort building.
  • Standardizing heterogeneous medical data into a common format, like the OMOP Common Data Model (CDM), is essential for efficient analysis.
  • Existing Extract-Transform-Load (ETL) processes can be rigid and struggle with diverse data sources and versions.

Purpose of the Study:

  • To present a novel concept for a modularized, metadata-driven ETL process.
  • To evaluate the adaptability of this ETL process across various data formats, versions, and contexts.
  • To facilitate the transformation of local, heterogeneous medical data into the OMOP CDM.

Main Methods:

  • Development of a modular ETL framework.
  • Implementation of metadata-driven data transformation logic.
  • Testing the process with diverse source data formats and versions.
  • Evaluation of the process's flexibility across different use cases.

Main Results:

  • Demonstrated a modularized ETL process capable of handling data regardless of source format.
  • Validated the process's ability to accommodate different versions of source data.
  • Confirmed the ETL process's adaptability to various contexts of use.
  • Successfully transformed heterogeneous data into the OMOP CDM.

Conclusions:

  • The proposed metadata-driven ETL process offers a flexible and adaptable solution for data standardization.
  • This approach enhances the ability to build research cohorts from diverse clinical data sources.
  • The modular design supports future scalability and integration within the OMOP CDM ecosystem.