Managing evolving code sets and integration of multiple data sources in health care analytics

This paper presents our industry experience related to developing data warehouses for healthcare analytics. With the rapid advancement of medical record digitization, there is a very large amount of information available for analysis. With the heavy focus on driving down health care costs, managing preventive care and improving patient outcomes and satisfaction, there is a growing emphasis on healthcare metrics and analytics. The information for a single patient's history is composed of data from every hospital, provider, lab, pharmacy and insurance company the patient has encountered. This information needs to be viewed as a whole to accurately analyze the patient's health. In turn, each patient's complete health information is needed to accurately evaluate the performance of his or her providers. This paper will address some challenges we have faced when merging and correlating these diverse data sources. We will provide our solutions and experience addressing key challenges including code set integration and migration and patient identification.

[1]  C. Dolea,et al.  World Health Organization , 1949, International Organization.

[2]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[3]  Kent A. Spackman,et al.  SNOMED RT: a reference terminology for health care , 1997, AMIA.

[4]  Patricia Weiser Easteal,et al.  Australian Institute of Criminology 3 American Psychiatric Association Diagnosis and Statistical Manual of Mental Disorders , 1998 .

[5]  R Klar,et al.  Conversion Problems concerning Automated Mapping from lCD-10 to lCD-9 , 1998, Methods of Information in Medicine.

[6]  C. McDonald,et al.  LOINC, a universal standard for identifying laboratory observations: a 5-year update. , 2003, Clinical chemistry.

[7]  Bijan Parsia,et al.  Pellet: An OWL DL Reasoner , 2004, Description Logics.

[8]  L. Stein,et al.  OWL Web Ontology Language - Reference , 2004 .

[9]  Wei Ma,et al.  RxNorm: prescription for electronic drug information exchange , 2005, IT Professional.

[10]  Amnon Shabo,et al.  Model Formulation: HL7 Clinical Document Architecture, Release 2 , 2006, J. Am. Medical Informatics Assoc..

[11]  Werner Ceusters,et al.  HL7 RIM: An Incoherent Standard , 2006, MIE.

[12]  Kensaku Kawamoto,et al.  Viewpoint Paper: The Clinical Document Architecture and the Continuity of Care Record: A Critical Analysis , 2006, J. Am. Medical Informatics Assoc..

[13]  T. Roth,et al.  Patient identification. , 2007, The American journal of managed care.

[14]  Bruce E. Bray,et al.  RxTerms - a drug interface terminology derived from RxNorm , 2008, AMIA.

[15]  Latifur Khan,et al.  RDFKB: efficient support for RDF inference queries and knowledge management , 2009, IDEAS '09.

[16]  Susan C. Weber,et al.  Automated Mapping of Pharmacy Orders from Two Electronic Health Record Systems to RxNorm within the STRIDE Clinical Data Warehouse , 2009, AMIA.

[17]  Deborah Peikes,et al.  Necessary But Not Sufficient: The HITECH Act and Health Information Technology's Potential to Build Medical Homes (White Paper) , 2010 .

[18]  Latifur Khan,et al.  Materializing and Persisting Inferred and Uncertain Knowledge in RDF Datasets , 2010, AAAI.

[19]  Peter R. Orszag,et al.  Health care reform and cost control. , 2010, The New England journal of medicine.

[20]  Susan A. Flocke,et al.  Defining and Measuring the Patient-Centered Medical Home , 2010, Journal of General Internal Medicine.

[21]  D. Blumenthal,et al.  The "meaningful use" regulation for electronic health records. , 2010, The New England journal of medicine.

[22]  Tanya Podchiyska,et al.  Managing Medical Vocabulary Updates in a Clinical Data Warehouse: An RxNorm Case Study. , 2010, AMIA ... Annual Symposium proceedings. AMIA Symposium.

[23]  Latifur Khan,et al.  A Semantic Web Repository for Managing and Querying Aligned Knowledge , 2010, SEMWEB.

[24]  Jeanne S. Ringel,et al.  Analysis of the Patient Protection and Affordable Care Act (H.R. 3590) , 2010 .

[25]  Joshua R. Vest,et al.  Health information exchange: persistent challenges and new strategies , 2010, J. Am. Medical Informatics Assoc..

[26]  D. Berwick,et al.  Launching accountable care organizations--the proposed rule for the Medicare Shared Savings Program. , 2011, The New England journal of medicine.

[27]  Pina C. Sanelli,et al.  Physician Quality Reporting System , 2011, American Journal of Neuroradiology.

[28]  Thomas C Brown,et al.  Current trends in hospital mergers and acquisitions. , 2012, Healthcare financial management : journal of the Healthcare Financial Management Association.

[29]  Egon L. Willighagen,et al.  Emerging practices for mapping and linking life sciences data using RDF - A case series , 2012, J. Web Semant..

[30]  Katherine E Henson,et al.  Risk of Suicide After Cancer Diagnosis in England , 2018, JAMA psychiatry.