Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 11.2.2.2.0
• New features in Release 11.2.2.1.0
• New features in Release 11.2.2.0.0

1 Oracle TimesTen In-Memory Database and Oracle In-Memory Database Cache

• Why is Oracle TimesTen In-Memory Database fast?
• TimesTen and IMDB Cache feature overview
  • TimesTen API support
    • ODBC and JDBC interfaces
    • SQL and PL/SQL functionality
    • OCI and Pro*C/C++ Precompiler support
    • ODP.NET support
    • Transaction Log API
    • TTClasses
    • Distributed Transaction Processing APIs
  • Access Control
  • Database connectivity
  • Durability
  • Query optimization
  • Concurrency
  • Automatic data aging
  • Globalization support
  • In-memory columnar compression
  • Business intelligence and online analytical processing
  • Large objects
  • Administration and utilities
  • Replication
  • IMDB Cache

2 Using TimesTen and IMDB Cache

• Uses for TimesTen
• Uses for IMDB Cache
• TimesTen application scenario
  • Real-time quote service application
• IMDB Cache application scenarios
  • Call center application
  • Caller usage metering application

3 Oracle In-Memory Database Cache Architecture and Components

• Architectural overview
• Shared libraries
• Memory-resident data structures
• Database processes
• Administrative programs
• Checkpoint and transaction log files
• Cached data
• Replication
• TimesTen connection options
  • Direct driver connection
  • Client/server connection
  • Driver manager connection
• For more information

4 Concurrent Operations

• Transaction isolation
  • Read committed isolation
  • Serializable isolation
• Locks
  • Database-level locking
  • Table-level locking
  • Row-level locking
• For more information

5 Query Optimization

• Optimization time and memory usage
• Statistics
• Optimizer hints
• Indexes
• Scan methods
• Join methods
  • Nested loop join
  • Merge join
• Optimizer plan
• For more information

6 Data Availability and Integrity

• Transaction logging
  • Writing the log buffer to disk
  • When are transaction log files deleted?
  • TimesTen commits
• Checkpointing
  • Nonblocking checkpoints
  • Blocking checkpoints
  • Recovery from log and checkpoint files
• Replication
  • Active standby pair
  • Other replication configurations
    • Unidirectional replication
    • Bidirectional replication
  • Asynchronous and return service replication
  • Replication failover and recovery
• For more information

7 Event Notification

• Transaction Log API
  • How XLA works
  • Log update records
• Materialized views and XLA
• SNMP traps
• For more information

8 IMDB Cache

• Cache grid
• Cache groups
• Dynamic cache groups and explicitly loaded cache groups
• Global and local cache groups
• Transmitting data between the IMDB Cache and Oracle Database
  • Updating a cache group from Oracle tables
  • Updating Oracle tables from a cache group
• Aging feature
• Passthrough feature
• Replicating cache groups
• For more information

9 TimesTen and IMDB Cache Administration

• Installing TimesTen and IMDB Cache
• Access Control
• Command line administration
• SQL administration
• SQL Developer
• ODBC Administrator
• Upgrading TimesTen and the IMDB Cache
  • In-place upgrades
  • Offline upgrades
  • Online upgrades
• For more information

Index