Overview
"This book is the definitive guide for serious Oracle8i professionals and is required reading for all Oracle data warehousing practitioners."-Shannon Platz, Senior Director, Business Intelligence & Warehouse Global Service Line, Oracle Corporation
A complete hands-on guide to Oracle8i and earlier versions In this updated and expanded edition of their critically acclaimed Oracle8 Data Warehousing, Gary Dodge and Tim Gorman clearly explain everything you'll need to know to build and manage a large, high-performance data warehouse using Oracle8i. They provide a technical roadmap to the specific Oracle8 or Oracle8i features that are relevant to designing, building, tuning, and administering an Oracle data warehouse.
After a brief review of the basic concepts, you'll find descriptions of the various hardware platforms to support the Oracle data warehouse. The authors then cover the Oracle features that can enhance a large data warehouse, the design considerations for a warehouse, and the steps necessary to load data into the warehouse. You'll also find out how to perform parallel operations using Oracle8 and Oracle8i to accomplish massive tasks more quickly. And you'll discover the specific features and techniques for implementing a distributed architecture.
With this book, you'll learn how to:
- Design a data warehouse for optimum performance
- Construct the data warehouse using Oracle8 and Oracle8i database technology
- Load data into the data warehouse
- Summarize and aggregate data within a warehouse
- Administer and monitor a data warehouse for optimum performance
- Build and manage very large (multiterabyte) data warehouses
Visit our Web site at www.wiley.com/compbooks/
Visit the companion Web site at www.wiley.com/compbooks/dodge for scripts, extensions, and additional material.
Synopsis
A soup-to-nuts guide to building and managing high-performance Oracle8i data warehouses In an effort to help companies manage what Information Week has referred to as the "Web Data Deluge," Oracle has released Oracle8i (the "i" stands for "Internet"), a major upgrade to their flagship database product that provides powerful new data warehousing capabilities. In this updated and expanded edition of their critically acclaimed Oracle8 Data Warehousing, Gary Dodge and Tim Gorman provide database developers and administrators with complete, detailed coverage of all they need to know to build and manage a fast, high-performance data warehouse using the Oracle8i technology. Step-by-step, they cover all the bases, including designing a data warehouse for optimum performance, building a data warehouse, loading data into the data warehouse, improving warehouse performance with aggregate data, and administering data warehouse performance.
Booknews
Explains how to use the Oracle relational database management system to create and maintain the large amounts of data required in a data warehouse. The authors describe the various hardware platforms that support the Oracle data warehouse, the Oracle features that can enhance a large data warehouse, design considerations for a warehouse, and the steps necessary to load data into the warehouse. The more advanced tasks of performing parallel operations and implementing a distributed architecture conclude the manual. Annotation c. Book News, Inc., Portland, OR (booknews.com)