233: Cube Organized Materialized Views - do they deliver?
Peter Scott , Rittman Mead Consulting    Biography

Objectives: Describe the new Oracle 11g Cube Organized Materialized View technology
Provide simple use cases for Cube Organized Materialized Views
Provide a comparison between the 11g functionality and the methods available in earlier releases
Abstract: The 11g release 1 of the Oracle database introduces Cube Organized Materialized Views to Oracle OLAP. This new feature permits standard SQL queries (such as those generated by non-OLAP aware reporting tools) to transparently access OLAP cube data through a query rewrite mechanism. This session introduces the feature and its uses and limitations before investigating the benefits (or drawbacks) of using Cube Organized Materialized Views in comparison with conventional materialized view summary tables and the SQL cube views available in Oracle 10g OLAP.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Business Intelligence/Warehousing
Date: Thursday, April 17, 2008
Time: 8:30 AM - 9:30 AM