TimesTen

TimesTen is an in-memory, relational OLTP database management system with high availability. It services very well for real time application because of short response time and high throughput. TimesTen can deployed in following ways: Classic (single node), Cache and Scaleout (distributed, assume this deployment when coming to concurrency-related sections later).

History

TimesTen was originally named as SmallBase and developed by HP Labs. Shortly after its first commercial use in 1995, the product was split out as a separate startup company and renamed as TimesTen. In 2005, the company with 90 employees at the time was acquired by Oracle. TimesTen was then integrated with Oracle software as well as services and become part of Oracle Database Products.

Query Interface

SQL

Storage Architecture

In-Memory

Isolation Levels

Read Committed

Indexes

B+Tree Hash Table BitMap T-Tree

By default TimesTen uses B+Tree. The original version (SmallBase) from the 1990s supported T-Trees. TimesTen still supports T-Tree indexes but the administrator has to request for the DBMS to use them.

Compression

Dictionary Encoding

Data Model

Relational

System Architecture

Shared-Nothing

Checkpoints

Fuzzy

TimesTen Logo
Website

http://www.oracle.com/us/products/database/timesten/index.html

Tech Docs

https://docs.oracle.com/database/timesten-18.1/

Developer

HP Labs

Country of Origin

US

Start Year

1996

Former Name

SmallBase

Acquired By

Oracle

Project Type

Commercial

Supported languages

PL/SQL, SQL

Operating Systems

Linux, Windows

Licenses

Proprietary

Wikipedia

https://en.wikipedia.org/wiki/TimesTen