List of Figures


Chapter 1: Basic Components

Figure 1.1: A one-star dimensional schema

Chapter 9: Regular Population Scheduling

Figure 9.1: The first window of the Scheduled Task Wizard
Figure 9.2: Selecting an application to schedule
Figure 9.3: Entering a name and select a schedule
Figure 9.4: Setting the time
Figure 9.5: Entering Windows user name and password to run the task
Figure 9.6: The next window
Figure 9.7: The Advanced Properties window
Figure 9.8: Setting account information
Figure 9.9: Your DW Regular Load task

Chapter 10: Adding Columns

Figure 10.1: New columns in customer_dim and sales_order_fact

Chapter 11: On-Demand Population

Figure 11.1: The new promo_ind column in date_dim

Chapter 13: Dimension Role Playing

Figure 13.1: Adding request_delivery_date to sales_order_fact

Chapter 14: Snapshots

Figure 14.1: The schema for the sales order monthly snapshot
Figure 14.2: The schema for accumulating snapshots

Chapter 15: Dimension Hierarchies

Figure 15.1: Schema Showing Hierarchies

Chapter 16: Multi-Path and Ragged Hierarchies

Figure 16.1: The schema after adding campaign_session

Chapter 17: Degenerate Dimensions

Figure 17.1: The schema with the order dimension degenerated

Chapter 18: Junk Dimensions

Figure 18.1: The schema with the sales_order_attribute_dim junk dimension

Chapter 19: Multi-Star Schemas

Figure 19.1: A three-star dimensional data warehouse schema

Chapter 21: Factless Facts

Figure 21.1: Fact-less fact table

Chapter 23: Dimension Consolidation

Figure 23.1: The schema after zip_code_dim is added

Chapter 24: Accumulated Measures

Figure 24.1: The month_end_balance_fact, product_dim, and month_dim tables create a new star

Chapter 25: Band Dimensions

Figure 25.1: The annual sales order schema with the annual_order_segment_dim band dimension



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