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

Altibase matches Oracle and other legacy DBMSs function for function except that Altibase is open source.

  • Altibase provides richer sets of feature and functionality and great reliability.
  • Since 1999, Altibase has served over 600 global enterprises including 8 Fortune Global 500 companies.
  • There are no license costs with Altibase. Altibase is a freely downloadable DBMS which includes its state-of-the-art sharding.
  • Altibase’s subscription fees are flexible and competitive.
  • Altibase’s 19 years’ accumulated know-how of dealing with over 6,000 mission critical use cases provides peace of mind and accountability.

Altibase provides cutting-edge sharding.

  • Altibase is designed to supper-minimize the use of coordinators so that you can add as many servers as necessary without experiencing coordinator-related performance degradation in scaling out your systems.
  • It is easy and straightforward to deploy Altibase’s sharding as it does not require any changes to your existing applications if your systems are built on relational databases.

Altibase is a hybrid database.

  • Altibase combines an in-memory database and an on-disk database into a single product to achieve the speed of memory and the storage capacity of disk.
  • Altibase’s hybrid architecture 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).
  • Altibase has been deployed in over 6,000 extremely demanding use cases such as billing and authentication for mega telecom companies and other applications for finance and manufacturing companies with very high throughput requirements.

Since 1999, Altibase has competed neck and neck with Oracle and other legacy database vendors. The 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

Altibase – Downloading is Believing.