Create entry

HANA vs. Essbase

HANA Essbase + Add column
Description In-memory database ?
Multi-user system Yes Yes
Memory minimum 64 GB 64 MB
Operating system
Website https:/​/​www.​sap.​com/​produ…rm/​hana.​html www.​oracle.​com/​bi
Database model
Query language
Transactions Yes ?
Unicode Yes Yes
Referential integrity Yes ?
Price rating ★★★☆☆ ★★★★☆
Standard compliance Yes Yes
Sharding Yes ?
Replication Yes Yes
Map and reduce No Yes
Revision control Yes ?
Atomicity Yes ?
Consistency Yes ?
Isolation Yes ?
Durability (data storage) Yes Yes
Horizontal scalable Yes Yes
Integrity model ?
Full text search Yes ?
Preference (44% global votes) (71% global votes)
Documentation level ★★★★★ ★★★★☆
Composite keys Yes ?
Free to use No No
Active Yes Yes
Database Connection Pooling Yes ?
Compression Yes Yes
Real time analytics Yes Yes
Community Driven No No
Shared nothing architecture Yes ?
Web interface Yes Yes
Versioning Basic ?
Secondary Indexes Yes ?
Graph support Yes ?
Embeddable No No
Geospatial Indexes Yes ?
Replication mode ?
Cloud platform support ?
Online backup Yes Yes
Log Yes Yes
Implementation flexibility 25% votes 75% votes
Download https:/​/​support.​sap.​com/​e…wnloads.​html ?
Backup functionality Good Good
Query Cache Yes Yes
Ease of use ★★★☆☆ ★★★★☆
Free for commercial use No No
Sorts Yes Yes
Open Source No No
Triggers Yes Yes
Perfomance ★★★★☆ ★★★★☆
Predictive Analytics Yes Yes
Geospatial Yes ?
Text Analytics Yes ?
HTML5 Charts Yes ?
JSON Yes ?
Flexible Table(Schema) Yes ?
Stored Procedure Yes Yes
Concurrency Yes ?
24/7 support Yes ?
Free edition Yes ?
Websphere Dyna Cache Integration No ?
SQL Queries Yes ?
Multi-statement Transactions Yes ?
Monitoring UI Yes ?
Recursive queries Yes ?
Online backup (no locking) Yes ?
CLI` Yes ?
Columner Yes ?
Apache Spark Integration Yes ?
Programming language ?
Database ?
Multilingual content ? Yes
Multiple projects ? Yes
Conditional entry updates ? Yes
Programming paradigm ?
API ? Good
Locking model ?
Data storage ?
Native driver ?
Community feedback ? ★★★★☆
In-Place Update ? Yes
Easy of Use ? Yes
Revenue Tracking ? Yes
+ Add row ++
HANA Essbase
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    = better
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.