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 650 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 20 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.
- Billing and Order Support System – One of the World’s Largest Mobile Telecommunications Providers : replaced Oracle
- Online Trading System – E*TRADE : switched from Oracle
- Korea Workers’ Compensation & Welfare Service : switched from Sybase
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 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
Altibase – Downloading is Believing.