Page 92 - DCAP208_Management Support Systems

Unit 6: Data Warehousing

lead to the implementation of enterprise-wide architectures, such as bus architectures, or Notes
department-specific architectures, such as independent data marts.

An urgent need for a data warehouse project, restrictions on economic and human resources,
as well as poor IT staff skills may suggest that a type of “quick” architecture, such as
independent data marts, should be implemented.

The minor role played by a data warehouse project in enterprise strategies can make you
prefer an architecture type based on independent data marts over a hub and spoke
architecture type.
The frequent need for integrating preexisting data warehouses, possibly deployed on
heterogeneous platforms, and the pressing demand for uniformly accessing their data can
require a federated architecture type.

Self Assessment

Fill in the blanks:
6. The goal of ...................... architecture is to minimize the amount of data stored; to reach
this goal, it removes data redundancies.
7. ...................... data warehouse acts as a centralized storage system for all the data being
summed up.

8. The ...................... populated from a primary data warehouse are often called dependent.
9. In ...................... data marts architecture, different data marts are separately designed and
built in a nonintegrated fashion.

6.4 Data Warehouse Development

The sections below provide perspective on each of the critical processes in a data warehouse
development effort. In addition to the details discussed in each section, numerous control
mechanisms and management techniques to facilitate the success of the overall project support
each process.

Figure 6.8: Data Warehouse Development Processes

Source: http://www.grtcorp.com/sites/grtcorp.com/files/DW_Development_Approach.pdf

LOVELY PROFESSIONAL UNIVERSITY 85