The Analytic Information Warehouse (AIW): A platform for analytics using electronic health record data

Journal of Biomedical Informatics

Volumn 46, Issue 3, 2013, Pages 410-424

  Post, Andrew R ^a   Kurc, Tahsin ^a   Cholleti, Sharath ^a   Gao, Jingjing ^a   Lin, Xia ^a   Bornstein, William ^b   Cantrell, Dedra ^b   Levine, David ^c   Hohmann, Sam ^c   Saltz, Joel H ^a  

^a EMORY UNIVERSITY SCHOOL OF MEDICINE   (United States)

^b EMORY UNIVERSITY SCHOOL OF MEDICINE   (United States)

^c UHC   (United States)

Author keywords

Clinical data warehousing; Comparative effectiveness; Healthcare analytics; Quality improvement; Temporal abstraction

Indexed keywords

ACADEMIC MEDICAL CENTERS; CLINICAL DATA WAREHOUSE; COMPARATIVE EFFECTIVENESS; COMPUTING ENVIRONMENTS; ELECTRONIC HEALTH RECORD; HOSPITAL OPERATIONS; QUALITY IMPROVEMENT; TEMPORAL ABSTRACTION;

DATA WAREHOUSES; HEALTH CARE; HOSPITALS; OPEN SYSTEMS; RECORDS MANAGEMENT;

METADATA;

ANALYTIC INFORMATION WAREHOUSE; ARTICLE; COMORBIDITY; DATA ANALYSIS; DATA ANALYSIS SOFTWARE; ELECTRONIC MEDICAL RECORD; HOSPITAL READMISSION; INFORMATION PROCESSING; INFORMATION PROCESSING DEVICE; PHENOTYPE; PRIORITY JOURNAL; SCORING SYSTEM; SEMANTICS; TOTAL QUALITY MANAGEMENT; UNIVERSITY HOSPITAL; VIRTUAL REALITY;

ALGORITHMS; DATABASE MANAGEMENT SYSTEMS; ELECTRONIC HEALTH RECORDS; PATIENT READMISSION; SOFTWARE;

EID: 84878356261     PISSN: 15320464     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.jbi.2013.01.005     Document Type: Article

References (84)

