Best Practices for a Data Warehouse on Oracle Database 11g by Oracle CorporationWelcome, Guest      sign in | register | help

   Search for:        Advanced Search
Research Abstract
Best Practices for a Data Warehouse on Oracle Database 11g
by Oracle Corporation

> View this now

Published on: January 19, 2009
Type of content: WHITE PAPER
Format: Unknown
Length: 38 pages
Price: FREE


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.

> View Company Report
> View all content by this company
> Return to Search Results

  The Complete KnowledgeStorm Network of Technology Search Sites. Focused searching for faster results.

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.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints

  TechTarget - The IT Media ROI Experts