How Does Altibase compare to other database vendors?

While Altibase provides most of the functions/features that traditional on-disk DBMSs have, it has its own unique advantage: Altibase combines an in-memory database and an on-disk database to achieve the speed of in-memory and the storage capacity of on-disk into a single product. In comparison to other in-memory DBMSs, Altibase does not require additional investment for on-disk databases for large volumes of data storage, resulting in lower TCO.

Altibase has competed with other database vendors. Following case studies include related stories.

Altibase vs. other DBMSs

Function

Altibase

Oracle 11g

SAP Hana

IBM DB2 10.1

Process

Multi thread

Multi process

Multi thread

Multi process

Model

Relational model

Relational model

Relational model

Relational model

Architecture

Client-server

Client-server

Client-server

Client-server

DBMS type

Hybrid

(In-Memory &
On-disk)

On-disk only

In-memory only

On-disk only

LOB

Supported

Supported

Supported

Supported

Replication

Data replication

Shared storage

Data replication

Shared storage

64bit mode

Supported

Supported

Supported

Supported

Locking mode

Row level locking

Row level locking

Row level locking

Row level locking

Lock for SELECT

No locking

No locking

Locking

Locking

Consistent view

Supported

Supported

Not supported

Not supported

DB recovery

Supported

Supported

Supported

Supported

Table

Supported

Supported

Supported

Supported

Multi key-index

Supported

Supported

Supported

Supported

Stored procedure

Supported

Supported

Supported

Supported

Stored function

Supported

Supported

Supported

Supported

Sequence

Supported

Supported

Supported

Supported

Queue table

Supported

Supported

Supported

Supported

DB audit

Supported

Supported

Supported

Supported

Snapshot

Not supported

Supported

Not supported

Not supported

DB link

Supported

Supported

Supported

Supported

Synonym

Supported

Supported

Supported

Supported

Table partitioning

Supported

Supported

Supported

Supported

User defined type

Supported

Supported

Supported

Supported

On-line backup

Supported

Supported

Supported

Supported

Monitoring view

Supported

Supported

Supported

Supported

Performance Comparison Against Traditional On-disk DBMSs

Altibase processes DML statements 10 times faster than other DBMSs:

  • Memory table DML: 10 times faster than on-disk DBMSs
  • Memory table SELECT: 2~5 times faster than on-disk DBMSs
  • Test environment: memory-30GB, CPU-4.4GHZ (4 Cores), OS-AIX 6.1 64bit
  • Performance: 2 times faster than other in-memory DBMSs

8_How does Altibase compare to other database vendors-01

Comments are closed.