Page 265 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Unit 14: Quality Driven Data Warehouse Design

Almost all current research and practice understand a data warehouse architecture as a stepwise notes
information flow from information sources through materialized views towards analyst clients,
as shown in Figure 14.1.
The key argument pursued in this paper is that the architecture in Figure 14.1 covers only partially
the tasks faced in data warehousing and is therefore unable to even express, let alone support,
a large number of important quality problems and management strategies followed in data
warehouses. To illustrate this point, consider Figure 14.2 which shows the host of knowledge
sources used in the central data warehouse a large German bank has developed for financial
controlling.
Figure 14.2: Multiple Knowledge Sources Influencing the Design of a Real-World Data Warehouse

(a) Loading and refreshing the ODS

(b) Preparing a host of specialized multi-dimensional models

(c) Personalizing information delivery and access to background information

LoveLy professionaL university 259