sponsored by Oracle Corporation
Posted:  19 Jan 2009
Published:  19 Jan 2009
Format:  PDF
Length:  38  Page(s)
Type:  White Paper
Language:  English
ABSTRACT:

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



BROWSE RELATED RESOURCES
Best Practices | Data Warehouses | Load Balancing | Memory | Parallel Processing | Systems Management

View All Resources sponsored by Oracle Corporation

About TechTarget:

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines

All Rights Reserved, Copyright 2000 - 2014, TechTarget | Read our Privacy Statement