Oracle 10g Data Warehousing

by Shilpa Lawande, Lilian Hobbs, Susan Hillson, et al.

Book Overview

Oracle 10g Data Warehousing is a guide to using the Data Warehouse features in the latest version of Oracle --Oracle Database 10g. Written by people on the Oracle development team that designed and... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1555583229
• ISBN13: 9781555583224
• Release Date: December 2004
• Publisher: Digital Press
• Length: 872 Pages
• Weight: 4.05 lbs.
• Dimensions: 1.5" x 7.5" x 9.2"

Customer Reviews

A great resource for novices and intermediate designers to learn the nuts & bolts of data warehous

Why Data warehousing ? While data warehouses have been around for a while, the recent financial crises has compelled the financial institutions to do a better job of accountability (i.e. storing, measuring, and reporting of their business). Why Oracle ? Largest market share of database technology in the corporate world Why this book ? In the absence of this text, if a novice were to build a data warehouse from scratch, they will have to learn data modeling, database design, database administration, ETL, and BI. These subjects are a universe in themselves and will warrant considerable effort in terms of time and resources What I liked about this book (in the order of importance)? ·"doing-by-learning" approach to data warehousing ·the book flows smoothly from conception, design, implementation, administration, and maintenance phases ·where applicable, all the design alternatives are discussed, and best practises are recommended ·a good balance of implementation details either via the OEM (i.e. GUI) or programming (mostly PL/SQL) ·minimal coverage of Oracle Warehouse Builder (Oracle's ETL tool) and Discoverer (Oracle's BI tool). Yes, minimal coverage makes the user aware of the existence of these tools. Anything beyond this is a waste of time, considering neither OWB nor Oracle Discoverer has gained any substantial foot hold in the ETL or BI markets ·excellent use of graphics and screen shoots on a high quality paper Conclusions A great spring board for anybody who wants to experience an "end-to-end" data warehouse implementation What next ? IBM Cognos (for aspiring BI developers) Informatica or DataStage (for aspiring ETL developers) Ralph Kimball's Data Warehouse Toolkit (for data modelers / architects)

Ora-COOKBOOK-le datawarehousing *** Lots of the tools

Practical. Stuffed with example situations and code and pointers. *** I might have added a chapter on Oracle Text. Management systems rely on text pools, related to processes and external interfaces. Its not all numbers, these days. *** Otherwise, this gets an A. *** I've used this book again and again. $$$$$ on the table consulting.

Excellent overview of Oracle 10g Data Warehousing

Lilian Hobbs and company provide a good overview of the data warehousing capabilities of Oracle 10g. In particular, I like the use of EM to manage all aspects of defining the schema and managing the dimensional model including creating an OLAP cube. Ond of the reviewers mentioned that there is no downloadable source. That is not correct. It is available from www.lilianhobbs.com as mentioned in the book.

Very good overall coverage

This book is very useful if you want to get overall coverage of data warehousing related features in Oracle 10g. The book does not covers any topic in details but does covers all areas (SQL, Utilities, OWB, Discoverer, ODM) related to the DW/BI space.

Well I am Happy

Well I found this book extremely useful. Okay so you could wade thru the doc, but this book has everthing in one place with some easy to follow examples. It also encouraged me to take a look at using EM rather than typing everything in on the command line.