Oracle Data Warehouse Tuning for 10g by Gavin JT Powell | 9781555583354 | Paperback | Barnes & Noble
Oracle Data Warehouse Tuning for 10g

Oracle Data Warehouse Tuning for 10g

by Gavin JT Powell
     
 

ISBN-10: 1555583350

ISBN-13: 9781555583354

Pub. Date: 09/16/2005

Publisher: Elsevier Science

“This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience.”
- Tim Donar, Author and Systems Architect for Enterprise Data Warehouses

Tuning a data warehouse database

Overview

“This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience.”
- Tim Donar, Author and Systems Architect for Enterprise Data Warehouses

Tuning a data warehouse database focuses on large transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame.

A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.

* Takes users beyond basics to critical issues in running most efficient data warehouse applications
• Illustrates how to keep data going in and out in the most productive way possible
• Focus is placed on Data Warehouse performance tuning

Product Details

ISBN-13:
9781555583354
Publisher:
Elsevier Science
Publication date:
09/16/2005
Edition description:
New Edition
Pages:
504
Product dimensions:
7.50(w) x 9.25(h) x 1.00(d)

Table of Contents

Introduction to Data Warehousing; Data Warehouse Data Modeling; Making Hardware and I/O Perform in a Data Warehouse; Data Warehouse Physical Architecture; Effective Data Warehouse Indexing; Constraints and Integrity in Data Warehouses; Using Partitioning and Tuning Parallel Processing; Materialized Views and Query Rewrites; Oracle Dimension Objects; Data Loading: Extraction and Transportation; Data Loading: Loading and Transformation; SQL Aggregation Using GROUP BY Clause Extensions

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >