18 Facts About TimesTen

1.

Oracle TimesTen In-Memory Database is an in-memory, relational database management system with persistence and high availability.

FactSnippet No. 1,563,930
2.

Originally designed and implemented at Hewlett-Packard labs in Palo Alto, California, TimesTen spun out into a separate startup in 1996 and was acquired by Oracle Corporation in 2005.

FactSnippet No. 1,563,931
3.

Applications access TimesTen using standard database APIs such as ODBC and JDBC.

FactSnippet No. 1,563,932
4.

TimesTen can be used as a standalone database, and is often used as a cache in front of another relational database such as Oracle Database.

FactSnippet No. 1,563,933
5.

TimesTen can be configured as a shared-nothing clustered system supporting databases much larger than the RAM available on a single machine, and providing scalable throughput and high availability.

FactSnippet No. 1,563,934
6.

TimesTen is an in-memory database that provides very fast data access time.

FactSnippet No. 1,563,935
7.

TimesTen can make use of available RAM available on its host machine, up to terabytes in size; using TimesTen Scaleout databases much larger than the RAM of a single machine are supported.

FactSnippet No. 1,563,936
8.

Datatypes supported by TimesTen are in general a subset of those supported by Oracle Database, including NUMBER, VARCHAR and LOBs; TimesTen specific datatypes such as binary integers are supported.

FactSnippet No. 1,563,937
9.

Applications access TimesTen databases using standard relational APIs such as ODBC, JDBC, OCI, and ODPI-C.

FactSnippet No. 1,563,938
10.

At runtime all TimesTen data is in RAM, however TimesTen utilizes non-volatile storage for database persistence and recoverability.

FactSnippet No. 1,563,939
11.

The combination of checkpoint files and transaction log files allow TimesTen to recover the database in the event of a system failure.

FactSnippet No. 1,563,940
12.

At runtime the data in a TimesTen database is stored in shared memory; this allows application processes to directly attach to the database memory and access it without IPC or context switch overheads.

FactSnippet No. 1,563,941
13.

TimesTen databases are persistent and can provide high availability, they can be used as the only database in many solutions.

FactSnippet No. 1,563,942
14.

However, TimesTen databases are often used alongside other databases such as Oracle Database, with a TimesTen database serving as a cache for a subset of data in the traditional database.

FactSnippet No. 1,563,943
15.

TimesTen provides the capability to cache data from an Oracle Database source.

FactSnippet No. 1,563,944
16.

TimesTen Scaleout allows a single TimesTen database to span many machines.

FactSnippet No. 1,563,945
17.

TimesTen was founded in HP labs by Marie-Anne Neimat, Sherry Listgarten, Kurt Shoens and Kevin Wilkerson, under the name of "Smallbase".

FactSnippet No. 1,563,946
18.

TimesTen had 90 employees and was profitable when it was acquired by Oracle Corporation in 2005.

FactSnippet No. 1,563,947