O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

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

18.9. EXERCISES

  1. Match the columns:

    1. fact table

    2. dynamic extension

    3. file striping

    4. block percent used

    5. B-Tree index

    6. referential integrity check

    7. clustered index

    8. block percent free

    9. bitmapped index

    10. data array

    1. set at high level

    2. data address in each entry

    3. repeating data group

    4. combined data and index segments

    5. DBMS finds new extent

    6. set at low level

    7. candidate for partitioning

    8. data addresses in leaf nodes

    9. store on separate devices

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

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