Data Warehouse Case Study

Powerful Essays
Case Study: A Data Warehouse for an Academic Medical Center
Jonathan S. Einbinder, MD, MPH; Kenneth W. Scully, MS; Robert D. Pates, PhD; Jane R. Schubart, MBA, MS; Robert E. Reynolds, MD, DrPH
ABSTRACT The clinical data repository (CDR) is a frequently updated relational data warehouse that provides users with direct access to detailed, flexible, and rapid retrospective views of clinical, administrative, and financial patient data for the University of Virginia Health System. This article presents a case study of the CDR, detailing its five-year history and focusing on the unique role of data warehousing in an academic medical center. Specifically, the CDR must support multiple missions, including research and education, in addition to administration and management. Users include not only analysts and administrators but clinicians, researchers, and students. KEYWORDS • Data warehousing • Database • Academic medical center • Clinical research • Case study • Evaluation Large organizations build data warehouses to “analyze what has occurred within the business across time” in order to obtain “a competitive edge in the marketplace.”1 Many healthcare organizations see data warehousing as a way to facilitate operational efficiency and informed administrative decision making. In the 2000 HIMSS Leadership Survey of more than eleven hundred healthcare professionals, 58 percent of respondents indicated that their organizations were currently creating data warehouses or planned to do so within the next two years.2 However, the missions of academic medical centers extend beyond administrative analysis and decision making. The mission statement for the University of Virginia Health System, for example, refers to
JOURNAL OF HEALTHCARE INFORMATION MANAGEMENT®, vol. 15, no. 2, Summer 2001 © Healthcare Information Management Systems Society and Jossey-Bass, A Publishing Unit of John Wiley & Sons, Inc.

165

166

Einbinder, Scully, Pates, Schubart, Reynolds

“advancement of



