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

Methods of Documentation II: POMR01:26

Methods of Documentation II: POMR

959
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.
959
Base Quantities and Derived Quantities01:14

Base Quantities and Derived Quantities

20.2K
In any system of units, the units for some physical quantities must be specified through a measurement process. These measurements are the base quantities of the system, and their units are the base units of the system. The algebraic combinations of the base values can then be used to express all other physical quantities. Each of these physical quantities is then referred to as a derived quantity, with each unit being referred to as a derived unit.
The International Organization for...
20.2K
Data Reporting and Recording01:24

Data Reporting and Recording

4.7K
Reporting and recording are crucial in data documentation. The timely, thorough, and accurate documentation of facts is essential when recording patient data. Failure to record findings during an assessment or interpretation of a problem will result in loss of information and make the patient document unreliable. The reader is left with general impressions if the information is not specific. A recording is documenting data of the individual's health information in a traceable, secure, and...
4.7K
Mass Analyzers: Common Types01:19

Mass Analyzers: Common Types

617
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...
617
Conversion of Units01:36

Conversion of Units

22.7K
Sometimes, there is a need to convert from one unit to another one. For instance, reading a cookbook in which quantities are expressed in units of liters or ounces may require conversion of quantities to cups. Or, when looking up directions on how to get to a location, we may be interested to know how many miles we are going to walk. In this case, we would have to convert units of feet or meters to miles.
The first step in the unit conversion is to list the given units and the units required...
22.7K
Data: Types and Distribution01:19

Data: Types and Distribution

727
In biostatistics, data are the observations collected for analysis. There are two main types: parametric and non-parametric. Parametric data, which include continuous (e.g., weight) and discrete numerical data (e.g., number of tablets), assume a particular distribution pattern, often the normal distribution. Non-parametric data do not adhere to a specific distribution and typically comprise nominal (e.g., gender) and ordinal categorical data (e.g., pain scale ratings).
Distributions in...
727

You might also read

Related Articles

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

Sort by
Same author

Informatics assessment of COVID-19 data collection: an analysis of UK Biobank questionnaire data.

BMC medical informatics and decision making·2024
Same author

Semaglutide use in people with obesity and type 2 diabetes from real-world utilization data: An analysis of the All of US Program.

Diabetes, obesity & metabolism·2024
Same author

Alcohol consumption and its correlation with medical conditions: a UK Biobank study.

Frontiers in public health·2024
Same author

Learning important common data elements from shared study data: The All of Us program analysis.

PloS one·2023
Same author

regCOVID: Tracking publications of registered COVID-19 studies.

BMC medical research methodology·2022
Same author

CONSIDER Statement: Consolidated Recommendations for Sharing Individual Participant Data from Human Clinical Studies.

AMIA Joint Summits on Translational Science proceedings. AMIA Joint Summits on Translational Science·2021

Related Experiment Video

Updated: Jul 9, 2025

O-cresol Concentration Online Measurement Based On Near Infrared Spectroscopy Via Partial Least Square Regression
06:50

O-cresol Concentration Online Measurement Based On Near Infrared Spectroscopy Via Partial Least Square Regression

Published on: November 8, 2019

6.6K

Conversion of CPRD AURUM Data into the OMOP Common Data Model.

Craig S Mayer1

  • 1Lister Hill National Center for Biomedical Communication, National Library of Medicine, NIH Bethesda, MD, USA.

Informatics in Medicine Unlocked
|December 4, 2023
PubMed
Summary

Clinical Practice Research Datalink (CPRD) AURUM data was successfully converted to the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM). This standardization enhances data reusability for future research using existing tools.

Keywords:
Clinical InformaticsCommon Data ModelData ScienceReal World Data

More Related Videos

A Metadata Extraction Approach for Clinical Case Reports to Enable Advanced Understanding of Biomedical Concepts
07:50

A Metadata Extraction Approach for Clinical Case Reports to Enable Advanced Understanding of Biomedical Concepts

Published on: September 20, 2018

15.9K
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

Related Experiment Videos

Last Updated: Jul 9, 2025

O-cresol Concentration Online Measurement Based On Near Infrared Spectroscopy Via Partial Least Square Regression
06:50

O-cresol Concentration Online Measurement Based On Near Infrared Spectroscopy Via Partial Least Square Regression

Published on: November 8, 2019

6.6K
A Metadata Extraction Approach for Clinical Case Reports to Enable Advanced Understanding of Biomedical Concepts
07:50

A Metadata Extraction Approach for Clinical Case Reports to Enable Advanced Understanding of Biomedical Concepts

Published on: September 20, 2018

15.9K
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

Area of Science:

  • Health Informatics
  • Data Standardization
  • Clinical Data Management

Background:

  • Standardizing clinical data with Common Data Models (CDMs) facilitates data understanding and tool reuse.
  • The Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) is a widely adopted standard.
  • Clinical Practice Research Datalink (CPRD) collects valuable general practitioner data in the UK.

Purpose of the Study:

  • To convert a static dataset of CPRD AURUM data into the OMOP CDM.
  • To evaluate the efficacy of existing tools on the converted OMOP CDM data.

Main Methods:

  • Employed direct mapping for CPRD files with comparable OMOP CDM tables (e.g., Patient to Person, Drug Issue to Drug Exposure).
  • Utilized indirect mapping for the CPRD Observation file, assigning data to appropriate OMOP tables/columns based on domain.
  • Converted all source values to standardized OMOP concepts.

Main Results:

  • The OMOP CDM conversion resulted in 12 tables and over 20 billion rows, with the Measurement table being the largest.
  • 60.2% of source concepts were found to be standard OMOP concepts, with the Drug Exposure table having the lowest percentage (4.7%).
  • Minimal data loss occurred, with only 2.00% of rows excluded due to lack of clear fit.

Conclusions:

  • CPRD AURUM data was successfully transformed into the OMOP CDM with minimal data loss.
  • Existing Observational Health Data Sciences and Informatics (OHDSI) tools demonstrated the utility of the converted data.
  • Standardized CPRD AURUM data significantly enhances its potential for future research applications.