++++++++++++++++++++++++++++++++++++++++++++++++++++
The complete and the most recent version of this article can be viewed
from My Oracle Support Knowledge Section.

Master Note for Generic Data Warehousing [ID 1269175.1]
++++++++++++++++++++++++++++++++++++++++++++++++++++

In this Document
  Purpose
  Master Note for Generic Data Warehousing
     Components covered
     Oracle Database Data Warehousing specific documents for recent versions
     Technology Network Product Homes
     Master Notes available in My Oracle Support
     White Papers
     Technical Presentations

---

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2 - Release: 9.2 to 11.2
Information in this document applies to any platform.

Purpose

Provide navigation path

Master Note for Generic Data Warehousing

Components covered

• Read Only Materialized Views
• Query Rewrite
• Database Object Partitioning
• Parallel Execution and Parallel Query
• Database Compression
• Transportable Tablespaces
• Oracle Online Analytical Processing (OLAP)
• Oracle Data Mining

Oracle Database Data Warehousing specific documents for recent versions

• 11g Release 2 (11.2)
• 11g Release 1 (11.1)
  
  
• 10g Release 2 (10.2)
• 10g Release 1 (10.1)
  
  
• 9i Release 2 (9.2)
• 9i Release 1 (9.0)

Technology Network Product Homes

• Oracle Partitioning 
• Advanced Compression
• Oracle Data Mining
• Oracle OLAP

Master Notes available in My Oracle Support

These technical articles have been written by Oracle Support Engineers to provide proactive and top level information and knowledge about the components of the
database we handle under the "Database Datawarehousing".

• Note 1166564.1 Master Note: Transportable Tablespaces (TTS) -- Common Questions and Issues
• Note 1087507.1 Master Note for MVIEW 'ORA-' error diagnosis. For Materialized View CREATE or REFRESH
• Note 1102801.1 Master Note: How to Get a 10046 trace for a Parallel Query
• Note 1097154.1 Master Note Parallel Execution Wait Events
• Note 1107593.1 Master Note for the Oracle OLAP Option
• Note 1087643.1 Master Note for Oracle Data Mining
• Note 1215173.1 Master Note for Query Rewrite
• Note 1223705.1 Master Note for OLTP Compression
• Note 1269175.1 Master Note for Generic Data Warehousing
  

White Papers

• Transportable Tablespaces white papers
  
  Database Upgrade Using Transportable Tablespaces:Oracle Database 11g Release 1 (February 2009)
  Platform Migration Using Transportable Database Oracle Database 11g and 10g Release 2 (August 2008)
  Database Upgrade using Transportable Tablespaces: Oracle Database 10g Release 2 (April 2007)
  Platform Migration using Transportable Tablespaces: Oracle Database 10g Release 2 (April 2007)
  
  
• Parallel Execution and Parallel Query white papers
  
  Best Practices for Workload Management of a Data Warehouse on the Sun Oracle Database Machine (June 2010)
  Effective resource utilization by In-Memory Parallel Execution in Oracle Real Application Clusters 11g Release 2 (Feb 2010)
  Parallel Execution Fundamentals in Oracle Database 11g Release 2 (November 2009)
  Parallel Execution with Oracle Database 10g Release 2 (June 2005)
  
  
• Oracle Data Mining white paper
  
  Oracle Data Mining 11g Release 2 (March 2010)
  
  
• Partitioning white papers
  
  Partitioning with Oracle Database 11g Release 2 (September 2009)
  Partitioning in Oracle Database 11g (June 2007)
  
  
• Materialized Views and Query Rewrite white papers
  
  Oracle Materialized Views  and Query Rewrite (May 2005)
  Improving Performance using Query Rewrite in Oracle Database 10g (December 2003)
  
  
• Database Compression white papers
  
  Advanced Compression with Oracle Database 11g Release 2 (September 2009)
  Table Compression in Oracle Database 10g Release 2 (May 2005)
  
  
• Oracle OLAP white papers
  
  On-line Analytic Processing with Oracle Database 11g Release 2 (September 2009)
  Using Oracle Business Intelligence Enterprise Edition with the OLAP Option to Oracle Database 11g (July 2008)
  
  
• Generic white papers
  
  Enabling Pervasive BI through a Practical Data Warehouse Reference Architecture (February 2010)
  Optimizing and Protecting Storage with Oracle Database 11g Release 2 (November 2009)
  Oracle Database 11g for Data Warehousing and Business Intelligence (August 2009)
  Best practices for a Data Warehouse on Oracle Database 11g (September 2008)

Technical Presentations

A selection of ObE - Oracle by Examples documents:

Generic
Using Basic Database Functionality for Data Warehousing (10g)

Partitioning
Manipulating Partitions in Oracle Database (11g Release 1)
Using High-Speed Data Loading and Rolling Window Operations with Partitioning (11g Release 1)
Using Partitioned Outer Join to Fill Gaps in Sparse Data (10g)

Materialized View and Query Rewrite
Using Materialized Views and Query Rewrite Capabilities (10g)
Using the SQLAccess Advisor to Recommend Materialized Views and Indexes (10g)

Oracle OLAP
Using Microsoft Excel With Oracle 11g Cubes (how to analyze data in Oracle OLAP Cubes using Excel's native capabilities)
Using Oracle OLAP 11g With Oracle BI Enterprise Edition (Creating OBIEE Metadata for OLAP 11g Cubes and querying those in BI Answers)
Building OLAP 11g Cubes
Querying OLAP 11g Cubes
Creating Interactive APEX Reports Over OLAP 11g Cubes

Selection of presentations from the BIWA website:

• Extreme Data Warehousing With Exadata  by Hermann Baer (July 2010) (slides 2.5MB, recording 54MB)
• Data Mining Made Easy! Introducing Oracle Data Miner 11g Release 2 New "Work flow" GUI   by Charlie Berger (May 2010) (slides 4.8MB, recording 85MB )
• Best Practices for Deploying a Data Warehouse on Oracle Database 11g  by Maria Colgan (December 2009)  (slides 3MB, recording 18MB, white paper 3MB )