Oracle 9iR2 Data WarehousingAbout a year an a half ago I was right in the middle of researching data warehouse technologies and starting to get quite discouraged on the lack of good technical books on the topic. Then I came across the book “Oracle9iR2 Data Warehousing” by Hobbs, Hillson and Lawande. Here’s the review I put on Amazon on this deep technical book.

In this book, the authors take you swiftly and thoroughly through the entire process of creating a data warehouse. Several other books (I purchased 4 others before this) over-generalize the topic, teaching the vocabulary and business reasons for data warehousing. This book teaches how to implement a warehouse in Oracle 9i Revision 2, while teaching the major concepts through practical application.

It would be easy to get bogged down in the technical details of this book if one were not familiar with the Oracle environment. Those who are familiar with Oracle will find it is much like the courses offered by Oracle. The book consistently, clearly presents the concepts (dimensions, fact tables, summaries, ETL) then delves into such depth it leaves the reader with a complete understanding of not only how to implement each concept, but when, and why to implement them.

The major concepts covered include dimensional modeling, data partitioning, query optimization, materialized views, dimensions, the extract-transform-load process, warehousing tools, ongoing warehouse maintenance, and many more. Furthermore, SQL for the examples used in the book are available from one of the authors websites, affording the reader a hands-on environment in which to observe these concepts.

Overall, I would recommend this book to anyone looking to work with warehousing who already has a firm Oracle background (strong knowledge of schemas, data dictionary, storage conventions, terminology.) This is simply the best book I have found on data warehousing.

I see that there is now a new version of this book out. “Oracle Database 10g Data Warehousing” by the same authors, plus Pete Smith, will go on my short list for tech books to buy.

oracle, data warehouse, database, dba, database administration, data warehousing