How does Altibase compare to Oracle TimesTen and other in-memory databases?
- Post by
- Altibase
- Date
- 2021-03-10
Altibase provides superior performance in comparison to Oracle TimesTen and other in-memory DBMSs.
Representative examples include 99.999% HA, horizontal and vertical scalability, hybrid DB technology and more.
When compared against Oracle TimesTen, Altibase excels in overall performance and especially in complex queries, and its data durability in system failure situations is more stable.
Altibase provides various communication channels (TCP/IP, SSL/TLS, Unix Domain Socket, IPC and IPC-DA) to optimize performance.
Altibase’s IPC-DA and Oracle TimesTen’s DA are similar in that both allow applications to directly read and write data to shared memory, which minimizes memory access and maximizes access performance.
However, Altibase’s IPC-DA compares favorably to Oracle TimesTen’s DA because the former is safer than the latter. With Altibase’s IPC-DA, a client program accesses only a communication buffer, not data itself, so that it is not possible for the data to be exposed to corruption whereas Oracle TimesTen’s DA accesses a database directly so that data in the database is always potentially exposed to corruption.
Since 1999, Altibase has competed neck and neck with Oracle TimesTen. The following case studies include related stories.
Altibase vs. Other In-Memory Databases
Category | Items | Altibase | Oracle TimesTen | IBM SolidDB | SAP HANA |
Communication Channel | Direct Access | Supported | Supported | Not Supported | Not Supported |
Lock Mechanism | MVCC | Supported | Supported | Supported | Supported |
Functionality | SQL | SQL92, SQL99 | SQL92, SQL99 | SQL92, SQL99, SQL2003 | SQL92, SQL99 |
Replication | Supported | Supported | Supported | Supported |
Performance (Complex Queries) | TPC-H | High performance | Low performance | Low performance | High performance |
Productivity | Development Convenience | APRE, PSM(PL/SQL) | ProC, PL/SQL | SA API, procedure | Precompiler Not offered, stored procedure |
Usability | Management Tools | Orange | Oracle Enterprise Manager | Solid console | SPS 07 |
Platforms | Fully supported | Fully supported | Fully supported | Fully supported |
Interactive SQL Tool | Supported | Supported | Supported | Supported |
Storage Management | On-Disk Table | Supported | Not supported | Not supported | Not supported |
Multiple DB Files Configuration | Supported | Not supported | Not supported | Supported |
DB Autoextend | Supported | Not supported | Not supported | Supported |
Replication | 1:N way | Supported | Supported | Supported | Supported |
Replication b/t Heterogeneous Systems | Supported | Supported | Supported | Supported |
Replication Unit | Table | Table, database | Table | Table |
Offline Replication | Supported | Not supported | Not supported | Not supported |
Transaction | Save-Point | Supported | Supported | Supported | Supported |
Rollback | Supported | Supported | Supported | Supported |
Stability | DB Backup | Offline, online, logical, incremental | Offline, online, logical, incremental | Offline, online, logical backup | Offline, online, logical backup |
Range of Data Recovery | Transaction, media, system failure | Transaction, media, system failure | Transaction, media, system failure | Transaction, media, system failure |
Interface | Embedded SQL | Supported | Supported | Supported | Supported |
ODBC | Supported | Supported | Supported | Supported |
JDBC | Supported | Supported | Supported | Supported |
XA API | Supported | Supported | Supported | Not supported |
SQLCLI | Supported | Supported | Supported | Not Supported |
C API | Supported | Supported | Supported | Not Supported |
Advanced SQL | SQL Plan Cache | Supported | Not supported | Not supported | Supported |
Queue Table | Supported | Not supported | Not supported | Not supported |
DB Link | Supported | Not supported | Not supported | Supported |
