Oracle TimesTen 7.0: IMDB, Cache Connect, and Replication Training  

Introduction and Course Overview

• Describe course objectives

Overview of Oracle TimesTen In-Memory Database

• List and describe features of Oracle TimesTen In-Memory Database and its product options
• Describe how TimesTen In-Memory Database achieves a very fast response time and a very high transaction throughput rate
• Identify the TimesTen processes and files
• Describe how updates to a TimesTen data store are processed
• Explain the function of the TimesTen Data Manager, Client, and Server components

Installing TimesTen

• Identify the user and system configuration requirements for installing TimesTen
• List the TimesTen installable components
• Install the TimesTen software
• Configure an environment to run TimesTen
• Build and run the demo programs
• Explain where to find the TimesTen product documentation

Creating Data Source Names and Data Stores

• Create a data source name (DSN) and set its attributes
• Use the ttIsql command-line interface utility to connect to a data store
• Use the ttStatus utility to display connections on data stores
• Define a data store RAM policy
• Explain the concept of Access Control, and define users and assign privileges

Creating Data Store Elements

• List and describe the characteristics of a TimesTen table and its columns
• Write and execute SQL data definition language (DDL) statements for tables and indexes
• Configure an automatic data aging policy on a table
• List and describe the different types of TimesTen indexes
• Describe the contents of the TimesTen system tables
• Use the ttSize utility to calculate the estimated size of a table

Accessing Data Store Elements

• Write and execute SQL data manipulation language (DML) statements
• Identify the various search conditions, functions, and expressions that can be used in DML statements
• Create and access sequences
• Create regular and materialized views
• Execute prepared and parameterized statements
• Call the TimesTen built-in procedures

Managing Data Stores

• Use the various utilities to import and export data into and out of a data store’s tables, and back up and restore a data store
• Explain how data store checkpoint operations are initiated
• Change the size of a data store
• Configure TimesTen to throw Simple Network Management Protocol (SNMP) traps

Transactions and Concurrency Control

• Explain the concept of a transaction and how to complete transactions
• Describe the purpose of the transaction log and when log records are created
• Explain how locking and isolation levels coordinate concurrent operations on a data store
• Use the ttXactAdmin utility to view locks requested and acquired by active transactions

Performance Tuning and Query Optimization

• Create indexes to improve query performance
• Update column and table statistics to improve the query execution plan
• Display a query execution plan

Configuring TimesTen Client/Server

• Describe the TimesTen client/server architecture
• Configure a client/server environment
• Access a data store in client/server mode
• Manually start and stop the TimesTen Server process
• Use the ttStatus utility to display information about the server processes and connections from client applications

Overview of Cache Connect to Oracle

• List and describe features of the Cache Connect to Oracle product option
• Describe various usages of Cache Connect to Oracle

Configuring a TimesTen Cache System

• Describe what a cache group contains and how it is defined
• Identify the operations that can be performed on a cache group to keep the TimesTen cache and the corresponding Oracle database synchronized
• List the different types of cache groups
• Configure a system to run Cache Connect to Oracle
• Start the cache agent process and describe its role

Creating Cache Groups

• Create read-only, writethrough, and user-managed cache groups
• Describe the functionality of the AUTOREFRESH cache group attribute
• Passthrough statements from TimesTen to Oracle for execution
• Manually load, unload, refresh, and flush a cache group
• Configure an automatic data aging policy on a cache group
• Automatically load a cache group on demand

Cache Connect to Oracle Administrator

• Start the Cache Connect to Oracle Administrator and connect to a data store
• Use the Cache Connect to Oracle Administrator to:
• - Create a cache group definition
• - View the SQL statement for a cache group definition
• - Create a cache group from its definition
• - Manage the cache agent process

Overview of Replication - TimesTen to TimesTen

• Describe the benefits of the Replication - TimesTen to TimesTen product option
• List and describe the common replication configurations
• Describe the differences between asynchronous and synchronous replication

Configuring Replication

• List the types of elements that can be replicated between TimesTen data stores
• Create an asynchronous replication scheme
• Start the replication agent process and describe its role
• Create a subscriber data store as a copy of a master data store
• List and describe the different replication states
• Create a return receipt and a return two-safe synchronous replication scheme

Advanced Replication Configuration Topics

• Alter a replication scheme to perform operations such as adding elements or adding a subscriber data store
• Create a propagation replication scheme
• Create an active standby pair replication scheme
• Configure replication of cache tables
• Configure a system with multiple network interface cards for replication

Replication Recovery and Monitoring

• Configure timestamp-based update conflict resolution
• Configure a transaction log file threshold
• List and describe the system tables that store replication information
• Recover a replicated data store after a store or system failure
• Use various utility commands and built-in procedures to monitor replication