1. Getting Started with Cache Guide
  2. Overview of Cache
  3. Types of Cache Groups You Can Create

Types of Cache Groups You Can Create

TimesTen provides multiple types of cache groups that cache Oracle database tables with automatic data synchronization. Select the cache group type based on your application needs. This guide covers the three most popular cache group types.

The cache group type identifies if you want to only read from or be able to read and write to the cache tables.

  • Read-Only cache group: A read-only cache group enforces a caching behavior in which committed changes on cached tables in the Oracle database are automatically refreshed to the cache tables in the TimesTen database. Using a read-only cache group is suitable for reference data that is heavily accessed by applications.

    • Static read-only cache group: With a static read-only cache group, you use manual load requests to load data. You can use manual refresh requests. However, most read-only cache groups use autorefresh operations to refresh modified data at specified time intervals. When using autorefresh, the manual refresh requests are not necessary.

    • Dynamic read-only cache group: With a dynamic read-only cache group, the application relies on data dynamically loading when data is requested with a qualified SELECT... WHERE SQL statement. Most read-only cache groups use autorefresh operations to refresh modified data at specified time intervals.

  • Read-write cache group: This guide describes the most popular read-write cache group that TimesTen offers with the static Asynchronous WriteThrough (AWT) cache group. A static AWT cache group enforces a caching behavior in which committed changes on cache tables in the TimesTen database are automatically propagated and committed to the cached tables in the Oracle database in asynchronous fashion. Using an AWT cache group is suitable for high speed data capture and online transaction processing.