title: Designing a Clinical Data Warehouse Architecture to Support Quality Improvement Initiatives.
abstract: Clinical data warehouses, initially directed towards clinical research or financial analyses, are evolving to support quality improvement efforts, and must now address the quality improvement life cycle. In addition, data that are needed for quality improvement often do not reside in a single database, requiring easier methods to query data across multiple disparate sources. We created a virtual data warehouse at NewYork Presbyterian Hospital that allowed us to bring together data from several source systems throughout the organization. We also created a framework to match the maturity of a data request in the quality improvement life cycle to proper tools needed for each request. As projects progress in the Define, Measure, Analyze, Improve, Control stages of quality improvement, there is a proper matching of resources the data needs at each step. We describe the analysis and design creating a robust model for applying clinical data warehousing to quality improvement.
authors.affiliation: Northwell Health, Manhasset, NY.
authors.forename: John D
authors.initials: JD
authors.lastname: Chelico
authors.affiliation: University of Washington, Seattle, WA.
authors.forename: Adam B
authors.initials: AB
authors.lastname: Wilcox
authors.affiliation: NewYork Presbyterian Hospital, New York, NY.
authors.forename: David K
authors.initials: DK
authors.lastname: Vawdrey
authors.affiliation: NewYork Presbyterian Hospital, New York, NY.
authors.forename: Gilad J
authors.initials: GJ
authors.lastname: Kuperman
mesh_terms: D003628:Database Management Systems; D019992:Databases as Topic / Q000458:organization & administration*; D006751:Hospital Information Systems; D006785:Hospitals, University / Q000458:organization & administration*; D016347:Medical Records Systems, Computerized; D009519:New York City; D058996:Quality Improvement; D018511:Systems Integration