Configuring In-Memory Database Cache
The Oracle Database option In-Memory Database Cache (IMDB Cache) allows you to cache tables from an Oracle database into a TimesTen in-memory database. An application will typically choose to cache frequently-accessed data or performance-sensitive data. IMDB Cache uses the concept of a cache group, which is a collection of cached tables related to each other by foreign key constraints. This is an important feature as the unit of caching and aging becomes a set of records related by foreign key constraints. Each cached table maps to either a full table or a subset of a table in the Oracle database.
A cache grid is a collection of TimesTen databases that collectively manage an application’s cached data. Each of the in-memory cache databases participating in a cache grid (also known as grid members) contains one or more cache groups. Global cache groups are cache groups that are shared among cache grid members. Cache grid members use peer-to-peer communication to communicate among each other and to manage the coherence of global cache groups. New cache grid members may attach or detach from a cache grid dynamically.
The examples on this page use the HR sample schema in the Oracle database. The examples provide a step by step tutorial on how to set up In-Memory Database Cache in order to cache tables from the Oracle HR schema into a TimesTen database.