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.
Track:	Business Intelligence/Warehousing - 11g Features
Product Line:	11g
Expertise:	Intermediate
Prerequisites:	A basic awareness of Oracle OLAP and data warehouse aggregation methods
Objective 1:	Describe the new Oracle 11g Cube Organized Materialized View technology
Objective 2:	Provide simple use cases for Cube Organized Materialized Views
Objective 3:	Provide a comparison between the 11g functionality and the methods available in earlier releases
Session:	233
Date:	Thursday, April 17, 2008
Time:	8:30 AM - 9:30 AM