Oracle® In-Memory Database Cache User's Guide 11g Release 2 (11.2.2) E21634-08 |
|
|
PDF · Mobi · ePub |
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 Database tables. The commit on the TimesTen database occurs asynchronously from the commit on the Oracle database.
Committed updates on cached Oracle Database tables are automatically refreshed to the TimesTen cache tables.
A read-only cache group or a user managed cache group that uses the AUTOREFRESH MODE INCREMENTAL
cache group attribute.
Propagate committed updates on TimesTen cache tables to the cached Oracle Database tables, and refresh committed updates on cached Oracle Database tables to the TimesTen cache tables.
Oracle Database user that creates and maintains Oracle Database objects that store information used to manage cache grids and enforce predefined behaviors of particular cache group types.
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.
Defines the data from the Oracle Database tables to cache in a TimesTen database. A cache group can cache all or a subset of a single Oracle Database table or a set of related Oracle Database tables. If multiple Oracle Database tables are cached, each cache table (except for the root table) must reference another cache table in the cache group through foreign key constraints.
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.
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.
TimesTen user that performs cache grid and cache group operations such as creating and configuring a cache grid, and creating cache groups.
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.
A cache group category for which data in its cache tables can be loaded on demand, manually loaded or automatically loaded.
The transfer of data into the local grid member from Oracle Database tables when a query cannot be satisfied with data in the cache grid members.
A cache group category for which data in its cache tables are manually or automatically loaded.
To manually propagate committed inserts or updates on TimesTen cache tables in a user managed cache group to the cached Oracle Database tables.
A cache group classification where data in its cache tables are shared across multiple TimesTen databases within a cache grid.
Transfer of the cache instance from remote grid members to the local grid member in response to a query that cannot be satisfied by data in the cache tables on the local grid member.
A component of a cache grid consisting of either a standalone TimesTen database or an active standby pair.
A TimesTen database of a grid member that is either a standalone database, or the active database or standby database of an active standby pair.
Copy new cache instances from the cached Oracle Database tables to the TimesTen cache tables. Cache instances that are already exist in the cache tables are not updated or deleted.
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.
Oracle Database users who own Oracle Database tables to be cached in a TimesTen database.
Oracle Database user who owns Oracle Database tables that store information about cache grids.
A cache group in which committed updates on cached Oracle Database tables are automatically refreshed to the TimesTen cache tables. You cannot update cache tables directly in a read-only cache group.
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 Database tables.
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 Database tables.
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 Database tables. When an application commits a transaction, it is committed on Oracle Database before it is committed on TimesTen.
System managed cache groups enforce predefined behaviors. The types of system managed cache groups are read-only, synchronous writethrough and asynchronous writethrough.
Role granted to the cache administration user that defines privileges on the Oracle Database tables owned by the timesten user which store information about cache grids.
A cache group that implements customized behavior such as bidirectional transmit.