The Generalized Data Model for clinical research

BackgroundMost healthcare data sources store information within their own unique schemas, making reliable and reproducible research challenging. Consequently, researchers have adopted various data models to improve the efficiency of research. Transforming and loading data into these models is a labor-intensive process that can alter the semantics of the original data. Therefore, we created a data model with a hierarchical structure that simplifies the transformation process and minimizes data alteration.MethodsThere were two design goals in constructing the tables and table relationships for the Generalized Data Model (GDM). The first was to focus on clinical codes in their original vocabularies to retain the original semantic representation of the data. The second was to retain hierarchical information present in the original data while retaining provenance. The model was tested by transforming synthetic Medicare data; Surveillance, Epidemiology, and End Results data linked to Medicare claims; and electronic health records from the Clinical Practice Research Datalink. We also tested a subsequent transformation from the GDM into the Sentinel data model.ResultsThe resulting data model contains 19 tables, with the Clinical Codes, Contexts, and Collections tables serving as the core of the model, and containing most of the clinical, provenance, and hierarchical information. In addition, a Mapping table allows users to apply an arbitrarily complex set of relationships among vocabulary elements to facilitate automated analyses.ConclusionsThe GDM offers researchers a simpler process for transforming data, clear data provenance, and a path for users to transform their data into other data models. The GDM is designed to retain hierarchical relationships among data elements as well as the original semantic representation of the data, ensuring consistency in protocol implementation as part of a complete data pipeline for researchers.

[1]  Bruce E. Bray,et al.  Architecture of a Federated Query Engine for Heterogeneous Resources , 2009, AMIA.

[2]  Kenneth D. Mandl,et al.  Data interchange using i2b2 , 2016, J. Am. Medical Informatics Assoc..

[3]  Richard Platt,et al.  Launching PCORnet, a national patient-centered clinical research network , 2014, Journal of the American Medical Informatics Association : JAMIA.

[4]  Deborah H. Batson,et al.  Data model considerations for clinical effectiveness researchers. , 2012, Medical care.

[5]  Kavishwar B. Wagholikar,et al.  Web services for data warehouses: OMOP and PCORnet on i2b2 , 2018, J. Am. Medical Informatics Assoc..

[6]  Andrew Bate,et al.  An Evaluation of the THIN Database in the OMOP Common Data Model for Active Drug Safety Surveillance , 2013, Drug Safety.

[7]  Patrick B. Ryan,et al.  Validation of a common data model for active safety surveillance research , 2012, J. Am. Medical Informatics Assoc..

[8]  Brian Macisaac,et al.  Common data model , 1999 .

[9]  A. Bate,et al.  Evidence generation from healthcare databases: recommendations for managing change , 2016, Pharmacoepidemiology and drug safety.

[10]  Griffin M. Weber,et al.  Serving the enterprise and beyond with informatics for integrating biology and the bedside (i2b2) , 2010, J. Am. Medical Informatics Assoc..

[11]  Olivier Bodenreider,et al.  The Unified Medical Language System (UMLS): integrating biomedical terminology , 2004, Nucleic Acids Res..

[12]  Hilde van der Togt,et al.  Publisher's Note , 2003, J. Netw. Comput. Appl..

[13]  Z. Obermeyer,et al.  Identification of Emergency Department Visits in Medicare Administrative Claims: Approaches and Implications , 2017, Academic emergency medicine : official journal of the Society for Academic Emergency Medicine.

[14]  Vivienne J. Zhu,et al.  Feasibility and utility of applications of the common data model to multiple, disparate observational health databases , 2015, J. Am. Medical Informatics Assoc..

[15]  K. Bhaskaran,et al.  Data Resource Profile: Clinical Practice Research Datalink (CPRD) , 2015, International journal of epidemiology.

[16]  Marsha A Raebel,et al.  Design considerations, architecture, and use of the Mini‐Sentinel distributed data system , 2012, Pharmacoepidemiology and drug safety.

[17]  Bonnie K. Lind,et al.  Challenges of Using Medical Insurance Claims Data for Utilization Analysis , 2006, American journal of medical quality : the official journal of the American College of Medical Quality.

[18]  Bruce M Psaty,et al.  Mini-Sentinel and regulatory science--big data rendered fit and functional. , 2014, The New England journal of medicine.

[19]  Deborah Schrag,et al.  Overview of the SEER-Medicare Data: Content, Research Applications, and Generalizability to the United States Elderly Population , 2002, Medical care.

[20]  S. Papson.  “Model” , 1981 .

[21]  Jing Huang,et al.  An Empirical Study for Impacts of Measurement Errors on EHR based Association Studies , 2016, AMIA.

[22]  Jeffrey Dean,et al.  Scalable and accurate deep learning with electronic health records , 2018, npj Digital Medicine.

[23]  Andrew Bate,et al.  A Comparative Assessment of Observational Medical Outcomes Partnership and Mini-Sentinel Common Data Models and Analytics: Implications for Active Drug Safety Surveillance , 2015, Drug Safety.

[24]  L. Wilson,et al.  Overview of the Surveillance, Epidemiology, and End Results database: evolution, data variables, and quality assurance. , 2012, Current problems in cancer.

[25]  Adler J. Perotte,et al.  Feasibility of Converting the Medicare Synthetic Public Use Data Into a Standardized Data Model for Clinical Research Informatics , 2015, American Medical Informatics Association Annual Symposium.

[26]  Timothy L Lash,et al.  Quantitative Bias Analysis in Regulatory Settings. , 2016, American journal of public health.

[27]  Lisa M. Schilling,et al.  Dynamic-ETL: a hybrid approach for health data extraction, transformation and loading , 2017, BMC Medical Informatics and Decision Making.