Review Questions

1.What is a data warehouse? How does it differ from a database?
2.What are the goals of a data warehouse?
3.What are characteristics of data warehouse?
4.What are the different components of a data warehouse? Explain with the help of a diagram.
5.List the benefits and limitations of a data warehouse.
6.Discuss what is meant by the following terms when describing the characteristics of the data in a data warehouse:

  1. subject-oriented

  2. integrated

  3. time-variant

  4. non-volatile.

7.Differentiate between the operational database and data warehouse.
8.Define the terms OLAP, ROLAP and MOLAP.
9.What are OLAP classifications? List the OLAP tools available for commercial applications.
10.Describe the evolution of data warehousing with the half of ...

Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial