Data Warehousing with Oracle: An Administrator's Handbook

Overview

World-class guidance with building your Oracle data warehouse.

In Data Warehousing With Oracle: An Administrator's Handbook, two world-class experts show what it really takes to build and administer a data warehouse using Oracle. There's no better source for "big picture" guidance--and for the specific details you need to succeed.

The authors uncover hidden challenges that undermine many data warehousing projects--and demonstrate solutions that can be implemented up front, dramatically reducing costs. Learn how to get up-front answers to critical business questions surrounding data warehouses:

• What are our business goals?
  
  
• How will this data be used?
  
  
• Who owns this data?
  
  

Then, learn how to leverage Oracle system architecture and components to design data warehouses that are scalable, manageable and secure. Discover how to make the most of Oracle SQL extensions and PL/SQL in designing high-performance applications. Compare tools and techniques for providing superior end-user access. You'll also find:

• Practical tips on resource capacity planning; file and memory structure, configuration and tuning.
  
  
• Checklists of procedures to streamline support and administration.
  
  
• Specific approaches and templates for improving data quality and reliability.
  
  

This is an essential resource for all Oracle developers, system and enterprise analysts, DBAs, system administrators, IT managers--and any professional involved in data warehousing.

Read More