If you want better performance from your data warehouse, one of the most efficient solutions is to create aggregate tables. In this post we will have a look at how Oracle Materialized Views and query rewrite option can help you do it. You can quickly implement aggregates in your data warehouse and you don’t need to make any changes in your existing reporting universe. Aggregates become available automatically when they are ready for use. And using Materialized Views makes your aggregate solution completely independent from your reporting tool.
Aggregate navigation is the process of determining the most efficient source for a user’s query. Oracle Materialized Views are database views whose results are cached in a table and can be returned from the cache instead of creating a new database query. In short, Materialized Views permit aggregate navigation in the Oracle Database instead of your reporting tool. Let’s have a look at how aggregate navigation is normally defined in Oracle Business Intelligence and Business Objects. Then let’s see how we can benefit from using Materialized Views.