Essential Oracle8i Data Warehousing - Designing, Building, and Managing Oracle® Data Warehouses

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

• Data Warehousing
  
• Hardware Architectures for Oracle Data Warehousing
  
• Oracle Server Software Architecture and Features
  
• Designing the Oracle Data Warehouse
  
• Building the Oracle Data Warehouse
  
• Populating the Oracle Data Warehouse
  
• Post-Load Processing in the Data Warehouse
  
• Administering and Monitoring the Oracle Data Warehouse
  
• Data Warehouse Performance Tuning
  
• Parallel Execution in the Oracle Data Warehouse
  
• Warehousing with Oracle Parallel Server
  
• Distributing the Oracle Data Warehouse
  
• Analytical Processing in the Oracle Data Warehouse
  
• Index