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 |