Skip Headers

Oracle® Database Data Warehousing Guide
10g Release 1 (10.1)

Part Number B10736-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF

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