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

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

  Oracle Data Warehouse Management
Secrets of Oracle Data Warehousing


Mike Ault
ISBN:
0-9740716-4-1
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
 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

 

 

 

 

   

 Copyright © 1996 -2016 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