How does Altibase compare to Oracle, SAP Hana and IBM DB2?

Altibase is an open source DBMS whereas Oracle and other legacy vendors are closed source ones. Consequently, there are no license costs with Altibase. With its flexible subscription fees, Altibase can cater to your IT budget according to your specific DB needs and requirements so that you can minimize or eliminate unnecessary expenditures.

Altibase provides most of the functions/features that Oracle does. And Altibase 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. Altibase’s hybrid architecture allows for utilization of memory tables for high performance and disk tables for economical storage and consequently eliminates the need to purchase an in-memory database and an on-disk database separately, thus resulting in lower TCO.

Altibase’s in-memory capabilities provide significantly higher throughput than Oracle (100,000+ transactions per second) and low and predictable response times (microsecond scale). With its unique hybrid architecture, Altibase has helped over 600 enterprise clients including 8 of Fortune Global 500 companies with high performing database technologies that are mandatory for extremely demanding use cases such as BSS, OCS and other applications with very high throughput requirements.

Altibase has often competed neck and neck with Oracle and other legacy database vendors. Following case studies include related stories.

Altibase vs. other legacy 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.