Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Oracle’s 11g Launch Impresses – Intelligent Enterprise

Posted by Dylan Wan on July 13, 2007

The Intelligence Enterprise’s weblog has a new article about Oracle 11g.  One thing worth highlighted is the feature he feel impressed about on the advancement of OLAP.

Materialized views are a technique for speeding multidimensional queries, such as those exploring sales across regions, products and customers. However, as the number of materialized views mounts along with query volumes and complexity, managing those views becomes difficult. In 11g, Oracle is using an OLAP cube to store up to millions of materialized views so they can be managed more efficiently.”

One of the problems of the old materialized view is that  you have to know the level you are going to reported by and create the materialized view accordingly.  The benefit of using an OLAP engine is that the aggregation can be available at many different levels andyou do not need to created multiple specific materialized views for storing the summaries.   However, the OLAP cubes was stored in a different technology and populated in different languages.    You need to write codes to map the data from your source system or warehouse to the cubes.  The process needs to be run periodically in order to have the refreshed data from OLAP.  Also, querying the data from OLAP requires a different programming interface, unless you create the OLAP-to-Relational mapping view.

The new feature of 11g seems combining the best from both world and solve all the problems!


One Response to “Oracle’s 11g Launch Impresses – Intelligent Enterprise”

  1. Ramesh Natarajan said

    Hi Dylan,

    Your blog is very informative.

    Ramesh Natarajan
    Views and Thoughts of a Global Indian

    I am a Hyperion System 9 Professional, based in Dubai.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s