File Library

Scaling to Infinity: Partitioning Data Warehouses on Oracle
Topic: Business Intelligence Files
Owner: Tim Gorman
Date: 2011-10-05
Subtopic: Other

There are several errors present in many data warehouse implementation on Oracle. Central to these is the lack of effective use of partitioning. Partitioning is crucial and particularly well-suited to the requirements large data warehouses, but how do you use this complex functionality effectively? It is important to understand what other major features of Oracle partitioning enables, and how and why? This presentation is the result of LONG practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements and painfully-gained understandings of data warehousing realities. It will provide straight answers to utilize Oracle's features, particularly partitioning, to ensure a successful data warehouse implementation.

Download File View File   TGorman OOW11 28781 DWScaling 20111002.ppt

Become a member of ODTUG to gain access to more than 2,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database