Master Note for Generic Data Warehousing
- by lajos.varady(at)oracle.com
++++++++++++++++++++++++++++++++++++++++++++++++++++
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.2Information in this document applies to any platform.
Purpose
Provide navigation path
Master Note for Generic Data Warehousing
Components covered Read Only Materialized ViewsQuery RewriteDatabase Object PartitioningParallel Execution and Parallel QueryDatabase CompressionTransportable TablespacesOracle Online Analytical Processing (OLAP)Oracle Data MiningOracle 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 HomesOracle Partitioning Advanced CompressionOracle Data MiningOracle OLAPMaster Notes available in My Oracle SupportThese
technical articles have been written by Oracle Support Engineers to
provide proactive and top level information and knowledge about the
components of thedatabase we handle under the "Database Datawarehousing".Note 1166564.1 Master Note: Transportable Tablespaces (TTS) -- Common Questions and IssuesNote 1087507.1 Master Note for MVIEW 'ORA-' error diagnosis. For Materialized View CREATE or REFRESHNote 1102801.1 Master Note: How to Get a 10046 trace for a Parallel QueryNote 1097154.1 Master Note Parallel Execution Wait Events Note 1107593.1 Master Note for the Oracle OLAP OptionNote 1087643.1 Master Note for Oracle Data MiningNote 1215173.1 Master Note for Query RewriteNote 1223705.1 Master Note for OLTP Compression Note 1269175.1 Master Note for Generic Data WarehousingWhite 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 PresentationsA 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 CubesSelection 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 )