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.
- 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
Downloading is believing.