Oracle Data Warehouse Tuning for 10g

Gavin Powell - Collection Data Management

468 pages, parution le 24/11/2005

Ajouter à une liste

Indisponible

Résumé

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 SOL code is constructed from the data model.

Key features about the book:

Data warehouse data model tuning
Specialized data warehouse Oracle SQL commands and statements
Advanced data warehouse tuning topics perspective
Also indexing, materialized views, query rewrite, dimensions, partitioning, parallel processing, GROUP BY extensions, MODELS, data loading, architectural considerations-EVERYTH ING!

L'auteur - Gavin Powell

Gavin Powell BSc. Comp.Sci., OCR (Oracle Certified Professional), author of Oracle High Performance Tuning for 9i and 10g and Oracle SQL with Carol McCullogh-Dieter, has nineteen years of diverse experience in database administration and development, using both relational and object databases. His applications experience is both procedural and object-oriented. Powell has consulted for software vendors, internet dot-corns, accounting, banking, financial services, travel, construction, retail, mining, shipping, education and training companies in various parts of the world.

Autres livres de Gavin Powell

Oracle Performance Tuning for 10gR2

Découvrir tous les livres de Gavin Powell

Sommaire

Preface
Introduction to Data Warehouse Tuning
Tuning SQL Code in a Data Warehouse
Advanced Topics
A: New Data Warehouse Features in Oracle 10g
B: Sample Schemas
C: Sample Scripting
D: Syntax Conventions
E: Sources of Information
Index

Voir tout

Replier

Avis des lecteurs

5 / 5

Note basée sur 1 commentaire (voir tous les commentaires)

Ajouter votre commentaire

Commentaire de Michel P
publié le 18/01/2008 Acheteur vérifié

Excellent guide !

Après 4 années d'expériences pratiques sur différents Data Warehouse Oracle, je trouve que ce livre est une référence essentielle. Ce livre couvre très bien tous les aspects techniques spécifiques à Oracle.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Elsevier
Auteur(s)	Gavin Powell
Collection	Data Management
Parution	24/11/2005
Nb. de pages	468
Format	19 x 23
Couverture	Broché
Poids	1021g
Intérieur	Noir et Blanc
EAN13	9781555583354
ISBN13	978-1-55558-335-4