Skip to content

Oracle Data Warehouse Tuning For 10g

Spend $50 to get a free movie!

ISBN-10: 1555583350

ISBN-13: 9781555583354

Edition: 2006

Authors: Gavin Powell

List price: $101.00
Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

"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…    
Customers also bought

Book details

List price: $101.00
Copyright year: 2006
Publisher: Elsevier Science & Technology
Publication date: 10/4/2005
Binding: Paperback
Pages: 504
Size: 7.25" wide x 9.00" long x 1.25" tall
Weight: 2.288
Language: English

Preface
Introduction to Data Warehouse Tuning
Data Warehouse Data Modeling
The Basics of Data Warehouse Data Modeling
The Relational and Object Data Models
Data Modeling for Data Warehouses
Introducing Data Warehouse Tuning
Let's Build a Data Warehouse
Methods for Tuning a Data Warehouse
Effective Data Warehouse Indexing
The Basics of Indexing
Star Queries and Star Query Transformations
Index Organized Tables and Clusters
Materialized Views and Query Rewrite
What Is a Materialized View?
Materialized View Syntax
Types of Materialized Views
Analyzing and Managing Materialized Views
Making Materialized Views Faster
Oracle Dimension Objects
What Is a Dimension Object?
Dimension Object Syntax
Dimension Object Metadata
Dimension Objects and Performance
Partitioning and Basic Parallel Processing
What Are Partitioning and Parallel Processing?
Partitioned Table Syntax
Tuning Queries with Partitioning
Other Partitioning Tricks
Partitioning Metadata
Tuning SQL Code in a Data Warehouse
The Basics of SQL Query Code Tuning
Basic Query Tuning
How Oracle SQL Is Executed
Tools for Tuning Queries
Aggregation Using Group By Clause Extensions
What Are Group By Clause Extensions?
Group By Clause Extensions
Group By Clause Extensions and Materialized Views
Combining Groupings Together
Analysis Reporting
What Is Analysis Reporting?
Types of Analysis Reporting
Introducing Analytical Functions
Specialized Analytical Syntax
Analysis in Practice
Modeling with the MODEL Clause
What Is the MODEL Clause?
MODEL Clause Syntax
What Can the MODEL Clause Do?
Performance and the MODEL Clause
Advanced Topics
Query Rewrite
What Is Query Rewrite?
How the Optimizer Rewrites Queries
Affecting Query Rewrite Performance
Parallel Processing
What Is Parallel Processing?
Degree of Parallelism (Syntax)
Configuration Parameters
Demonstrating Parallel Execution
Performance Views
Parallel Execution Hints
Parallel Execution Query Plans
Data Loading
What Is Data Loading?
Extraction
Transportation Methods
Loading and Transformation
Data Warehouse Architecture
What Is a Data Warehouse?
Tuning Hardware Resources for Data Warehousing
Capacity Planning
OLAP and Data Mining
New Data Warehouse Features in Oracle Database 10g
Sample Schemas
Sample Scripting
Syntax Conventions
Sources of Information
Index