An integrated data warehouse system: development, implementation, and early outcomes

This paper describes a generic vision of global information flow and the development of an integrated data warehouse system, using clinical data on all patient encounters and administrative data on all operating transactions as part of an integrated health care system. This new integrated data warehouse system has been successfully used for multiple purposes, including patient care, health services research, resource utilization and feasibility studies. During 1999, core analyses included the electronic abstraction, aggregation, and analysis of data on over 400,000 patients. This approach to building a centralized data system comprised of multiple repositories efficiently meets a variety of individual and aggregate information needs, while reducing the need to create duplicate databases.