References: 1. Kachur, R. J. The Data Warehouse Management Handbook. Upper Saddle River, N.J.: Prentice Hall, 2000. 2. “The Eleventh Annual HIMSS Leadership Survey,” sponsored by IBM. [http://www.himss.org/ survey/2000/survey2000.html]. 2000. 3. Scully, K. W., and others. “Development of an Enterprisewide Clinical Data Repository: Merging Multiple Legacy Databases.” Paper presented at the annual symposium of the American Medical Informatics Association, 1997. 4. Reynolds, R. E., and Knaus, W. A. “Clinical Data Repository Enhancements.” Internal memorandum, University of Virginia, Jan. 30, 1998. 5. Slack, W. V. “Assessing the Clinician’s Use of Computers.” MD Computing, 1993, 10(8), 357–360. 6. Schubart, J. R., and Einbinder, J. S. “Evaluation of a Data Warehouse in an Academic Health Sciences Center.” International Journal of Medical Informatics (forthcoming). 7. Rogers, E. Diffusion of Innovations. (3rd ed.) New York: Free Press, 1983. 8. Schubart, J. R., and Einbinder, J. S. “Evaluation of a Data Warehouse: Understanding User Needs.” Paper presented at the annual symposium of the American Medical Informatics Association, 2000. 9. Halamka, J. D., and others. “Managing Care in an Integrated Delivery System via an Intranet.” Paper presented at the annual symposium of the American Medical Informatics Association, 1998. About the Authors Jonathan S. Einbinder, MD, MPH, is assistant professor of clinical informatics in the Department of Health Evaluation Sciences at the University of Virginia, director of data administration at the University of Virginia Health System, and project director for the CDR. Kenneth W. Scully, MS, is technical director and database administrator for the CDR. Robert D. Pates, PhD, is a developer for the CDR. Jane R. Schubart, MBA, MS, is a lecturer in clinical informatics in the Department of Health Evaluation Sciences at the University of Virginia. Robert E. Reynolds, MD, DrPH, is vice president and interim chief information officer for the University of Virginia and professor of informatics in the Department of Health Evaluation Sciences.

You May Also Find These Documents Helpful

  • Powerful Essays

    Data Warehouse

    • 4241 Words
    • 38 Pages

    Data Warehouse Concepts and Design Contents Data Warehouse Concepts and Design 1 Abstract 2 Abbreviations 2 Keywords 3 Introduction 3 Jarir Bookstore – Applying the Kimball Method 3 Summary from the available literature and Follow a Proven Methodology: Lifecycle Steps and Tracks 4 Issues and Process involved in Implementation of DW/BI system 5 Data Model Design 6 Star Schema Model 7 Fact Table 10 Dimension Table: 11 Design Feature: 12 Identifying the fields from facts/dimensions: MS: 12 Advanced…

    • 4241 Words
    • 38 Pages
    Powerful Essays
  • Powerful Essays

    DATA WAREHOUSES & DATA MINING Term-Paper In Management Support System [pic] Submitted By: Submitted To: Chitransh Naman Anita Ma’am A22-JK903 Lecturer 10900100 MSS ABSTRACT :- Collection of integrated, subject-oriented, time-variant and non-volatile data in support of managements decision making process. Described as the "single point of truth", the "corporate memory", the sole historical register of virtually all transactions…

    • 2771 Words
    • 12 Pages
    Powerful Essays
  • Powerful Essays

    Information Systems Management Research Project ON Data Warehousing and Data Mining Submitted in Partial fulfilment of requirement of award of MBA degree of GGSIPU, New Delhi Submitted By: Swati Singhal (12015603911) Saba Afghan (11415603911) 2011-2013…

    • 2521 Words
    • 11 Pages
    Powerful Essays
  • Best Essays

    Data Warehouse and Crm

    • 3661 Words
    • 15 Pages

    More than Data Warehouse- An insight to Customer Information Ritu Aggrawal – agg_ritu@rediffmail.com Deepshikha Kalra -deepshikha_ishan@yahoo.co.in working with MERI affiliated to GGSIPU, Delhi ABSTRACT The business requirements of an enterprise are constantly changing and the changes are coming at an exponential rate. Like advances in Information Technology have helped companies to quickly match competition. As a result, product quality and cost are no longer significant competitive…

    • 3661 Words
    • 15 Pages
    Best Essays
  • Powerful Essays

    CHAPTER 3 DATABASES AND DATA WAREHOUSES Building Business Intelligence CONTACT INFORMATION: Stephen Haag is the primary author of this chapter. If you have any questions or comments, please direct them to him at shaag@du.edu. THIS CHAPTER/MODULE IN SHORT FORM… This chapter introduces your students to the vitally important role of information in an organization and the various technology tools (databases, DBMSs, data warehouses, and data-mining tools) that facilitate the management…

    • 8422 Words
    • 34 Pages
    Powerful Essays
  • Powerful Essays

    Creating a Data Warehouse

    • 3953 Words
    • 16 Pages

    Creating a Data Warehouse Introduction Data warehouses are the latest buzz in the business world. Not only are they used to store data for reporting and forecasting, but they are part of a decision support system. There are many reasons for creating and using a data warehouse. The data warehouse will support the decisions a business needs to make, usually on a daily basis. The data warehouse collects data, consolidates the data for reporting purposes. Data warehouses are accompanied…

    • 3953 Words
    • 16 Pages
    Powerful Essays
  • Satisfactory Essays

    Erp Data Warehouse

    • 447 Words
    • 2 Pages

    IST/ERP 444 Data Warehouse Homework 1: Definition of Data Warehousing Name: Rallapalli Venkata Pavani Search any resource (Books, Web Sites, Papers, etc.) to find three definitions for Data Warehousing. Include the detailed information (Title, authors and the source of the definitions. For example: “Data warehousing is a collection of decision support technologies, aimed at enabling the knowledge worker (executive, manager, analyst) to make better and faster decisions.”…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Data Warehouse Testing

    • 1191 Words
    • 5 Pages

    Data Warehouse Testing By : Kartikey Brahmkshatriya (M.C.A) Index 1. Introduction 3 2. About Data Warehouse 3 2.1 Data Warehouse definition 3 3. Testing Process for Data warehouse: 3 3.1 Requirements Testing : 3 3.2 Unit Testing : 4 3.3 Integration Testing : 4 3.3.1 Scenarios to be covered in Integration Testing 5 3.3.2 Validating the Report data 5 3.4 User Acceptance Testing 5 4. Conclusion 5 Introduction This document details the testing…

    • 1191 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    What Is a Data Warehouse ?

    • 2434 Words
    • 10 Pages

    Question 1 What is a data warehouse? What problems does it solve for a business? A data warehouse is a place where data is stored for archival purpose, analysis purpose. Usually a data warehouse is either a single computer or many computers servers tied together to create one giant computer systems. Data warehouse solve a lot of problems to companies as it helps to structure files and avoid unnecessary duplication of data. Data warehouse also allows to easily updating data and encourages management…

    • 2434 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Warehouse Case Study

    • 623 Words
    • 3 Pages

    and Warehouse Numbers Item Description and Volume in Palliates Days of Storage and Storage charge Warehouse capacity and balance capacity Customer and warehouse master Inventory and item master Real time inventory and availability status Customer receivables and payables Storage Inventory Receipt Dispatch Customer and Warehouse Numbers Item Description and Volume in Palliates Days of Storage and Storage charge Warehouse capacity and balance capacity Customer and warehouse master…

    • 623 Words
    • 3 Pages
    Good Essays