Part III: Growth


Chapter List

Chapter 10: Adding Columns
Chapter 11: On-Demand Population
Chapter 12: Subset Dimensions
Chapter 13: Dimension Role Playing
Chapter 14: Snapshots
Chapter 15: Dimension Hierarchies
Chapter 16: Multi-Path and Ragged Hierarchies
Chapter 17: Degenerate Dimensions
Chapter 18: Junk Dimensions
Chapter 19: Multi-Star Schemas

Part Overview

If your starter data warehouse is successful, your users will want more. They may ask you to load more data to the data warehouse. By then, you should be prepared for growth.

Part III discusses how you can extend your data warehouse by

  • adding columns and tables

  • splitting dimensions

  • using dimensions differently and for special purpose

  • adding a derived star and a whole new star



Dimensional Data Warehousing with MySQL. A Tutorial
Dimensional Data Warehousing with MySQL: A Tutorial
ISBN: 0975212826
EAN: 2147483647
Year: 2004
Pages: 149

Similar book on Amazon
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
Successful Business Intelligence: Secrets to Making BI a Killer App
Successful Business Intelligence: Secrets to Making BI a Killer App

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net