SAP HANA vs. Altibase
Details
ITEM | ALTIBASE HDB V6R2 | SAP HANA 1.0 SPS6 |
---|---|---|
Target Market | OLTP | OLAP |
Full ACID | Multi-level durability support for varying business requirements.
Does not require high performance disk for disk logs unlike SAP HANA |
Only strict durability is supported.High performance SSD or Flash disks are required to achieve better performance thus higher TCO |
Server/Client Interface | JDBC/ODBC/Embedded SQL/OLEDB/CLI/CAPI/.NET Provider/XA API and etcs | SQL(JDBC/ODBC), MDX(ODBO), BICS(SQL DBC) |
Hybrid Features | In-memory(row-based) + disk-resident database | In-memory(row-based + column-based) |
Usability |
|
|
Replication | Log-based replication: Enable user to accommodate REAL real-time with no limitation ALTIBASE HDB replication feature can be utilized for scaling-out and system backups in addition to data synchronization among homogeneous systems. |
Log-based replication with Sybase Replication Server: unicode only and some data types are not supported. Trigger-based replication method and ETL-based replication method: more flexible but compromise from performance. |
Data Partitioning | Horizontally supported | Column-store Horizontally supported |
Compression Rate | Low | High for column-based database, low for row-based database |
Scale-out Factor | Replication (Active-Active, Active-Standby) extended up to 32 nodes | Support cluster with shared file system extended up to 16 nodes |
Communication Cost | TCP/IP can be used for both local and remote applications. IPC and UNIX-DOMAIN provide better performance for local applications. Direct-Access and Direct-Access API modes provides unmatched performance. |
Only TCP/IP is used for remote applications. For local applications, SAP HANA recommends embedding applications in DBMS |
Procedures & Functions | Supported | Supported |
Deployment | Open System – Supports all commodity platforms | Appliance only |
Hardware Cost | Supports a range of hardware options from standard to enterprise level |
Requires high-end, expensive hardware such as SSD, flash disk, PCIe I/O bus, latest CPU based on NUMA platform, shared file system thus higher TCO. |
HA(fail-over) | Active-Active or Active-Standby configurations and scale-out up to 32 nodes via replication feature. Adaptive consistency support to meet varying performance and business requirements. |
Active-Active configuration and scale-out up to 16 nodescluster failover and need additional replicated disk. For replicated disk, the performance may suffer to ensure the data consistency. |
License Cost | Standard | Expensive |
Software Only Purchase | Possible | Impossible |
Maintenance | Easy | Hard |
Disk Database | Supported | Not Supported |
References | Many | Limited |
Vendor dependency | No | Yes |
Appropriate System Size | Small to Enterprise | Enterprise only |
Easy to Use | Yes | No |
Footprint | Small | Large |
Realtime Remote Disaster Recovery | Yes | No |
Others | Rich set of tools and utilities Extensive EcoSystem |
Limited tool and utility availability Limited EcoSystem |