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.
Topics covered:
- Introduction and Course Overview
- Overview of Oracle TimesTen In-Memory Database
- Installing TimesTen
- Creating Data Source Names and Data Stores
- Creating Data Store Elements
- Accessing Data Store Elements
- Managing Data Stores
- Transactions and Concurrency Control
- Performance Tuning and Query Optimization
- Configuring TimesTen Client/Server
- Overview of Cache Connect to Oracle
- Configuring a TimesTen Cache System
- Creating Cache Groups
- Cache Connect to Oracle Administrator
- Overview of Replication - TimesTen to TimesTen
- Configuring Replication
- Advanced Replication Configuration Topics
- Replication Recovery and Monitoring
Objectives:
Upon completion of this course, student should be able to:
- 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
Target Audience:
- Application Developers
- Database Administrators
- Database Designers
- Java Developer
- Sales Consultants
- Support Engineer
- Technical Administrator
- Technical Consultant
Prerequisites:
- Relational database concepts
- Oracle database administration and SQL
- UNIX or Microsoft Windows operating system commands and concepts
