Oracle TimesTen 7.0: IMDB, Cache Connect, and Replication

Course Length: Price:

Current Schedule:
3 days
$2250

 No course scheduled at this time - please contact us
To register for multiple courses, please go to the Complete Schedule

What you will learn:
Oracle In this class, students will learn about the in-memory database architecture, and how to install and administer a TimesTen data store. Students will use Replication - TimesTen to TimesTen to configure replication of data updates between TimesTen data stores. Students will then use Cache Connect to Oracle to configure and administer a TimesTen data store that caches data from an Oracle database.

This course gives the students a conceptual understanding of the Oracle TimesTen In-Memory Database architecture Students learn to create an operational data store and properly manage the various elements in an effective and efficient manner including performance tuning, user and privilege management, and connection configuration modes. Next, students will gain a conceptual understanding of the different types of replication topologies and schemes, and the application scenarios that each configuration is best suited. Students will also learn the different types of operations that can be performed on cache groups to keep the TimesTen data store and Oracle database synchronized with each other. Students will gain practical experience with the Web-based Cache Connect to Oracle Administrator, which allows them to define and create cache groups using a graphical user interface tool.

The lesson topics are reinforced with structured hands-on practices to ensure that students will acquire the skills and knowledge to become productive using TimesTen.

Learn to:

  • Configure and administer TimesTen data stores
  • Use the data store management utilities
  • Apply the various TimesTen features to produce an optimally-performing system
  • Define and create various types of cache groups
  • Define and create various types of replication schemes
  • Install the TimesTen software

Audience:

  • Application Developers
  • Database Administrators
  • Database Designers
  • Java Developer
  • Sales Consultants
  • Support Engineer
  • Technical Administrator
  • Technical Consultant

Prerequisites:

  • Required Prerequisites:
    • Relational database concepts
    • Oracle database administration and SQL
    • UNIX or Microsoft Windows operating system commands and concepts

Course Objectives:

  • Describe the TimesTen products and the In-Memory Database architecture
  • Install the TimesTen software
  • Configure a data source name
  • Create and access TimesTen data store elements
  • Perform backup and restore of a data store
  • Tune the performance of data store operations
  • Configure direct and client/server data store connections
  • Configure a Cache Connect to Oracle system
  • Perform operations on cache groups to keep the TimesTen data store and Oracle database synchronized with each other
  • Use the Cache Connect to Oracle Administrator to define and create cache groups
  • Configure a replicated TimesTen system by defining and creating replication schemes
  • Explain how asynchronous and synchronous replication works, and the costs and benefits of each configuration

Course Topics:

  • 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