Feasibility and utility of applications of the common data model to multiple, disparate observational health databases
- PMID: 25670757
- PMCID: PMC4457111
- DOI: 10.1093/jamia/ocu023
Feasibility and utility of applications of the common data model to multiple, disparate observational health databases
Abstract
Objectives: To evaluate the utility of applying the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) across multiple observational databases within an organization and to apply standardized analytics tools for conducting observational research.
Materials and methods: Six deidentified patient-level datasets were transformed to the OMOP CDM. We evaluated the extent of information loss that occurred through the standardization process. We developed a standardized analytic tool to replicate the cohort construction process from a published epidemiology protocol and applied the analysis to all 6 databases to assess time-to-execution and comparability of results.
Results: Transformation to the CDM resulted in minimal information loss across all 6 databases. Patients and observations excluded were due to identified data quality issues in the source system, 96% to 99% of condition records and 90% to 99% of drug records were successfully mapped into the CDM using the standard vocabulary. The full cohort replication and descriptive baseline summary was executed for 2 cohorts in 6 databases in less than 1 hour.
Discussion: The standardization process improved data quality, increased efficiency, and facilitated cross-database comparisons to support a more systematic approach to observational research. Comparisons across data sources showed consistency in the impact of inclusion criteria, using the protocol and identified differences in patient characteristics and coding practices across databases.
Conclusion: Standardizing data structure (through a CDM), content (through a standard vocabulary with source code mappings), and analytics can enable an institution to apply a network-based approach to observational research across multiple, disparate observational health databases.
Keywords: controlled health services research; database; factual vocabulary; medical informatics observational study.
© The Author 2015. Published by Oxford University Press on behalf of the American Medical Informatics Association.
Figures

Similar articles
-
An evaluation of the THIN database in the OMOP Common Data Model for active drug safety surveillance.Drug Saf. 2013 Feb;36(2):119-34. doi: 10.1007/s40264-012-0009-3. Drug Saf. 2013. PMID: 23329543
-
Standardizing registry data to the OMOP Common Data Model: experience from three pulmonary hypertension databases.BMC Med Res Methodol. 2021 Nov 2;21(1):238. doi: 10.1186/s12874-021-01434-3. BMC Med Res Methodol. 2021. PMID: 34727871 Free PMC article.
-
Transformation of Electronic Health Records and Questionnaire Data to OMOP CDM: A Feasibility Study Using SG_T2DM Dataset.Appl Clin Inform. 2021 Aug;12(4):757-767. doi: 10.1055/s-0041-1732301. Epub 2021 Aug 11. Appl Clin Inform. 2021. PMID: 34380168 Free PMC article.
-
Conceptual design of a generic data harmonization process for OMOP common data model.BMC Med Inform Decis Mak. 2024 Feb 26;24(1):58. doi: 10.1186/s12911-024-02458-7. BMC Med Inform Decis Mak. 2024. PMID: 38408983 Free PMC article. Review.
-
Seamless EMR data access: Integrated governance, digital health and the OMOP-CDM.BMJ Health Care Inform. 2024 Feb 21;31(1):e100953. doi: 10.1136/bmjhci-2023-100953. BMJ Health Care Inform. 2024. PMID: 38387992 Free PMC article. Review.
Cited by
-
Long-term use of proton-pump inhibitor on Alzheimer's disease: a real-world distributed network analysis of six observational Korean databases using a Common Data Model.Ther Adv Neurol Disord. 2022 Nov 8;15:17562864221135700. doi: 10.1177/17562864221135700. eCollection 2022. Ther Adv Neurol Disord. 2022. PMID: 36389281 Free PMC article.
-
Comparative risk of thrombosis with thrombocytopenia syndrome or thromboembolic events associated with different covid-19 vaccines: international network cohort study from five European countries and the US.BMJ. 2022 Oct 26;379:e071594. doi: 10.1136/bmj-2022-071594. BMJ. 2022. PMID: 36288813 Free PMC article.
-
Analysis of treatment pattern of anti-dementia medications in newly diagnosed Alzheimer's dementia using OMOP CDM.Sci Rep. 2022 Mar 15;12(1):4451. doi: 10.1038/s41598-022-08595-1. Sci Rep. 2022. PMID: 35292697 Free PMC article.
-
Preliminary Attainability Assessment of Real-World Data for Answering Major Clinical Research Questions in Breast Cancer Brain Metastasis: Framework Development and Validation Study.J Med Internet Res. 2023 Mar 23;25:e43359. doi: 10.2196/43359. J Med Internet Res. 2023. PMID: 36951923 Free PMC article.
-
AdaDiag: Adversarial Domain Adaptation of Diagnostic Prediction with Clinical Event Sequences.J Biomed Inform. 2022 Oct;134:104168. doi: 10.1016/j.jbi.2022.104168. Epub 2022 Aug 17. J Biomed Inform. 2022. PMID: 35987449 Free PMC article.
References
-
- Schneeweiss S, Avorn J. A review of uses of health care utilization databases for epidemiologic research on therapeutics. J Clin Epidemiol. 2005;58(4):323–337. - PubMed
-
- Madigan D, Stang PE, Berlin JA, et al. A systematic statistical approach to evaluating evidence from observational studies. Ann Rev Stat Appl. 2014;1(1):11–39.
-
- Psaty BM, Furberg CD. COX-2 inhibitors–lessons in drug safety. N Engl J Med. 2005;352 (11):1133–1135. - PubMed
Publication types
MeSH terms
LinkOut - more resources
Full Text Sources
Other Literature Sources
Miscellaneous