Best Practices for a Data Warehouse on Oracle Database 11g

Best Practices for a Data Warehouse on Oracle Database 11g

Cover

Increasingly companies are recognizing the value of an enterprise data warehouse (EDW). A true EDW provides a single 360-degree view of the business and a powerful platform for a wide spectrum of business intelligence tasks ranging from predictive analysis to near real-time strategic and tactical decision support throughout the organization. In order to ensure the EDW will get the optimal performance and will scale as your data set grows you need to get three fundamental things correct, the hardware configuration, the data model and the data loading process. By designing these three corner stones correctly you can seamlessly scale out your EDW without having to constantly tune or tweak the system.

The paper is divided into four sections:

The first section deals with the key aspects of configuring your hardware platform of choice to ensure optimal performance.

  • The second briefly describes the two fundamental logical models used for database warehouses.
  • The third outlines how to implement the physical model for these logical models in the most optimal manner in an Oracle database.
  • Finally the fourth section covers system management techniques including workload management and database configuration.

Authors

Maria Colgan Doug Cackett George Spears Andrew Bond
Vendor:
Oracle Corporation
Posted:
19 Jan 2009
Published
19 Jan 2009
Format:
PDF
Length:
38 Page(s)
Type:
White Paper
Language:
English
Already a Bitpipe member? Login here

Download this White Paper!

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy