Oracle TimesTen 11gR2 vs. Altibase HDB V6R2
Performance
| ITEM | ALTIBASE HDB V6R2 | Oracle TimesTen 11gR2 |
|---|---|---|
| TPC-H | High performance with complex queries | Poor performance with complex queries |
| Synchronous Replication | 3 times faster than Oracle TimesTen | 3 times slower than ALTIBASE |
| Replication against Bulk DML | High performance | Poor performance |
Transaction
| ITEM | ALTIBASE HDB V6R2 | Oracle TimesTen 11gR2 |
|---|---|---|
| Save Point | Supported | Supported |
| Rollback | Supported | Supported |
Storage Management
| ITEM | ALTIBASE HDB V6R2 | Oracle TimesTen 11gR2 |
|---|---|---|
| Disk Table | Supported | Not Supported |
| Multiple DB Files Configuration | Supported | Not Supported |
| DB Auto Extend | Supported | Not Supported |
| Archive Log Mode | Supported | Not Supported |
Query Language
| ITEM | ALTIBASE HDB V6R2 | Oracle TimesTen 11gR2 |
|---|---|---|
| Complex Queries | Supported | Performance Degradation |
| Stored Procedure | Supported | Supported |
| Trigger | Supported | Not Supported |
| Statistic information | Supported | Supported |
| Synonym | Supported | Supported |
| Grant, Revoke | Supported | Supported |
| View | Supported | Supported |
| LOB | Supported | Supported |
Advanced SQL
| ITEM | ALTIBASE HDB V6R2 | Oracle TimesTen 11gR2 |
|---|---|---|
| SQL Plan Cache | Supported | Not Supported |
| Queue table | Supported | Not Supported |
| DB Link | Supported | Not Supported |
Application Development Environments
| ITEM | ALTIBASE HDB V6R2 | Oracle TimesTen 11gR2 |
|---|---|---|
| Embedded SQL | Supported | Supported |
| ODBC | Supported | Supported |
| JDBC | Supported | Supported |
| XA API | Supported | Supported |
| SQLCLI | Supported | Supported |
| C/C++ API | Supported | Supported |
| ADO.net, OLEDB | Supported | Not Supported |
Replication
| ITEM | ALTIBASE HDB V6R2 | Oracle TimesTen 11gR2 |
|---|---|---|
| Off-line replication | Supported | Not Supported |
| 1:N way | Supported | Supported |
| Replication with Heterogeneous Systems | Supported | Supported |
Stability
| ITEM | ALTIBASE HDB V6R2 | Oracle TimesTen 11gR2 |
|---|---|---|
| Backup | Offline, Online, Logical Backup, Incremental | Offline, Online, Local Incremental |
| Range of Data Recovery | Transaction, Media, System Failure | Transaction, Media, System Failure |
IMDB Competitive Benchmarks
| ALTIBASE HDB Hybrid In-Memory Database V6.1.1 | ||||
|---|---|---|---|---|
| Number of Threads | Insert | Select | Update | Delete |
| 1 | 4,647 | 4,778 | 4,720 | 4,980 |
| 16 | 58,372 | 69,458 | 64,299 | 66,068 |
| 32 | 102,075 | 110,658 | 105,747 | 114,062 |
| 64 | 128,667 | 131,332 | 132,618 | 136,143 |
| 128 | 134,466 | 130,061 | 129,169 | 135,975 |
| Oracle TimesTen 11g | ||||
|---|---|---|---|---|
| Number of Threads | Insert | Select | Update | Delete |
| 1 | 4,710 | 3,125 | 4,658 | 5,023 |
| 16 | 46,407 | 37,521 | 55,486 | 62,183 |
| 32 | 56,436 | 59,627 | 71,187 | 93,421 |
| 64 | 35,085 | 68,240 | 67,910 | 95,668 |
| 128 | 31,912 | 70,146 | 68,674 | 86,287 |
