Master Note for Generic Data Warehousing

++++++++++++++++++++++++++++++++++++++++++++++++++++
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

Technology Network Product Homes

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".

White Papers

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:

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

News and Troubleshooting tips for Oracle Database and Enterprise Manager

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today