title: The Analytic Information Warehouse (AIW): a platform for analytics using electronic health record data.
abstract: OBJECTIVE
  To create an analytics platform for specifying and detecting clinical phenotypes and other derived variables in electronic health record (EHR) data for quality improvement investigations.
  
  
  METHODS
  We have developed an architecture for an Analytic Information Warehouse (AIW). It supports transforming data represented in different physical schemas into a common data model, specifying derived variables in terms of the common model to enable their reuse, computing derived variables while enforcing invariants and ensuring correctness and consistency of data transformations, long-term curation of derived data, and export of derived data into standard analysis tools. It includes software that implements these features and a computing environment that enables secure high-performance access to and processing of large datasets extracted from EHRs.
  
  
  RESULTS
  We have implemented and deployed the architecture in production locally. The software is available as open source. We have used it as part of hospital operations in a project to reduce rates of hospital readmission within 30days. The project examined the association of over 100 derived variables representing disease and co-morbidity phenotypes with readmissions in 5years of data from our institution's clinical data warehouse and the UHC Clinical Database (CDB). The CDB contains administrative data from over 200 hospitals that are in academic medical centers or affiliated with such centers.
  
  
  CONCLUSIONS
  A widely available platform for managing and detecting phenotypes in EHR data could accelerate the use of such data in quality improvement and comparative effectiveness studies.
