Architecture and quality in data warehouses: An extended repository approach

Most database researchers have studied data warehouses (DW) in their role a s buffers of materialized views, mediating between update-intensive OLTP sy stems and query-intensive decision support. This neglects the organizationa l role of data warehousing as a means of centralized information flow contr ol. As a consequence, a large number of quality aspects relevant for data w arehousing cannot be expressed with the current DW meta models. This paper makes two contributions towards solving these problems. Firstly, we enrich the meta data about DW architectures by explicit enterprise models. Secondl y, many very different mathematical techniques for measuring or optimizing certain aspects of DW quality are being developed. We adapt the Goal-Questi on-Metric approach from software quality management to a meta data manageme nt environment in order to link these special techniques to a generic conce ptual framework of DW quality. The approach has been implemented in full on top of the ConceptBase repository system and has undergone some validation by applying it to the support of specific quality-oriented methods, tools, and application projects in data warehousing. (C) 1999 Elsevier Science Lt d. All rights reserved.