DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

18.9. EXERCISES

1. Match the columns:

   fact table dynamic extension file striping block percent used B-Tree index referential integrity check clustered index block percent free bitmapped index data array

   set at high level data address in each entry repeating data group combined data and index segments DBMS finds new extent set at low level candidate for partitioning data addresses in leaf nodes store on separate devices suspend for loading

2. Prepare an outline for a standards manual for your data warehouse. Consider all types of objects and their naming conventions. Indicate why standards are important. Produce a detailed table of contents.

3. Refer back to the STAR schema for orders analysis shown in Figure 10-7. Transform it into a physical model. Show all the components of the physical model. Relate the physical model to the logical model.

4. What are the two common block usage parameters? Using appropriate examples, describe how storage utilization may be improved in the data warehouse by setting these parameters properly. How are the settings different from OLTP systems? Why?

5. As the data warehouse administrator, performance enhancement is high on your list. Highlight the techniques you plan to adopt. For each technique, indicate tasks necessary to implement the technique.