authors: Department of Biomedical Informatics, Emory University, 36 Eagle Row, Atlanta, GA 30322, USA. arpost@emory.edu
authors: Andrew R
authors: AR
authors: Post
authors: Tahsin
authors: T
authors: Kurc
authors: Sharath
authors: S
authors: Cholleti
authors: Jingjing
authors: J
authors: Gao
authors: Xia
authors: X
authors: Lin
authors: William
authors: W
authors: Bornstein
authors: Dedra
authors: D
authors: Cantrell
authors: David
authors: D
authors: Levine
authors: Sam
authors: S
authors: Hohmann
authors: Joel H
authors: JH
authors: Saltz
mesh_terms: D000465:Algorithms; D003628:Database Management Systems; D057286:Electronic Health Records; D010359:Patient Readmission; D012984:Software
references: Med Care Res Rev. 2010 Feb;67(1):27-37
references: 19638641
references: J Biomed Discov Collab. 2011 Jun 06;6:48-52
references: 21647858
references: Artif Intell Med. 2007 Jan;39(1):1-24
references: 17011175
references: Chest. 1991 Dec;100(6):1619-36
references: 1959406
references: AMIA Annu Symp Proc. 2008 Nov 06;:601-5
references: 18999158
references: JAMA. 2010 Jun 2;303(21):2141-7
references: 20516414
references: AMIA Jt Summits Transl Sci Proc. 2011;2011:41-5
references: 22211178
references: AMIA Annu Symp Proc. 2012;2012:103-11
references: 23304278
references: J Biomed Inform. 2012 Apr;45(2):273-91
references: 22155334
references: Ann Intern Med. 2008 Jan 15;148(2):111-23
references: 18195336
references: Proc AMIA Symp. 1999;:892-6
references: 10566489
references: N Engl J Med. 2007 Feb 1;356(5):486-96
references: 17259444
references: Arch Intern Med. 2007 May 28;167(10):1068-74
references: 17533210
references: Circulation. 1998 May 12;97(18):1837-47
references: 9603539
references: Cancer J. 2011 Jul-Aug;17(4):246-56
references: 21799333
references: J Am Med Inform Assoc. 2012 Jul-Aug;19(4):604-9
references: 22249967
references: J Pain Palliat Care Pharmacother. 2008;22(4):306-11
references: 21923316
references: Clin Lab Med. 2008 Mar;28(1):9-35, v
references: 18194716
references: Ann Intern Med. 2010 Oct 19;153(8):536-9
references: 20733178
references: Artif Intell Med. 2010 May;49(1):11-31
references: 20303245
references: J Am Med Inform Assoc. 2007 Sep-Oct;14(5):674-83
references: 17600103
references: AMIA Annu Symp Proc. 2010 Nov 13;2010:452-6
references: 21347019
references: J Am Med Inform Assoc. 2011 Jul-Aug;18(4):376-86
references: 21597104
references: Proc AMIA Symp. 2002;:567-71
references: 12474882
references: AMIA Annu Symp Proc. 2007 Oct 11;:603-7
references: 18693907
references: Nat Genet. 2003 May;34(1):15-21
references: 12721547
references: Health Serv Res. 2005 Oct;40(5 Pt 2):1620-39
references: 16178999
references: Ann Intern Med. 2009 Aug 4;151(3):203-5
references: 19567618
references: Stud Health Technol Inform. 2007;129(Pt 1):311-5
references: 17911729
references: Artif Intell Med. 2012 Feb;54(2):75-101
references: 22177662
references: J Am Med Inform Assoc. 2010 Mar-Apr;17(2):185-91
references: 20190062
references: Clin Lab Med. 2008 Mar;28(1):55-71, vi
references: 18194718
references: Artif Intell Med. 1996 Jul;8(3):267-98
references: 8830925
references: N Engl J Med. 2011 Dec 22;365(25):2426-31
references: 22187990
references: Artif Intell Med. 2008 May;43(1):17-34
references: 18442899
references: J Biomed Inform. 2010 Feb;43(1):41-50
references: 19560553
references: J Am Med Inform Assoc. 1997 Sep-Oct;4(5):342-55
references: 9292840
references: N Engl J Med. 2011 Dec 15;365(24):2323-9
references: 22168647
references: J Am Med Inform Assoc. 2010 Mar-Apr;17(2):124-30
references: 20190053
references: Am J Manag Care. 2012 Mar 01;18(3):e82-5
references: 22435964
references: AMIA Jt Summits Transl Sci Proc. 2011;2011:46-50
references: 22211179
references: Yearb Med Inform. 2008;:91-101
references: 18660883
references: Proc AMIA Symp. 2002;:195-9
references: 12463814
references: J Am Med Inform Assoc. 2010 Mar-Apr;17(2):131-5
references: 20190054
references: J Am Med Inform Assoc. 2010 Mar-Apr;17(2):136-43
references: 20190055
references: J Am Med Dir Assoc. 2012 Mar;13(3):272-8
references: 21450226
references: AMIA Annu Symp Proc. 2009 Nov 14;2009:391-5
references: 20351886
references: Methods Inf Med. 2002;41(2):89-97
references: 12061129
references: Fed Regist. 2012 Aug 31;77(170):53257-750
references: 22937544
references: Surgery. 2005 Nov;138(5):837-43
references: 16291383
references: J Biomed Inform. 2009 Apr;42(2):203-18
references: 19027088
references: J Am Med Inform Assoc. 2011 Dec;18 Suppl 1:i96-102
references: 21856687
references: AMIA Annu Symp Proc. 2011;2011:274-83
references: 22195079
references: J Am Coll Cardiol. 2001 Jun 15;37(8):2240-5
references: 11419906
references: J Am Med Inform Assoc. 2000 Mar-Apr;7(2):152-63
references: 10730599
references: Int J Med Inform. 2009 Apr;78 Suppl 1:S77-85
references: 18789876
references: J Biomed Inform. 2012 Aug;45(4):763-71
references: 22326800
references: Circulation. 2006 Mar 21;113(11):1424-33
references: 16534009
references: JAMA. 2011 Oct 19;306(15):1688-98
references: 22009101
references: N Engl J Med. 2010 Dec 23;363(26):2530-9
references: 21175315
references: Med Care Res Rev. 2010 Oct;67(5):503-27
references: 20150441
references: N Engl J Med. 2009 Apr 16;360(16):1628-38
references: 19321858
references: Artif Intell Med. 2006 Oct;38(2):101-13
references: 17081736
references: Am J Med Qual. 2011 Nov-Dec;26(6):441-51
references: 21926280