Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

Changes in This Release for Oracle Database Data Warehousing Guide

Part I Data Warehouse - Fundamentals

1 Introduction to Data Warehousing Concepts

2 Data Warehousing Logical Design

3 Data Warehousing Physical Design

4 Data Warehousing Optimizations and Techniques

Part II Optimizing Data Warehouses

5 Basic Materialized Views

6 Advanced Materialized Views

7 Refreshing Materialized Views

8 Synchronous Refresh

9 Dimensions

10 Basic Query Rewrite for Materialized Views

11 Advanced Query Rewrite for Materialized Views

12 Attribute Clustering

13 Using Zone Maps

Part III Data Movement/ETL

14 Data Movement/ETL Overview

15 Extraction in Data Warehouses

16 Transportation in Data Warehouses

17 Loading and Transformation in Data Warehouses

Part IV Relational Analytics

18 SQL for Analysis and Reporting

19 SQL for Aggregation in Data Warehouses

20 SQL for Pattern Matching

21 SQL for Modeling

22 Advanced Analytical SQL

Glossary

Index