Introduction of Cache in TimesTen Scaleout

You can cache data from an Oracle database in a TimesTen database by creating cache groups, where each cache group can cache a single Oracle database table or a set of related Oracle database tables.

The cached data from the Oracle database can consist of all the rows and columns or a subset of the rows and columns in the Oracle database tables.

TimesTen Scaleout supports static read-only cache groups with incremental autorefresh.

• Applications can read from cache groups.

• Data is initially loaded from the Oracle database into the cache group, and then refreshed manually or automatically.

• Updates to the cached tables can be sent through to the Oracle database using a passthrough operation.

Cache operations utilize the scalability and data redistribution of TimesTen Scaleout. When you add or remove elements within replica sets, TImesTen automatically:

• Redistributes the data as specified with the distribution scheme on each cache table.

• Redistributes the autorefresh processing across elements in the modified replica sets.

Cache operations also utilize the recovery of TimesTen Scaleout. Cache in TimesTen Scaleout handles most occurrences of element failure, replica set failure, restarting cache agents, restarting the Oracle database, and communication failures with the Oracle database.

You can go to the following topics in Oracle TimesTen In-Memory Database Cache Guide for concepts on static read-only cache groups and incremental autorefresh.

• Overview of Cache Groups for an overall description of cache groups.

• Cache Groups and Cache Tables for an introduction on how to create cache groups and cache tables.

• Read-Only Cache Group for a description of read-only cache groups.

• Automatically Refreshing a Cache Group for details on incremental autorefresh.