Oracle Data Warehouse Tuning for 10g

Gavin Powell

Publisher Elsevier Digital Press
ISBN 978-1-55558-335-4
RRP £39.99
Reviewed by Adrian Hibbert
Score 8 out of 10

OracleTuning A data warehouse is not the same as a normalized relational database which has been optimised for transactional processing. A data warehouse is optimized for reporting purposes.

This book covers the considerations for converting a database optimized for online transaction processing (OLTP) into a data warehouse hosted on the Oracle 10g platform.

The intended audience is Oracle developers and database administrators, but a much wider audience will benefit from most, if not all of the content of this book.

The author takes nothing for granted. The opening chapters are spent explaining exactly what a database warehouse is, how it differs from an OLTP database and exactly what the reasons are for these differences. This is obviously excellent news for all those who happily talk about data warehouses on a day-to-day basis without knowing what one is. And even better news if you are planning to build one for the Oracle platform.

Techniques for modelling a data warehouse are discussed using an example scenario. The concepts of facts and dimensions are clearly explained as are the different schemas one might consider when designing a data warehouse. The author takes the user through the process of denormalization to illustrate how one might arrive at a specific design for the data warehouse.

The author makes effective use of bulleted lists to deliver the key points, all of which are made with the authority of someone who has had significant experience working with very large databases.

Different types of database indexes are discussed, before the author touches on the specifics of Oracle 10g, from which point he describes everything one needs to know to build an effective data warehouse on the 10g platform. The author highlights new features of 10g which are designed specifically for the data warehouse engineer, and the data analyst. The discussion includes methods for optimizing SQL for the 10g platform.

Given the breadth of content of this book and the quality of the professional tips within, it is a highly recommended read for anyone wishing to learn about data warehousing and wishing to find out what one can expect from a platform which supports data warehousing.

More information: Elsevier website