Oracle9iR2 Data Warehousing [Paperback]

Lilian Hobbs (Author), Susan Hillson MS in CIS Boston University (Author), Shilpa Lawande (Author)

Book Description

Publication Date: February 20, 2003

Oracle9iR2 Data Warehousing is a guide to using the Data Warehouse features in the latest versions of Oracle -- Oracle 9i Release 1 and Release 2. Written by people on the Oracle development team that designed and implemented the code, this updated and expanded edition provides an insider's view of how the
Oracle 9i Release 2 software is best used for your application.

It provides a detailed look at a wide range of topics including:
· New techniques to facilitate the ETL process to transform data and load the warehouse
· How to use the Oracle OLAP and Data Mining options
· An entire chapter devoted to using materialized views to radically improve warehouse performance.

This book will show you how to use the Oracle database with tools such as Oracle Discoverer to query the warehouse, generate reports that can be deployed over the web, and gain better insight into your business.

This how-to guide provides step-by-step instructions including screen captures to make it easier to design, build, and optimize performance of the data warehouse or data mart. It is a 'must have' reference for database developers, administrators, and IT professionals who want to get to work now with all of the newest features in Oracle 9i Release 2.

·Based on 9i plus the improvements in Release 2
·Presents concepts with working examples
·Describes best practices and critical implementation tradeoffs, based on users' actual implementations

Editorial Reviews

Review

"By using Oracle 9i, pre-summarizing data, and storing it in materialized views, reports that used to take 2 hours to run now complete in 2 minutes." - Chuck Rozwat, Executive Vice President, Server Technologies, Oracle Corporation

Book Description

Implementing and managing data warehousing with R2 of Oracle9i

See all Editorial Reviews

Product Details

• Paperback: 519 pages
• Publisher: Digital Press; 1 edition (February 20, 2003)
• Language: English
• ISBN-10: 1555582877
• ISBN-13: 978-1555582876
• Product Dimensions: 9.2 x 7 x 1 inches
• Shipping Weight: 2.2 pounds
• Average Customer Review: 2.8 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #3,147,133 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

5.0 out of 5 stars Excellent source on Oracle DW, May 17, 2004

By 

vad roytman (Northbrook, il USA) - See all my reviews

This review is from: Oracle9iR2 Data Warehousing (Paperback)

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.

4 of 6 people found the following review helpful:

2.0 out of 5 stars Spagetti book - no critical mass, May 12, 2003

By 

BK "oradbadev" (SOMERVILLE, NJ USA) - See all my reviews

This review is from: Oracle9iR2 Data Warehousing (Paperback)

The book doesn't provide details required to really understand the various topics. There is no critical mass and touches all the topics. Just stick with the classics - expert one on one oracle by Tom Kyte,Essential Oracle8i Data Warehousing by Gary Dodge and Tim Gorman, you get much more. If one wants oracle9i specific features, go with oracle 9i new features by Robert Freeman.

5.0 out of 5 stars Comprehensive, complete, technical publication, October 8, 2004

By 

Jon Emmons (Plymouth, NH USA) - See all my reviews
(REAL NAME)   

This review is from: Oracle9iR2 Data Warehousing (Paperback)

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.