Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



  Oracle Data Warehouse Management
Secrets of Oracle Data Warehousing

Mike Ault
94 Pages

Only $12.95


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.

Key Features

* 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
 Data Warehouse Terminology
 Data Warehouse Storage Structures
 Data Warehouse Aggregate Operations
 Data Warehouse Structure
 Schema Structures For Data Warehousing
 Oracle and Data Warehousing
 Oracle Features
 Oracle Data Warehouse related Features
 Oracle Features
 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
 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
 Data Warehouse Tools
 An Overview of Oracle Express Server
 An Overview of Oracle Discoverer






 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks