Oracle^® Business Intelligence Server Administration Guide > Connectivity and Third-Party Tools in Oracle BI Server > Using Materialized Views in the Oracle Database with Oracle BI >

About Using Oracle Database Summary Advisor with Materialized Views

This feature enhances the data warehouse performance and functionality of a database. It allows the Oracle Database Summary Advisor to store metadata about the logical relationships of the data that resides in the database. Additionally, it accelerates data warehouse queries by using more efficient Oracle materialized views. These materialized views preaggregate the relational data and improve query performance. Once the metadata is stored in the Oracle Database Summary Advisor, the database administrator can optimize the database objects and improve query performance.

When processing queries, the Oracle Database routes queries to tables that hold materialized views when possible. Because these tables of materialized views are smaller than the underlying base tables and the data has been preaggregated, the queries that are rerouted to them might run faster.

Oracle Database Metadata Generator works as a metadata bridge to convert the Oracle BI proprietary metadata into a SQL file that contains PL/SQL commands to generate dimensions in the Oracle Database Summary Advisor. After converting metadata into a SQL file, you use a tool such as SQL*Plus to import the translated metadata into the Oracle Database Summary Advisor and store it in metadata catalog tables. After importing the metadata, you create materialized views, which are used by to optimize incoming application queries.

You can use this feature with Oracle Database 9i and higher. For information about platform compatibility, refer to System Requirements and Supported Platforms.