Create entry

HANA vs. MemSQL

HANA MemSQL + Add column
Category
More
Description In-memory database In-Memory Database used for real-time analytics.
Brand ?
Multi-user system Yes Yes
Memory minimum 64 GB 16 GB
License
Operating system
Website https:/​/​www.​sap.​com/​produ…rm/​hana.​html www.​memsql.​com
Database model
Query language
Transactions Yes Yes
Unicode Yes Yes
Referential integrity Yes Yes
Price rating ★★★☆☆ ★★★★☆
Standard compliance Yes Yes
Sharding Yes Yes
Replication Yes Yes
Map and reduce No Yes
Revision control Yes Yes
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Horizontal scalable Yes Yes
Integrity model
Full text search Yes No
Preference 50% votes 50% votes
Documentation level ★★★★★ ★★★★☆
Composite keys Yes Yes
Free to use No Conditional
Active Yes Yes
Database Connection Pooling Yes Yes
Compression Yes Yes
Real time analytics Yes Yes
Community Driven No ?
Shared nothing architecture Yes Yes
Web interface Yes Yes
Versioning Basic ?
Secondary Indexes Yes Yes
Graph support Yes No
Embeddable No Yes
Geospatial Indexes Yes Yes
Replication mode
Cloud platform support
Online backup Yes Yes
Log Yes Yes
Implementation flexibility (0% global votes) (100% global votes)
Download https:/​/​support.​sap.​com/​e…wnloads.​html www.​memsql.​com/​#download
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 ?
Perfomance ★★★★☆ ★★★★☆
Predictive Analytics Yes Yes
Geospatial Yes Yes
Text Analytics Yes ?
HTML5 Charts Yes ?
JSON Yes Yes
Flexible Table(Schema) Yes ?
Stored Procedure Yes Yes
Concurrency Yes Yes
24/7 support Yes Yes
Free edition Yes Yes
Websphere Dyna Cache Integration No ?
SQL Queries Yes Yes
Multi-statement Transactions Yes Yes
Monitoring UI Yes Yes
Recursive queries Yes ?
Online backup (no locking) Yes ?
CLI` Yes Yes
Columner Yes Yes
Apache Spark Integration Yes Yes
Memory recommended ? 32 GB
Programming language ?
Database ?
Software distribution ?
Object-Relational Mapping (ORM) ? Yes
Release Date ? 18ᵗʰ June 2012
TTL for entries ? No
Value size max. ? 1 000 EB
Conditional entry updates ? Yes
Distributed Counter ? Yes
2 Letter Country Code ? US
Locking model ?
Data storage ?
Graph type ?
Native driver ?
Data types ?
Function Based Index ? Yes
Materialized Views ? No
Spring Data Support ? Yes
Kafka Integration ? Yes
3D Support ? Yes
Minimum Java version ? 1.7
Does your mom understand it ? No
:( ? No
; drop table users; ? Yes
Redis API ? No
Compute Grid ? No
Incremental Backup ? No
 Exportar a Excel las personas relacionas con la solicitud ? No
+ Add row ++
HANA MemSQL
  • vsChart is like a wiki

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

  • blue
    = good
    darker
    = better
    Legend
  • 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.

Type
Review
Comment