Decision support queries sometimes require large amounts of database processing. The Analytics Server can save the results of a query in cache files and then reuse those results later when a similar query is requested. Using cache, the cost of database processing only needs to be paid once for a query, not every time the query is run.

This section explains query caching and how it is implemented in the Analytics Server.

NOTE:  For information about how to use Delivers to seed the Analytics Server Cache, see Siebel Business Analytics Web Administration Guide.

This chapter contains the following topics:

• About the Analytics Server Query Cache
• Query Cache Architecture
• Configuring Query Caching
• Monitoring and Managing the Cache
• Purging Cache Programmatically
• Strategies for Using the Cache
• Cache Event Processing with an Event Polling Table
• Making Changes to a Repository
• Using the Cache Manager
• About the Refresh Interval for XML Data Sources