O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required