Oracle^® Business Intelligence Server Administration Guide > Connectivity and Third-Party Tools in Oracle BI Server >

Exchanging Metadata with Databases

If your organization has installed either an Oracle Database or an IBM DB2 Database, then you can use these databases to enhance the data warehouse performance and functionality of queries that run on the Oracle BI Server. By exchanging Oracle BI metadata from the Oracle BI Server with the Oracle Database or with the IBM DB2 Database, you allow the database to accelerate the performance of data warehouse queries by using the following tools:

• In the Oracle Database, Oracle Database Summary Advisor to create materialized views and index recommendations on optimizing performance.
• In the IBM DB2 Database, IBM DB2 Cube Views to create materialized query tables (MQTs).

Both of these tools preaggregate the relational data and improve query performance.