Tool Support and Data Management for Business Analytics Applications in Healthcare

The data delivery architectures in most enterprises are complex and under documented. When a healthcare manager looks at a report, they want to know exactly what each element or technical expression on a report means, where the values shown originate from and how often they are getting updated. We propose a tool framework that includes: a metadata repository for enterprise data consolidated in the data warehouse; a systematic approach to data lineage mappings across the enterprise data architecture to link business analytics data back to the metadata repository; and tool support to manage metadata, link to it directly from reports, and keep metadata in synch with the data warehouse. We illustrate and evaluate our approach with a prototype implementation and a case study using a healthcare analytics dashboard for managing hospital acquired infections.

[1]  Martin Staudt,et al.  Metadata standards for data warehousing: open information model vs. common warehouse metadata , 2000, SGMD.

[2]  Jennifer Widom,et al.  Lineage tracing for general data warehouse transformations , 2003, The VLDB Journal.

[3]  Esteban Zimányi,et al.  Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications , 2010 .

[4]  Jane Greenberg,et al.  Metadata Generation: Processes, People and Tools , 2005 .

[5]  B. Azvine,et al.  Intelligent Business Analytics — A Tool to Build Decision-Support Systems for eBusinesses , 2003 .

[6]  Joseph L. Breault,et al.  Data mining a diabetic data warehouse , 2002, Artif. Intell. Medicine.

[7]  Kevin Wilkinson,et al.  Data integration flows for business intelligence , 2009, EDBT '09.

[8]  Joseph M. Firestone.  Architectural Evolution in DataWarehousing and Distributed Knowledge Management Architecture , 1998 .

[9]  David J. DeWitt,et al.  Of Objects and Databases: A Decade of Turmoil , 1996, VLDB.

[10]  David F. Lobach,et al.  Medical data mining: knowledge discovery in a clinical data warehouse , 1997, AMIA.

[11]  Marco C. Meier,et al.  Enterprise Management with SAP SEM™/ Business Analytics , 2003 .

[12]  Klaus R. Dittrich,et al.  Metadata management for data warehousing: between vision and reality , 2001, Proceedings 2001 International Database Engineering and Applications Symposium.

[13]  Bettina Berendt,et al.  A Privacy-Protecting Business-Analytics Service for On-Line Transactions , 2008, Int. J. Electron. Commer..

[14]  Robert L. Leitheiser,et al.  Data quality in health care data warehouse environments , 2001, Proceedings of the 34th Annual Hawaii International Conference on System Sciences.

[15]  Alison Scammell,et al.  Handbook of information management , 2001 .

[16]  Daniel Fallman,et al.  Design-oriented human-computer interaction , 2003, CHI '03.

[17]  H. Lehmann,et al.  Clinical Decision Support Systems (cdsss) Have Been Hailed for Their Potential to Reduce Medical Errors Clinical Decision Support Systems for the Practice of Evidence-based Medicine , 2022 .

[18]  Jonathan M. Teich,et al.  Using information systems to measure and improve quality , 1999, Int. J. Medical Informatics.

[19]  Alan R. Hevner,et al.  Design Science in Information Systems Research , 2004, MIS Q..

[20]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit , 2009 .

[21]  Paul Müller,et al.  Multimedia Learning Systems Based on IEEE Learning Object Metadata (LOM). , 2001 .

[22]  Nectaria Tryfona,et al.  starER: a conceptual model for data warehouse design , 1999, DOLAP '99.

[23]  D. Stephens.  The Sarbanes‐Oxley Act , 2005 .

[24]  R. Suganya,et al.  Data Mining Concepts and Techniques , 2010 .

[25]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[26]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[27]  Liam Peyton,et al.  Managing and mapping data lineage for business intelligence and analytics applications in health care , 2011, International Conference on Information Society (i-Society 2011).

[28]  W. H. Inmon,et al.  The data warehouse and data mining , 1996, CACM.

[29]  Bao Yu.  StarChainedER: a Conceptual Model for Data Warehouse Design , 2005 .

[30]  Setsuo Ohsuga,et al.  INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES , 1977 .

[31]  Iluju Kiringa,et al.  The Conceptual Integration Modeling Framework: Abstracting from the Multidimensional Model , 2010, ArXiv.

[32]  Jennifer Widom,et al.  ULDBs: databases with uncertainty and lineage , 2006, VLDB.

[33]  Jennifer Widom,et al.  Tracing the lineage of view data in a warehousing environment , 2000, TODS.

[34]  Johann Eder,et al.  Changes of Dimension Data in Temporal Data Warehouses , 2001, DaWaK.

[35]  Carlo Vercellis,et al.  Business Intelligence: Data Mining and Optimization for Decision Making , 2009 .

[36]  Josef Schiefer,et al.  Enhanced business intelligence - supporting business processes with real-time business analytics , 2005, 16th International Workshop on Database and Expert Systems Applications (DEXA'05).

[37]  Ranjit Bose,et al.  Knowledge management-enabled health care management systems: capabilities, infrastructure, and decision-support , 2003, Expert Syst. Appl..

[38]  Jonathan S. Einbinder,et al.  Evaluation of a data warehouse in an academic health sciences center , 2000, Int. J. Medical Informatics.

[39]  Daniel Power,et al.  Decision Support Systems: From the Past to the Future , 2004, AMCIS.

[40]  Mark Lycett,et al.  A framework for deriving semantic web services , 2007, Inf. Syst. Frontiers.