Abstract
We describe the development of a clinical data repository whose core consists of four years of inpatient administrative and billing data from the mainframe legacy systems of the University of Virginia Health System (UVAHS). To these data we have linked a cardiac surgery clinical database and our physician billing data (inpatient and outpatient). Other databases will be merged in the future. A relational database management system (Sybase) running on a dedicated IBM RS/6000 minicomputer was employed to assemble 2.5 Gigabytes of core data describing approximately 100,000 hospital admissions over the four year period. To enable convenient data queries, the system has been equipped with a custom-built WWW user interface, which generates Structured Query Language (SQL) automatically. We illustrate the rapid reporting capabilities of the resulting system with reference to patients undergoing coronary artery bypass graft surgery (CABG). We conclude that this information system: a) constitutes a convenient and low-cost method to increase data availability across the UVAHS; b) provides clinicians with a tool for surveillance of patient care and outcomes; c) forms the core of a comprehensive database from which clinical research may proceed; d) provides a flexible interface empowering a wide variety of clinical departments to share and enrich their own clinical data.
Full text
PDF
Selected References
These references are in PubMed. This may not be the complete list of references from this article.
- Gendler S. M., Friedman B. A., Henricks W. H., 3rd Using hub technology to facilitate information system integration in a health-care enterprise. Am J Clin Pathol. 1996 Apr;105(4 Suppl 1):S25–S32. [PubMed] [Google Scholar]
- Prather J. C., Lobach D. F., Hales J. W., Hage M. L., Fehrs S. J., Hammond W. E. Converting a legacy system database into relational format to enhance query efficiency. Proc Annu Symp Comput Appl Med Care. 1995:372–376. [PMC free article] [PubMed] [Google Scholar]
- Ruffin M. Developing and using a data repository for quality improvement: the genesis of IRIS. Jt Comm J Qual Improv. 1995 Oct;21(10):512–520. doi: 10.1016/s1070-3241(16)30177-8. [DOI] [PubMed] [Google Scholar]