How does Altibase compare to TimesTen and other in-memory databases?

Altibase provides superior performance in comparison to TimesTen and other in-memory DBMSs. Representative examples include 99.999% HA, horizontal and vertical scalability, hybrid DB technology and more. When compared against TimesTen, Altibase excels in overall performance and especially in complex queries, and its data durability in system failure situations is more stable.

Altibase provides various communication channels (TCP/IP, SSL/TLS, Unix Domain Socket, IPC and IPC-DA) to optimize performance.

Altibase’s IPC-DA and TimesTen’s DA are similar to each other in that both allow applications to directly read and write data to shared memory, which minimizes memory access and maximizes access performance. However, Altibase’s IPC-DA compares favorably to TimesTen’s DA because the former is safer than the latter. With Altibase’s IPC-DA, a client program accesses only a communication buffer, not data itself, so that it is not possible for the data to be exposed to corruption whereas TimesTen’s DA accesses a database directly so that data in the database is always potentially exposed to corruption.

Altibase has competed neck and neck particularly with TimesTen. Following case studies include related stories.

Altibase vs. Other In-Memory Databases

Category

Items

Altibase

Oracle TimesTen

IBM SolidDB

SAP HANA

Communication Channel

Direct Access

Supported

Supported

Not Supported

Not Supported

Lock Mechanism

MVCC

Supported

Supported

Supported

Supported

Functionality

SQL

SQL92, SQL99

SQL92, SQL99

SQL92, SQL99, SQL2003

SQL92, SQL99

Replication

Supported

Supported

Supported

Supported

Performance

(Complex Queries)

TPC-H

High performance

Low performance

Low performance

High performance

Productivity

Development

Convenience

APRE, PSM(PL/SQL)

ProC, PL/SQL

SA API, procedure

Precompiler Not offered, stored procedure

Usability

Management Tools

Orange

Oracle Enterprise Manager

Solid console

SPS 07

Platforms

Fully supported

Fully supported

Fully supported

Fully supported

Interactive SQL Tool

Supported

Supported

Supported

Supported

Storage Management

On-Disk Table

Supported

Not supported

Not supported

Not supported

Multiple DB Files Configuration

Supported

Not supported

Not supported

Supported

DB Autoextend

Supported

Not supported

Not supported

Supported

Replication

1:N way

Supported

Supported

Supported

Supported

Replication b/t Heterogeneous Systems

Supported

Supported

Supported

Supported

Replication Unit

Table

Table, database

Table

Table

Offline Replication

Supported

Not supported

Not supported

Not supported

Transaction

Save-Point

Supported

Supported

Supported

Supported

Rollback

Supported

Supported

Supported

Supported

Stability

DB Backup

Offline, online, logical, incremental

Offline, online, logical, incremental

Offline, online, logical backup

Offline, online, logical backup

Range of Data Recovery

Transaction, media,
system failure

Transaction, media,
system failure

Transaction, media,
system failure

Transaction, media,
system failure

Interface

Embedded SQL

Supported

Supported

Supported

Supported

ODBC

Supported

Supported

Supported

Supported

JDBC

Supported

Supported

Supported

Supported

XA API

Supported

Supported

Supported

Not supported

SQLCLI

Supported

Supported

Supported

Not Supported

C API

Supported

Supported

Supported

Not Supported

Advanced SQL

SQL Plan Cache

Supported

Not supported

Not supported

Supported

Queue Table

Supported

Not supported

Not supported

Not supported

DB Link

Supported

Not supported

Not supported

Supported

Comments are closed.