List of Figures

• 1-1 Architecture of a Data Warehouse
• 1-2 Architecture of a Data Warehouse with a Staging Area
• 1-3 Architecture of a Data Warehouse with a Staging Area and Data Marts
• 2-1 Fragment of a Third Normal Form Schema
• 2-2 Star Schema
• 2-3 Snowflake Schema
• 2-4 Vector Joins Using Oracle In-Memory Column Store
• 3-1 Logical Design Compared with Physical Design
• 3-2 Typical Levels in a Dimension Hierarchy
• 4-1 Executing a Query Using Bitmap Indexes
• 4-2 Optimizer Calculation: Serial or Parallel?
• 4-3 Partition Pruning
• 4-4 Full Partition-Wise Join
• 4-5 Partial Partition-Wise Join
• 5-1 Transparent Query Rewrite
• 5-2 Overview of Summary Management
• 7-1 Determining PCT Freshness
• 8-1 Registration Phase
• 8-2 Refresh Phase
• 8-3 Unregistration Phase
• 9-1 Sample Rollup for a Customer Dimension
• 9-2 times_dim Dimension with Two Time Hierarchies
• 11-1 The Query Rewrite Process
• 11-2 Query Rewrite Subgraphs
• 11-3 PCT Rewrite and Range-List Partitioning
• 11-4 PCT Rewrite and List Partitioning
• 11-5 Query Rewrite Using Multiple Materialized Views
• 11-6 Constrained Materialized View Selections
• 11-7 PCT and Multiple Materialized View Rewrite
• 12-1 Attribute-Clustered Tables
• 13-1 Partially Stale Zone Map
• 13-2 Zone Map with Dimension Table
• 13-3 Zone Map with Dimension Table and Staleness
• 13-4 Zone Map for a Partitioned Fact Table
• 17-1 Multistage Data Transformation
• 17-2 Pipelined Data Transformation
• 17-3 Table Function Example
• 17-4 Pipelined Parallel Transformation with Fanout
• 18-1 Processing Order
• 18-2 Sliding Window Example
• 18-3 Bucket Assignments
• 19-1 Logical Cubes and Views by Different Users
• 19-2 VECTOR GROUP BY Using Oracle In-Memory Column Store
• 20-1 Stock Chart
• 20-2 Stock Chart Illustrating Which Dates are Mapped to Which Pattern Variables
• 20-3 Stock Chart Showing Which Dates the Measures Correspond to
• 21-1 Model Elements
• 21-2 Model Flow Processing