Oracle TimesTen Overview Gary QuarlesSolution Architect课件.ppt

Cache Connect to OracleProduct Option Cache full or subset of tables from Oracle DB Read-only or updatable Bi-directional updates From TimesTen to Oracle From Oracle to TimesTen Multiple Cache instances per Oracle DB Replication option Cache Connectto Oracle Oracle In-MemoryDatabase Network In-MemoryDatabase Application-Tier Platforms Application Program TimesTen Application Program TimesTen Caching Data from Oracle Database Flexible cache content Cache individual tables or related tables Cache all or subset of rows and columns Maintain parent-child tables relationship Cache group is explicit Cache Group – describes the Oracle data to be cached in the TimesTen in-memory database, via a SQL WHERE clause TimesTen Cache Groups Root Table Child Table Child Table Child Table Example: Valuable Customers CUSTOMER table PremierUsers Caching name and address of premier customers who have had more than 500 purchase orders CREATE CACHE GROUP PremierUsers FROM CUSTOMER ( NAME CHAR(100) NOT NULL, ADDR CHAR(100) ) WHERE CUSTOMER.ORDER 500; Read-only Cache Groups Read-only Cache Groups Updates disallowed in TimesTen Optionally updates can be sent to Oracle (via the Pass-through feature) Updates in Oracle automatically refreshed to the TimesTen Cache Group Resilience to failures Oracle Refresh updates to Cache Group Updates Pass-through to Oracle Application Web Clients READONLYCache Group IMDB Application Client/Server C/S Applications Updatable Cache-Groups Updates in Cache Group Synchronous or asynchronous write-through to Oracle Synchronous write-through transactions synchronously committed in Oracle Asynchronous write-through transactions batch-committed in Oracle Resilience to failures Oracle Load data from Oracle Propagate changes to Oracle Application Web Clients Write-throughCache Group IMDB Application Client/Server C/S Applications On-Demand Caching Cache instances loaded on demand, when needed Cache instances aged out after a certain duration Oracl