Oracle9ir2 Data Warehousing

by Susan Hillson, Shilpa Lawande, Lilian Hobbs

Written by people on the Oracle development team, this is a how-to guide to using the Data Warehouse features in various versions of Oracle - Oracle 9i Release 1 and Release 2. It provides... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1555582877
• ISBN13: 9781555582876
• Release Date: February 2003
• Publisher: Digital Press
• Length: 519 Pages
• Weight: 2.20 lbs.
• Dimensions: 1.0" x 7.0" x 9.2"

Customer Reviews

Comprehensive, complete, technical publication

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 is 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.

Excellent source on Oracle DW

I found this book to be an excellent source on contemporary Oracle DW. Within relatively small volume (under 500 pages) the authors have managed to present a fairly comprehensive coverage of the most important Oracle DW topics including OLAP, Discoverer,etc. Practical examples in this book have strong educational value. To me, educational is the keyword: the example schema in the book is called EASYDW, not the terabyte DW. I've happened to be strongly disagreed with those reviewers who based on their personal DW experience claim that the book examples are not from the "Real World" pointing, in particular, to: rolling up City to County. Who in the real world does that? I do. In my environment (Tax Analysis DW), that's exactly what is taking place: we are rolling up the sales in individual cities to the county level because Taxation Authority is the county privilege all over the US, not the individual city's one. Overall I strongly recommend this book. Reading Oracle documentation (like it's suggested by someone above) is not a bad idea in general. However I'm sure it will take you much, much longer to cover the same scope of materials, and at the end, you'll have to put all pieces together by yourself. To me, the value of this book is that it serves as a single, solid source on the wide variety of Oracle DW issues involved in practical DW implementation.