Oracle Data Warehouse Management

Description

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