TimesTen In-Memory Database

Oracle TimesTen In-Memory Database (TimesTen) is a lightweight in-memory database that offers unrivaled performance, simple management, high performance, and high availability.

Watch the Oracle TimesTen overview video (1:05)

How TimesTen works

TimesTen is a lightweight, fully persistent, and highly available in-memory relational database that delivers microsecond response and high throughput for OLTP applications. You can use TimesTen as a database of record or as a cache for Oracle Database.

Because the TimesTen database resides in physical memory rather than a file system, access to data is more direct, resulting in a shorter code path, simpler algorithms, and internal data structures. By removing the assumption of the file system, complexity dramatically decreases. The number of machine instructions drops, buffer pool management disappears, extra data copies are unnecessary, index pages shrink, and their structure is simplified. The design becomes simple and more compact, and requests are processed faster.

Applications access TimesTen databases using standard SQL through JDBC, ODBC, ODP.NET, Oracle Call Interface, Pro*C/C++, and Oracle PL/SQL programming interfaces. While TimesTen achieves the best response time running in-process with the application (also known as "direct mode"), conventional client/server access happens when several applications running on different servers share the same database.

How TimesTen In-Memory Database works diagram, description below This image show three tiers, the client-server application, application tier, and database tier. The client-server application has a local TimesTen client library. The client application connects to a TimesTen in-memory database in the Application tier through JDBC, ODBC, ADO.Net, Oracle Call Interface, Pro*C/C++, and Oracle PL/SQL programming interfaces. The TimesTen database has checkpoint files and transaction log files. The Database tier contains multiple Oracle Databases, and the TimesTen is connects to those databases.

TimesTen benefits

  • Extreme OLTP performance

    Achieves extremely low latency application performance by delivering data from an in-memory database that is colocated with applications.

  • Easy installation and deployment

    Includes Helm charts and YAML manifest files that make it easy to install and deploy TimesTen databases through TimesTen Kubernetes Operator.

  • Automatic monitoring and management

    Supports automatic lifecycle management of TimesTen databases, including taking autocorrective actions. Automatic management reduces the need for human-assisted database maintenance, allowing TimesTen production deployments to run more efficiently.

  • Highly available data management

    Uses active standby replication topology to support high availability. The read-only subscriber replication option offers additional off-site disaster recovery protection.

TimesTen offerings

Use TimesTen as a database of record

TimesTen Classic is a memory-optimized relational database that provides responsiveness and high throughput for applications. This offering is feature-rich for use independently as a system of record, such as recoverability through checkpoint and transaction logs, backup and restore, and support of various APIs. Through transactional replication, TimesTen Classic offers high availability for the in-memory database.

TimesTen resources

Get started with Oracle TimesTen In-Memory Database

TimesTen community

Participate in the TimesTen discussion forum.

TimesTen blog

Learn about the latest TimesTen news, product updates, and highlights.

Contact us

Interested in learning more? Contact one of our industry-leading experts.