title: Architectural design of a data warehouse to support operational and analytical queries across disparate clinical databases.
abstract: As the clinical data warehouse of the New York Presbyterian Hospital has evolved innovative methods of integrating new data sources and providing more effective and efficient data reporting and analysis need to be explored. We designed and implemented a new clinical data warehouse architecture to handle the integration of disparate clinical databases in the institution. By examining the way downstream systems are populated and streamlining the way data is stored we create a virtual clinical data warehouse that is adaptable to future needs of the organization.
authors.affiliation: Department of Biomedical Informatics,Columbia University, New Yourk, NY, USA.
authors.forename: John D
authors.initials: JD
authors.lastname: Chelico
authors.forename: Adam
authors.initials: A
authors.lastname: Wilcox
authors.forename: David
authors.initials: D
authors.lastname: Wajngurt
mesh_terms: D003628:Database Management Systems; D019992:Databases as Topic; D007256:Information Systems; D016347:Medical Records Systems, Computerized; D018511:Systems Integration