Relational In-Memory Database Performance

Faster than Fast!

Welcome to the online Quick Start Guide for
Oracle TimesTen In-Memory Database and TimesTen Application-Tier 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 Application-Tier Database Cache (TimesTen Cache) for an Oracle database. Using TimesTen Cache provides applications the power of SQL, the speed of RAM and the reliability of a proven product with automatic data synchronization between theTimesTen 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 TimesTen 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 Java EE Application Server and OR mapping tools. There are also tutorials on how to run database tools, such as SQL Developer, Enterprise Manager, Index Advisor and ttImportFromOracle.

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 the 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.
  

 

The Quick Start guide may be updated from time to time. For the latest version, visit the TimesTen Quick Start page on OTN