Page 98 - DCAP208_Management Support Systems

Unit 6: Data Warehousing

Notes
Knowledge transfer means that the data warehouse is now fully operated by the client.
And like any successful data warehouse project, it continues to grow. “It is very satisfying
to know that this data warehouse continues to provide the sound infrastructure that’s so
important to high quality information delivery.” Says Clare Somerville, Knoware Director.
Question

Discuss the concept of Verification processes in data warehousing.
Source: http://www.knoware.co.nz/large-data-warehouse-case-study

6.6 Summary

Data Warehouse collects and stores integrated sets of historical data from multiple
operational systems and feeds them to one or more data marts.
Data warehouses are subject-oriented because they hinge on enterprise-specific concepts,
such as customers, products, sales, and orders.

Among the greatest benefits of a data warehouse is the ability to analyze and execute
business decisions based on data from multiple sources.

Organizations continuously collect data, information, and knowledge at an increasingly
accelerated rate and store them in computerized systems.
ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling
data out of the source systems and placing it into a data warehouse.

The Data Warehouse Architecture provides an integrated data warehouse environment
while delivering incremental solutions.

A single-layer architecture minimize the amount of data stored; to reach this goal, it
removes data redundancies.
Data Warehouse Administrator (DWA) is a person responsible for the administration and
management of a data warehouse.

6.7 Keywords

Business Requirements Definition: The Business Requirements Definition process defines the
requirements, clarifies the scope, and establishes the implementation roadmap for the data
warehouse.
Data Acquisition: Data Acquisition process identifies, extracts, transforms, and transports the
various source data necessary for the operation of the data warehouse.
Data Mart: It is a data structure that is optimized for access which is designed to facilitate
end-user analysis of data.
Data Warehouse: The data warehouse is that portion of an overall Architected Data Environment
that serves as the single integrated source of data for processing information.

DWA: Data Warehouse Administrator (DWA) is a person responsible for the administration and
management of a data warehouse.
ETL: ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling
data out of the source systems and placing it into a data warehouse.

LOVELY PROFESSIONAL UNIVERSITY 91