Siebel Business Analytics Server Administration Guide > Connectivity and Third-Party Tools > Using IBM DB2 Cube Views with Siebel Business Analytics >

About Using IBM DB2 Cube Views with Siebel Business Analytics

The term IBM DB2 Cube Views is a registered trademark of IBM. For information about platform compatibility, see System Requirements and Supported Platforms.

This feature enhances the data warehouse performance and functionality of a database. It allows the DB2 database to store metadata about the logical relationships of the data residing in the database. Additionally, it accelerates data warehouse queries by using more efficient DB2 materialized query tables (MQTs). These MQTs preaggregate the relational data and improve query performance.

When processing queries, the DB2 Query Rewrite functionality routes queries to the MQTs when possible. Because these tables are smaller than the underlying base tables and the data has been preaggregated, the queries that are rerouted to them might run faster.

Siebel Analytics CubeViews Generator works as a metadata bridge to convert the Siebel Business Analytics proprietary metadata into a IBM Cube Views XML file. After converting metadata into an XML file, you use IBM Cube Views to import the translated metadata into your DB2 database and store it in IBM Cube Views metadata catalog tables. After importing the metadata, you use the IBM Optimization Advisor to generate scripts to create materialized query tables (MQT) and their indexes. The deployed MQTs are used by the DB2 Query Reroute Engine to optimize incoming application queries.

NOTE:  DB2 provides an API (implemented as a stored procedure) that passes XML documents as arguments to create, modify, delete, or read the metadata objects. For more information about IBM Cube Views, see your IBM DB2 documentation.

For additional information about using IBM Cube Views with Siebel Business Analytics, see the following topics:

• Generating the Import Files
• Process of Deploying Cube Metadata