Oracle® In-Memory Database Cache User's Guide Release 11.2.1 Part Number E13073-02 |
|
|
View PDF |
aging
Delete cache instances from the cache tables of a cache group after a specified period of time (time-based) or when a specified level of database usage is reached (LRU).
asynchronous writethrough (AWT) cache group
A cache group in which committed updates on TimesTen cache tables are automatically and asynchronously propagated to the cached Oracle tables. The commit on the TimesTen database occurs asynchronously from the commit on the Oracle database.
automatic refresh
Committed updates on cached Oracle tables are automatically refreshed to the TimesTen cache tables.
automatic refresh cache group
A read-only cache group or a user managed cache group that uses the AUTOREFRESH MODE INCREMENTAL cache group attribute.
bidirectional transmit
Propagate committed updates on TimesTen cache tables to the cached Oracle tables, and refresh committed updates on cached Oracle tables to the TimesTen cache tables.
cache administration user
Oracle user that creates and maintains Oracle objects that store information used to manage cache grids and enforce predefined behaviors of particular cache group types.
cache agent
A TimesTen process that processes cache group operations, such as automatic refresh, loading a cache group, and passing through statements to the Oracle database for execution.
cache group
Defines the data from the Oracle tables to cache in a TimesTen database. A cache group can cache all or a subset of a single Oracle table or a set of related Oracle tables. If multiple Oracle tables are cached, each cache table (except for the root table) must reference another cache table in the cache group through foreign key constraints.
cache grid
A set of distributed grid members consisting of TimesTen in-memory databases that work together to cache data from a single Oracle database and guarantee cache coherence among the TimesTen databases.
cache instance
A specific row of data identified by the primary key in the cache group's root table. If there are multiple tables in the cache group, the cache instance consists of the set of rows in the child tables associated by foreign key relationships with the row in the root table.
cache manager user
TimesTen user that performs cache grid and cache group operations such as creating and configuring a cache grid, and creating cache groups.
child table
A cache table that has a foreign key reference to either the primary key of the root table or another child table that either directly or indirectly references the root table. The table hierarchy in your cache group can designate child tables to be parents of other child tables. No cache table can be a child to more than one parent in the cache group.
dynamic cache group
A cache group category where data in its cache tables can be loaded on demand, manually loaded or automatically loaded.
explicitly loaded cache group
A cache group category where data in its cache tables are manually or automatically loaded.
flush
To manually propagate committed inserts or updates on TimesTen cache tables in a user managed cache group to the cached Oracle tables.
grid member
A component of a cache grid consisting of either a standalone TimesTen database or an active standby pair.
grid node
A TimesTen database of a grid member that is either a standalone database, or the active master database or standby master database of an active standby pair.
global cache group
A cache group classification where data in its cache tables are shared across multiple TimesTen databases within a cache grid.
load
Copy new cache instances from the cached Oracle tables to the TimesTen cache tables. Cache instances that are already exist in the cache tables are not updated or deleted.
local cache group
A cache group classification where data in its cache tables are not shared across multiple TimesTen databases even if the databases are members of the same cache grid.
read-only cache group
A cache group in which committed updates on cached Oracle tables are automatically refreshed to the TimesTen cache tables. You cannot update cache tables directly in a read-only cache group.
refresh
For an explicitly loaded cache group, unload and then load the cache group.
For a dynamic cache group, replace existing cache instances in the cache tables with the most current data from the cached Oracle tables.
replication agent
Replication at each master and subscriber TimesTen database is controlled by a replication agent process. The replication agent on the master database reads the transaction log records and transmits any committed updates on replicated elements to the replication agent on the subscriber database. The replication agent on the subscriber database then applies the updates to its database.
For an AWT cache group, the replication agent transmits committed updates on its cache tables to the cached Oracle tables.
root table
The parent table in the cache group that does not reference any other table in the cache group through a foreign key constraint. The primary key of the root table is the primary key of the cache group.
synchronous writethrough (SWT) cache group
A cache group in which committed updates on TimesTen cache tables are automatically and synchronously propagated to the cached Oracle tables. When an application commits a transaction, it is committed on Oracle before it is committed on TimesTen.
system managed cache group
System managed cache groups enforce predefined behaviors. The types of system managed cache groups are read-only, synchronous writethrough and asynchronous writethrough.
TT_CACHE_ADMIN_ROLE role
Role granted to the cache administration user that defines privileges on the Oracle tables owned by the timesten user which store information about cache grids.
user managed cache group
A cache group that implements customized behavior such as bidirectional transmit.