Oracle Data Warehouse Management

Team DDU......Page 1
Notice ......Page 4
Publication Information ......Page 5
Table Of Contents......Page 6
Introduction ......Page 9
Data Systems Architectures ......Page 10
Objectives: ......Page 15
Data Warehouse Terminology ......Page 16
Data Warehouse Storage Structures  ......Page 18
Schema Structures For Data Warehousing  ......Page 19
Oracle7 Data Warehouse related Features ......Page 23
Objectives: ......Page 27
Partitioned Tables and Indexes ......Page 28
Oracle8 Enhanced Parallel DML ......Page 30
Oracle8 Enhanced Optimizer Features  ......Page 32
Oracle8 Enhanced Internals Features  ......Page 33
Backup and Recovery Using RMAN ......Page 34
Oracle8i SQL Enhancements for Data Warehouses  ......Page 35
Oracle8i Data Warehouse Table Options  ......Page 39
Oracle8i and Tuning of Data Warehouses using Small Test Databases  ......Page 44
Procedures in DBMS_STATS ......Page 46
Stabilizing Execution Plans in a Data Warehouse in Oracle8i  ......Page 70
Oracle8i Materialized Views, Summaries and Data Warehousing ......Page 76
The DBMS_SUMMARY Package in Oracle8i  ......Page 82
DIMENSION Objects in Oracle8i ......Page 89
Managing CPU Utilization for Data Warehouses in Oracle8i  ......Page 92
Restricting Access by Rows in an Oracle8i Data Warehouse ......Page 111
DBMS_RLS Package  ......Page 116
Data Warehouse Loading  ......Page 120
IMPORT-EXPORT  ......Page 123
An Overview of Oracle Express Server ......Page 126
An Overview of Oracle Discoverer  ......Page 128
Summary ......Page 129