Topic 03: Data Warehousing

At the completion of this topic, you should be able to:

Provide a definition of a data warehouse, including examples as to how and in what circumstances it would be used

Describe and provide examples as to the difference between operational and analytical databases

Discuss the components of a data warehouse system

Discuss the basic steps in the development of a data warehouse

Explain the following parts of the data warehouse definition:

Structured repository

Integrated

Subject oriented

Enterprise-wide

Historical

Time-variant

Developed for the retrieval of analytical information

May include data at the fine level of detail of summary data or both

Explain, using examples as appropriate, why a data warehouse would be created as a separate data store?

What are the major components of a data warehouse?

Briefly describe the process of developing data warehouse front-end applications.

Explain, using examples, why the data warehouse design process is an iterative process.