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.

  • No durability
  • Relaxed durability
  • Enhanced durability
  • Strict durability

Does not require high performance disk for disk logs unlike SAP HANA
which needs SSD or Flash disk

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
  • Orange (Warevalley)
  • ALTIBASE HDB client package for application-library
  • ALTIBASE HDB installer and automatic updater
  • SAP HANA studio
  • SAP HANA client for application-library
  • SUM(Software Update Manager) and LM(LifeCycle Management)
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