Altibase HDB V6R2 vs. SolidDB 6.3

Functionality
ITEM ALTIBASE HDB V6R2 SolidDB 6.3
DBMS Process Structure Single Process & Multi Threads Single Process & Multi Threads
Model Relational DBMS Relational DBMS
Architecture Client-Server Client-Server / Embedded
DBMS Type Hybrid DBMS (Combination of Disk DBMS and Memory DBMS as a single engine) Memory DBMS Only
Tablespace Supported (Manages the size of tablespace individually and is available for backup) Index structure based Memory DBMS only. Large Cache size causes poor performance
Archive Log Mode Supported Supported
Replication Log-based replication (N-Way replication supported)Off-Line Replication option (directly copies the database using off-line
replication option)
Sync-based replication supportPublish-Subscriber model based replication in used
Locking Mode Multi Versioning Concurrency Control Multi Versioning Concurrency Control
Logfile Managing Method “Creates sequential log files.
Improves the performance using
Parallel Logging method to distribute I/O bottleneck”
Creates sequential log files
Automatic DB Size Extension Supported (Online) Not Supported (Manages DB spaces using the parameter of file spec)
Transaction Rollback Supported Supported
Save-point Supported Not Supported
Table, Column Constraint Not Null, Primary Key, Foreign Key Not Null, Primary Key, Foreign Key
GIS Development interface supported for the GIS industry like LBS (Location-Based System) Not Supported
XA 2-Phase Commit supported as the distributed transaction processing protocol (X-Open Standard) Not Supported
Durability Level No Durability, Relax, Enhanced, Strict Strict, Relaxed and Adaptive
SQL SQL Standard SQL Standard
Store Procedure Supported Supported
Store Function Supported Not Supported
Trigger Supported Supported
JDBC Driver Supported Supported
ODBC Driver Supported Supported
PHP Driver Supported Not Supported
Embedded SQL Supported (APRE) SA API (low-level proprietary C-language API)
Standard CLI Interface Supported (CLI) Supported (CLI)
Threaded Application Supported Supported
Table Supported Supported
Milti Key-Index Supported Supported
View Supported Supported
Sequence Supported Supported
Queue Table Supported Not Supported
Monitoring View Supported Supported
Permission Supported Supported
Role Not Supported Supported
DB Audit Not Supported Not Supported
Synonym Supported (Table View, Sequence, Procedure and Function) Supported (Data Type)
Table Partitioning Disk partitioning support Not Supported
User Defined Type User Defined Type in the Stored Procedure like Object-Oriented User Defined Type
On-Line Backup Supported Supported
SNMP Supported Not Supported
DATA TYPES
ALTIBASE HDB V6R2 Note SolidDB 6.3 Note
Char Fixed length, Max 8 Kbyte Char
Wchar
Nchar Nchar
Varchar Variable length, Max 64Kbyte Varchar
Wvarchar
Nvarchar Clob Nvarchar
Long varchar
Clob Max 2Gbyte
Clob
Clob
Clob
Long wvarchar
Nclob
Tinyint
1 byte
Smallint 2 byte Smallint 2 byte
Integer 4 byte Int 4 byte
Bigint 8 byte Bigint 8 byte
Real 4 byte (Real Number) Real 4 byte (Real Number)
Float 4 byte (Real Number) Float 8 byte (Real Number)
Double 8 byte (Real Number) Double 8 byte (Real Number)
Decimal Same as Number Decimal
Numeric Same as Number
Blob
Blob
Numeric
Binary
Varbinary
Blob Max 2G Blob
Date Date Type, 8byte Date
Time
YYYY-MM-DD
HH:MM:SS
TimpestampNumber Number Type The degree of precision: p 1~38
The scale: s -84~126
Timestamp YYYY-MM-DD
HH:MM:SS:FFFFFFFFFF
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
SOLIDDB 7.0
Number of Threads Insert Select Update Delete
1 4,545 3,113 4,764 4,770
16 57,485 40,325 65,722 65,616
32 84,701 61,666 109,118 102,599
64 96,357 70,201 136,257 102,468
128 75,887 71,155 132,088 92,451

comparison-unicom