Scully K W, Pates R D, Desper G S, Connors A F, Harrell F E, Pieper K S, Hannan R L, Reynolds R E
University of Virginia Health System, Charlottesville, USA.
Proc AMIA Annu Fall Symp. 1997:32-6.
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.
我们描述了一个临床数据仓库的开发情况，其核心由弗吉尼亚大学健康系统（UVAHS）大型机遗留系统中的四年住院管理和计费数据组成。我们将心脏手术临床数据库和医生计费数据（住院和门诊）与这些数据相链接。未来还将合并其他数据库。使用运行在专用IBM RS/6000小型计算机上的关系数据库管理系统（Sybase）来组装2.5千兆字节的核心数据，这些数据描述了四年期间约10万次住院情况。为了实现便捷的数据查询，该系统配备了一个定制的万维网用户界面，它能自动生成结构化查询语言（SQL）。我们以接受冠状动脉搭桥手术（CABG）的患者为例，展示了所得系统的快速报告功能。我们得出结论，这个信息系统：a）是一种便捷且低成本的方法，可提高UVAHS的数据可用性；b）为临床医生提供了一个监测患者护理和结果的工具；c）构成了一个全面数据库的核心，临床研究可从此展开；d）提供了一个灵活的界面，使各种临床科室能够共享和丰富自己的临床数据。
