Location: Oracle BI and DW

Discussion: Cube Organized Materialized ViewsReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 1 post

nmrezzini
Cube Organized Materialized Views
Mar 2 2009, 9:26 AM EST | Post edited: Mar 2 2009, 9:26 AM EST
Using cube organized with materialized view, we have got a query performance and fast for incremental updates.

Summary sql queries that are directed at relational fact tables are automayically rewritten on the olap cube
to deliver faster query performance.

Cube MVs is existing since 11g, they are integrated with the Oracle Database SQL Optimizer.
The 11g SQL Query Optimizer treats OLAP cubes as MVs and rewrites queries to access cubes transparently.
A single cube provides the equivalent of tens, hundrends, or thousands of summary combinations.
The cube MV is refreshed using standard MV procedures.

There are four general tasks required to implement cube MVs. The first three tasks are specific to OLAP cube MVs,
while the last task is important for any type of MV.

Tasks for implementing cube MVs include:
• Design dimensions and cubes – AWM
• Enable cube MVs – AWM
• Build and maintain dimensions and cubes – AWM
• Prepare relational schema for query rewrite – SQL Do you find this valuable?    
Keyword tags: None

Sign in to be the first to reply.