Written by one the world's most widely-read Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle tuning in this concise eBook. With decades of experience using Oracle, Mike Ault shares secrets for Oracle data warehouse management. This fantastic eBook discusses how to tune data warehouse applications and includes a discussion of the dbms_summary package, bitmap indexes and other critical data warehouse techniques.

* Understand Data Systems Architectures. * See Schema Structures For Data Warehousing. * Learn Oracle Enhanced Optimizer Features. * See Oracle8i Data Warehouse Table Options. * Understand Oracle Materialized Views, Summaries and Data Warehousing.

About the Author:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

Table of Contents:

 

Data Systems Architectures  Data Warehouse Concepts  Objectives:  Data Warehouse Terminology  Data Warehouse Storage Structures  Data Warehouse Aggregate Operations  Data Warehouse Structure  Objectives:  Schema Structures For Data Warehousing  Oracle and Data Warehousing    Oracle Features  Objectives:  Oracle Data Warehouse related Features  Oracle Features  Objectives:  Partitioned Tables and Indexes  Oracle Enhanced Parallel DML  Oracle Enhanced Optimizer Features  Oracle Enhanced Index Structures  Oracle Enhanced Internals Features  Backup and Recovery Using RMAN  Data Warehousing

Oracle Features  Objectives:  Oracle8i SQL Enhancements for Data Warehouses  Oracle8i Data Warehouse Table Options  Oracle8i and Tuning of Data Warehouses using Small Test Databases  Procedures in DBMS_STATS  Stabilizing Execution Plans in a Data Warehouse in Oracle  Oracle Materialized Views, Summaries and Data Warehousing  The DBMS_SUMMARY Package in Oracle  DIMENSION Objects in Oracle  Managing CPU Utilization for Data Warehouses in Oracle  Restricting Access by Rows in an Oracle Data Warehouse  DBMS_RLS Package    Data Warehouse Loading  IMPORT-EXPORT  Data Warehouse Tools  An Overview of Oracle Express Server  An Overview of Oracle Discoverer