Oracle 10g Data Warehousing

Features

• Cover Type: Paperback with 872 pages
• Published by: Digital Press November 17, 2004
• Written in: English
• ISBN 10 Number: 1555583229
• ISBN 13 Number: 978-1555583224
• Book Dimensions: 9 x 7.4 x 1.6 inches
• Weighs: 3.8 pounds

Product Review
"Whether you are designing a large or small data warehouse, or looking for tips on how to improve performance using Oracle Database 10g, this book will provide you with advice and examples you can follow. It also includes thorough coverage of the data warehouse features in Oracle Database 10g, and the tools in Oracle Application Server 10g." Chuck Rozwat, Executive Vice President, Server Technologies, Oracle Corporation

Book Description
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 implemented the code and by people with industry experience implementing warehouses using Oracle technology, this thoroughly updated and extended edition provides an insiders view of how the Oracle Database 10g software is best used for your application.

It provides a detailed look at the new features of Oracle Database 10g and other Oracle products and how these are used in the data warehouse. This book will show you how to deploy the Oracle database and correctly use the new Oracle Database 10g features for your data warehouse. It contains walkthroughs and examples on how to use tools such as Oracle Discoverer and Reports to query the warehouse and 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 of Oracle Database 10g.

It provides a detailed look at the new features of Oracle Database 10g and other Oracle products and how these are used in the data warehouse, including:
* How to use the Summary Management features, including Materialized Views and query rewrite, to best effect to radically improve query performance
* How to deploy business intelligence to the Web to satisfy today's changing and demanding business requirements
* Using Oracle OLAP and Data Mining options
* How to understand the warehouse hardware environment and how it is used by new features in the database including how to implement a high availability warehouse
environment
* Using the new management infrastructure in Oracle Database 10g and how this helps you to manage your warehouse environment

Reader Reviews
I'm new to both Oracle and Data Warehousing and I haven't found many Data Warehousing texts specific to Oracle. I was hoping this would not only be a source for an architecture and design overview, but I also hoped to setup and work through the examples I saw in text as I perused it in the book store. I mean, no one would publish a modern computer book without providing downloadable source, would they? Maybe I missed something, but there is no CD, no reference in the text, and I checked the publishers web site. Found nothing! Especially for a topic like Data Warehousing, where learning to manage large amounts of data is the point of the whole subject, I found it amazing that no sample data is provided. Along this same line, the Appendix that shows the schema setup for the example database has errors in the script code, plus the steps are out of order. Apparently the authors expect you to use the Enterprise Manager to setup your database. The setup scripts appear to be an afterthought, and do not appear to be edited. If the authors had provided downloadable scripts and data, perhaps they would have been forced to work through this setup themselves and would have avoid this problem. I'm building sample data, and reading through the text, but for $60.00 I expected more. Comment | | (Report this)