List of Figures

1-1 Contrasting OLTP and Data Warehousing Environments

1-2 Architecture of a Data Warehouse

1-3 Architecture of a Data Warehouse with a Staging Area

1-4 Architecture of a Data Warehouse with a Staging Area and Data Marts

2-1 Star Schema

2-2 Typical Levels in a Dimension Hierarchy

2-3 Typical Data Warehousing Objects

3-1 Logical Design Compared with Physical Design

5-1 Parallel Execution of a Full Partition-wise Join

5-2 Range and Hash Partitions of a Composite Table

5-3 Partial Partition-Wise Join

5-4 Local Prefixed Index

5-5 Local Nonprefixed Index

5-6 Global Prefixed Partitioned Index

6-1 Executing a Query Using Bitmap Indexes

8-1 Transparent Query Rewrite

8-2 Overview of Summary Management

10-1 Sample Rollup for a Customer Dimension

10-2 times_dim Dimension with Two Time Hierarchies

14-1 Multistage Data Transformation

14-2 Pipelined Data Transformation

14-3 Table Function Example

14-4 Pipelined Parallel Transformation with Fanout

16-1 Publisher Components in a Change Data Capture System

16-2 Subscriber Components in a Change Data Capture System

16-3 Synchronous Change Data Capture Configuration

16-4 Asynchronous HotLog Configuration

16-5 Asynchronous AutoLog Change Data Capture Configuration

17-1 Materialized Views and the SQLAccess Advisor

17-2 SQLAccess Advisor Flowchart

18-1 The Query Rewrite Process

18-2 Query Rewrite Subgraphs

18-3 PCT Rewrite and List Partitioning

18-4 PCT Rewrite and Range-List Partitioning

19-1 Third Normal Form Schema

19-2 Star Schema

19-3 Snowflake Schema

20-1 Logical Cubes and Views by Different Users

21-1 Processing Order

21-2 Sliding Window Example

21-3 Bucket Assignments

22-1 Model Elements

22-2 Model Flow Processing

24-1 Parallel Execution Server Connections and Buffers

24-2 Data Flow Diagram for Joining Tables

24-3 Interoperation Parallelism and Dynamic Partitioning

24-4 Creating a Summary Table in Parallel

24-5 Unusable Free Space (Internal Fragmentation)

24-6 Asynchronous Read