18.9. EXERCISES
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
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.
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.
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?
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.
Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals 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.