1. Managing Metadata Repositories for Oracle Analytics Server
  2. Build Your Metadata Repository
  3. Exchange Metadata with Databases to Enhance Query Performance
  4. About Exchanging Metadata with Databases

About Exchanging Metadata with Databases

By exchanging Oracle Analytics Server metadata from the Oracle BI Server with your Oracle Database, you enable the database to accelerate the performance of data warehouse queries.

Use the Oracle BI Server sametaexport utility to exchange the metadata. When you run this utility to generate metadata for Oracle Database, the utility is called the Oracle Database Metadata Generator.

The Oracle BI Server export utility works with the following tools:

  • In the Oracle Database, the SQL Access Advisor creates materialized views and index recommendations for optimizing performance.

The sametaexport utility generates the information necessary for the SQL Access Advisor tool to pre-aggregate the relational data and improve query performance.