DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

15.8. EXERCISES

1. Indicate if true or false:

   1. OLAP facilitates interactive queries and complex uses.

   2. A hypercube can be represented by the physical cube.

   3. Slice-and-dice is the same as the rotation of the columns and rows in presentation of data.

   4. DOLAP stands for departmental OLAP.

   5. ROLAP systems store data in a multidimensional, proprietary databases.

   6. The essential difference between ROLAP and MOLAP is in the way data is stored.

   7. OLAP systems need transformed and integrated data.

   8. Data in an OLAP system is rarely summarized.

   9. Multidimensional domain structure (MDS) can represent only up to six dimensrons.

   10. OLAP systems do not handle moving averages.

2. As a senior analyst on the project team of a publishing company exploring the options for a data warehouse, make a case for OLAP. Describe the merits of OLAP and how it will be essential in your environment.

3. Pick any six of Dr. Codd's initial guidelines for OLAP. Give your reasons why the selected six are important for OLAP.

4. You are asked to form a small team to evaluate the MOLAP and ROLAP models and make your recommendations. This is part of the data warehouse project for a large manufacturer of heavy chemicals. Describe the criteria your team will use to make the evaluation and selection.

5. Your company is the largest producer of chicken products, selling to supermarkets, fast-food chains, and restaurants, and also exporting to many countries. The analysts from many offices worldwide expect to use the OLAP system when implemented. Discuss how the project ...