Relational In-Memory Database Performance

Faster than Fast!

Welcome to the online Quick Start Guide for
Oracle TimesTen In-Memory Database and Oracle In-Memory Database Cache!

Oracle TimesTen In-Memory Database (TimesTen) is a memory-optimized relational database that provides applications with the instant responsiveness and very high throughput required by today's real-time enterprises in a wide range of industries. A TimesTen database resides entirely in memory at run time and is persisted to disk storage for the ability to recover and restart. Applications access the TimesTen database using the JDBC, ODBC, OCI, ODP.NET and/or Pro*C/C++ interfaces. TimesTen is extremely fast and it is fully transactional, persistent, and highly available with transactional replication.

TimesTen is typically deployed in the middle-tier with the applications; it can be run as a stand-alone database or as an in-memory database cache for an Oracle database. Using TimesTen as an in-memory database cache provides applications the power of SQL, the speed of RAM and the reliability of a proven product with automatic data synchronization between the in-memory cache tables and the back-end Oracle database.

The Quick Start Guide includes the following areas of information to help you get started quickly:

1. CONFIGURATION and SETUP

• provides tutorials on how to properly create and configure TimesTen databases, set up user accounts and privileges, start and stop TimesTen database processes, and execute a variety of database operations. In addition, you will learn how to use In-Memory Database Cache to configure a cache grid in the middle tier for caching a subset of your Oracle database, how to configure TimesTen Replication to achieve high availability in the middle tier, and how to configure your cache database with a J2EE Application Server and OR mapping tools.

2. SAMPLE PROGRAMS

• provides sample programs using the Java, C++, and C programming languages to develop database applications to access TimesTen databases and the cache tables they contain. These programs are grouped by data access interface including JDBC, ODBC, OCI, Pro*C, TTClasses (C++), PL/SQL. and ODP.NET. Each program comes with a description, source code, and instructions for compiling and running on your platform of choice.

3. BEST PRACTICES

• summarizes best practices you should follow to achieve best performance for your applications.

4. RESOURCES

• provides additional resources available to you on various Oracle websites where you can get the latest updates on product release downloads, technology white papers, user discussion forums on Oracle Technology Network, online documentation, etc.