1. Kocher R., Emanuel E.J., DeParle N.A. The affordable care act and the future of clinical medicine: the opportunities and challenges. Ann Intern Med 2010, 153:536-539.
2. Blumenthal D. Implementation of the federal health information technology initiative. N Engl J Med 2011, 365:2426-2431.
3. Blumenthal D. Wiring the health system - origins and provisions of a new federal program. N Engl J Med 2011, 365:2323-2329.
4. National Quality Measures Clearinghouse. Tutorial on quality measures. Agency for Healthcare Research and Quality. <> [accessed 03.04.12]. http://www.qualitymeasures.ahrq.gov/tutorial/index.aspx.
5. Shahian D.M., Wolf R.E., Iezzoni L.I., Kirle L., Normand S.L. Variability in the measurement of hospital-wide mortality rates. N Engl J Med 2010, 363:2530-2539.
6. Bueno H., Ross J.S., Wang Y., Chen J., Vidan M.T., Normand S.L., et al. Trends in length of stay and short-term outcomes among Medicare patients hospitalized for heart failure, 1993-2006. JAMA 2010, 303:2141-2147.
7. Kansagara D., Englander H., Salanitro A., Kagen D., Theobald C., Freeman M., et al. Risk prediction models for hospital readmission: a systematic review. JAMA 2011, 306:1688-1698.
8. Giordano L.A., Elliott M.N., Goldstein E., Lehrman W.G., Spencer P.A. Development, implementation, and public reporting of the HCAHPS survey. Med Care Res Rev 2010, 67:27-37.
9. Fung C.H., Lim Y.W., Mattke S., Damberg C., Shekelle P.G. Systematic review: the evidence that publishing patient care performance data improves quality of care. Ann Intern Med 2008, 148:111-123.
10. Lindenauer P.K., Remus D., Roman S., Rothberg M.B., Benjamin E.M., Ma A., et al. Public reporting and pay for performance in hospital quality improvement. N Engl J Med 2007, 356:486-496.
11. Medicare program; hospital inpatient prospective payment systems for acute care hospitals and the long-term care hospital prospective payment system and fiscal year 2013 rates; hospitals' resident caps for graduate medical education payment purposes; quality reporting requirements for specific providers and for ambulatory surgical centers. Final rule. Federal register, vol. 77; 2012. p. 53257-750.
12. Mouttham A, Peyton L, Kuziemsky C. Leveraging performance analytics to improve integration of care. In: Proceedings of the 3rd workshop on software engineering in health care; 2011. p. 56-62.
13. Gregor S. The nature of theory in information systems. MIS Q 2006, 30:611-642.
14. Brown D.E. Introduction to data mining for medical informatics. Clin Lab Med 2008, 28:9-35. v.
15. Shmueli G., Koppius O. Predictive analytics in information systems research. MIS Q 2011, 35:553-572.
16. Wharam J.F., Weiner J.P. The promise and peril of healthcare forecasting. Am J Manag Care 2012, 18:e82-e85.
17. Jha A.K., DesRoches C.M., Campbell E.G., Donelan K., Rao S.R., Ferris T.G., et al. Use of electronic health records in US hospitals. N Engl J Med 2009, 360:1628-1638.
18. Lowe HJ, Ferris TA, Hernandez PM, Weber SC. STRIDE - an integrated standards-based translational research informatics platform. AMIA Annu Symp Proc 2009:391-5.
19. Murphy S.N., Weber G., Mendis M., Gainer V., Chueh H.C., Churchill S., et al. Serving the enterprise and beyond with informatics for integrating biology and the bedside (i2b2). J Am Med Inform Assoc 2010, 17:124-130.
20. Chute C.G., Beck S.A., Fisk T.B., Mohr D.N. The enterprise data trust at Mayo Clinic: a semantically integrated warehouse of biomedical data. J Am Med Inform Assoc 2010, 17:131-135.
21. Lyman J.A., Scully K., Harrison J.H. The development of health care data warehouses to support data mining. Clin Lab Med 2008, 28:55-71.
22. Kamal J, Liu J, Ostrander M, Santangelo J, Dyta R, Rogers P, et al. Information warehouse - a comprehensive informatics platform for business, clinical, and research applications. AMIA Annu Symp Proc 2010:452-6.
23. Wade T.D., Hum R.C., Murphy J.R. A dimensional bus model for integrating clinical and research data. J Am Med Inform Assoc 2011, 18(Suppl. 1):i96-102.
24. Khuri S.F. The NSQIP: a new frontier in surgery. Surgery 2005, 138:837-843.
25. Lipscomb J., Gillespie T.W. State-level cancer quality assessment and research: building and sustaining the data infrastructure. Cancer J 2011, 17:246-256.
26. Brindis R.G., Fitzgerald S., Anderson H.V., Shaw R.E., Weintraub W.S., Williams J.F. The American College of Cardiology-National Cardiovascular Data Registry (ACC-NCDR): building a national clinical data repository. J Am Coll Cardiol 2001, 37:2240-2245.
27. About UHC. UHC; 2012. <> [accessed 03.05.12]. http://www.uhc.edu/12443.htm.
28. Clinical Data Base/Resource Manager. UHC; 2012. <> [accessed 03.05.12]. http://www.uhc.edu/11536.htm.
29. Chan K.S., Fowles J.B., Weiner J.P. Review: electronic health records and the reliability and validity of quality measures: a review of the literature. Med Care Res Rev 2010, 67:503-527.
30. Kahn M.G., Ranade D. The impact of electronic medical records data sources on an adverse drug event quality measure. J Am Med Inform Assoc 2010, 17:185-191.
31. Benin A.L., Fenick A., Herrin J., Vitkauskas G., Chen J., Brandt C. How good are the data? Feasible approach to validation of metrics of quality derived from an outpatient electronic health record. Am J Med Qual 2011, 26:441-451.
32. Parsons A., McCullough C., Wang J., Shih S. Validity of electronic health record-derived quality measurement for performance monitoring. J Am Med Inform Assoc 2012.
33. Hripcsak G., Knirsch C., Zhou L., Wilcox A., Melton G. Bias associated with mining electronic health records. J Biomed Discov Collab 2011, 6:48-52.
34. O'Malley K.J., Cook K.F., Price M.D., Wildes K.R., Hurdle J.F., Ashton C.M. Measuring diagnoses: ICD code accuracy. Health Serv Res 2005, 40:1620-1639.
35. Pathak J., Wang J., Kashyap S., Basford M., Li R., Masys D.R., et al. Mapping clinical phenotype data elements to standardized metadata repositories and controlled terminologies: the eMERGE Network experience. J Am Med Inform Assoc 2011, 18:376-386.
36. Rea S., Pathak J., Savova G., Oniki T.A., Westberg L., Beebe C.E., et al. Building a robust, scalable and standards-driven infrastructure for secondary use of EHR data: the SHARPn project. J Biomed Inform 2012.
37. eMERGE. eMERGE Network Phenotype Library. eMERGE. <> [accessed 03.04.12]. http://www.mc.vanderbilt.edu/victr/dcc/projects/acc/index.php/Library_of_Phenotype_Algorithms.
38. Pathak J., Pan H., Wang J., Kashyap S., Schad P.A., Hamilton C.M., et al. Evaluating phenotypic data elements for genetics and epidemiological research: experiences from the eMERGE and PhenX Network projects. AMIA Summits Transl Sci Proc 2011, 41-45.
39. Apache License, Version 2.0. The Apache Software Foundation; 2004. <> [accessed 03.04.12]. http://www.apache.org/licenses/LICENSE-2.0.html.
40. Murphy SN, Morgan MM, Barnett GO, Chueh HC. Optimizing healthcare research data warehouse design through past COSTAR query analysis. Proc AMIA Symp 1999:892-6.
41. Kimball R., Ross M. The data warehouse toolkit: the complete guide to dimensional modeling 2002, Wiley Computer Publishing, New York. 2nd ed.
42. Ferranti J.M., Langman M.K., Tanaka D., McCall J., Ahmad A. Bridging the gap: leveraging business intelligence tools in support of patient safety and financial effectiveness. J Am Med Inform Assoc 2010, 17:136-143.
43. Zekry D., Loures Valle B.H., Graf C., Michel J.P., Gold G., Krause K.H., et al. Prospective comparison of 6 comorbidity indices as predictors of 1-year post-hospital discharge institutionalization, readmission, and mortality in elderly individuals. J Am Med Dir Assoc 2012, 13:272-278.
44. Knaus W.A., Wagner D.P., Draper E.A., Zimmerman J.E., Bergner M., Bastos P.G., et al. The APACHE III prognostic system. Risk prediction of hospital mortality for critically ill hospitalized adults. Chest 1991, 100:1619-1636.
45. Levy W.C., Mozaffarian D., Linker D.T., Sutradhar S.C., Anker S.D., Cropp A.B., et al. The Seattle Heart Failure Model: prediction of survival in heart failure. Circulation 2006, 113:1424-1433.
46. Wilson P.W., Meigs J.B., Sullivan L., Fox C.S., Nathan D.M., D'Agostino R.B. Prediction of incident diabetes mellitus in middle-aged adults: the Framingham Offspring Study. Arch Intern Med 2007, 167:1068-1074.
47. Wilson P.W., D'Agostino R.B., Levy D., Belanger A.M., Silbershatz H., Kannel W.B. Prediction of coronary heart disease using risk factor categories. Circulation 1998, 97:1837-1847.
48. Freimer N., Sabatti C. The human phenome project. Nat Genet 2003, 34:15-21.
49. Conway M, Berg RL, Carrell D, Denny JC, Kho AN, Kullo IJ, et al. Analyzing the heterogeneity and complexity of Electronic Health Record oriented phenotyping algorithms. AMIA Annu Symp Proc 2011:274-83.
50. Adlassnig K.P., Combi C., Das A.K., Keravnou E.T., Pozzi G. Temporal representation and reasoning in medicine: research directions and challenges. Artif Intell Med 2006, 38:101-113.
51. Elmasri R., Navathe S.B. Fundamentals of database systems 2000, Addison-Wesley, New York. 3rd ed.
52. SQL:2011 (ISO/IEC 9075-1:2011). International Organization for Standardization (ISO); 2011. <> [accessed 03.04.12]. http://www.iso.org/iso/search.htm?qt=9075&searchSubmit=Search&so rt=rel&type=simple&published=true.
53. Plaisant C, Lam S, Shneiderman B, Smith MS, Roseman D, Marchand G, et al. Searching electronic health records for temporal patterns in patient histories: a case study with Microsoft Amalga. AMIA Annu Symp Proc 2008:601-5.
54. O'Connor MJ, Tu SW, Musen MA. The Chronus II temporal database mediator. Proc AMIA Symp 2002:567-71.
55. Das AK, Musen MA. SYNCHRONUS: a reusable software module for temporal integration. Proc AMIA Symp 2002:195-9.
56. Nigrin D.J., Kohane I.S. Temporal expressiveness in querying a time-stamp-based clinical database. J Am Med Inform Assoc 2000, 7:152-163.
57. Dorda W., Gall W., Duftschmid G. Clinical data retrieval: 25 years of temporal query management at the University of Vienna Medical School. Methods Inf Med 2002, 41:89-97.
58. Stacey M., McGregor C. Temporal abstraction in intelligent clinical data analysis: a survey. Artif Intell Med 2007, 39:1-24.
59. Martins S.B., Shahar Y., Goren-Bar D., Galperin M., Kaizer H., Basso L.V., et al. Evaluation of an architecture for intelligent query and exploration of time-oriented clinical data. Artif Intell Med 2008, 43:17-34.
60. German E., Leibowitz A., Shahar Y. An architecture for linking medical decision-support applications to clinical databases and its evaluation. J Biomed Inform 2009, 42:203-218.
61. Klimov D., Shahar Y., Taieb-Maimon M. Intelligent visualization and exploration of time-oriented data of multiple patients. Artif Intell Med 2010, 49:11-31.
62. O'Connor M.J., Shankar R.D., Parrish D.B., Das A.K. Knowledge-level querying of temporal patterns in clinical research systems. Stud Health Technol Inform 2007, 129:311-315.
63. O'Connor M.J., Shankar R.D., Parrish D.B., Das A.K. Knowledge-data integration for temporal reasoning in a clinical trial system. Int J Med Inform 2009, 78(Suppl. 1):S77-85.
64. Post A.R., Harrison J.H. PROTEMPA: a method for specifying and identifying temporal sequences in retrospective data for patient selection. J Am Med Inform Assoc 2007, 14:674-683.
65. Post AR, Sovarel AN, Harrison JH. Abstraction-based temporal data retrieval for a clinical data repository. AMIA Annu Symp Proc 2007:603-7.
66. Huser V., Narus S.P., Rocha R.A. Evaluation of a flowchart-based EHR query system: a case study of RetroGuide. J Biomed Inform 2010, 43:41-50.
67. Combi C., Keravnou-Papailiou E., Shahar Y. Temporal information systems in medicine 2010, Springer, New York.
68. Combi C., Pozzi G., Rossato R. Querying temporal clinical databases on granular trends. J Biomed Inform 2012, 45:273-291.
69. Shahar Y. A framework for knowledge-based temporal abstraction. Artif Intell 1997, 90:79-133.
70. O'Connor MJ, Das AK. A lightweight model for representing and reasoning with temporal information in biomedical ontologies. In: Proceedings of the third international conference on health informatics; 2010. p. 90-7.
71. Bergun A., Bodenreider O. Accessing and integrating data and knowledge for biomedical research. Yearb Med Inform 2008, 91-101.
72. Sox H.C., Greenfield S. Comparative effectiveness research: a report from the Institute of Medicine. Ann Intern Med 2009, 151:203-205.
73. Post A, Kurc T, Overcash M, Cantrell D, Morris T, Eckerson K, et al. A Temporal abstraction-based extract, transform and load process for creating registry databases for research. AMIA Summits Transl Sci Proc 2011:46-50.
74. Combi C., Oliboni B. Visually defining and querying consistent multi-granular clinical temporal abstractions. Artif Intell Med 2012, 54:75-101.
75. Singh Y, Sood M. Model driven architecture: a perspective. In: IEEE international advance computing conference; 2009. p. 1644-52.
76. Gennari J.H., Musen M.A., Fergerson R.W., Grosso W.E., Crubezy M., Eriksson H., et al. The evolution of Protege: an environment for knowledge-based systems development. Int J Hum-Comput Stud 2003, 58:89-123.
77. Stanford Medical Informatics. The Protege Ontology Editor and Knowledge Acquisition System; 2012. <> [accessed 11.12.12]. http://protege.stanford.edu/.
78. Cholleti S, Post A, Gao J, Lin X, Bornstein W, Cantrell D, et al. Leveraging derived data elements in data analytic models for understanding and predicting hospital readmissions. Proc AMIA Annu Fall Symp 2012:103-11.
79. Kim M, Cobb J, Harrold MJ, Kurc T, Orso A, Saltz J, et al. Efficient regression testing of ontology-driven systems. In: Proceedings of the 2012 international symposium on software testing and analysis; 2012. p. 320-30.
80. Gawande A. The hot spotters. The New Yorker; 2011. <> [accessed 02.05.12]. http://www.newyorker.com/reporting/2011/01/24/110124fa_fact_gawande.
81. Hibernate - JBoss Community. <> [accessed 09.04.12]. http://www.hibernate.org/.
82. Hogan W.R., Wagner M.M. Accuracy of data in computer-based patient records. J Am Med Inform Assoc 1997, 4:342-355.
83. Winslow RL, Saltz J, Foster I, Carr JJ, Ge Y, Miller MI, et al. The CardioVascular Research (CVRG) Grid. In: Proceedings of the AMIA summit on translational, bioinformatics; 2011. p. 77-81.
84. O'Connor MJ, Bingen M, Richards A, Tu SW, Das AK. Web-based exploration of temporal data in biomedicine. In: Proceedings of the 7th international conference on web information systems and technologies; 2011. p. 352-9.