Create entry

MemSQL vs. teradata

MemSQL teradata + Add column
MemSQL Apache Hive
Category
Preference 75% votes 25% votes
Website www.​memsql.​com hive.​apache.​org
License
Design
Database model
Data storage
Embeddable Yes Yes
Features
Query language
Data types
Conditional entry updates Yes ?
Map and reduce Yes Yes
Unicode Yes Yes
TTL for entries No ?
Compression Yes Yes
Integrity
Integrity model ?
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes No
Referential integrity Yes Yes
Revision control Yes ?
Locking model ?
Indexing
Secondary Indexes Yes Yes
Composite keys Yes ?
Full text search No ?
Geospatial Indexes Yes No
Graph support No ?
Graph type ?
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding Yes Yes
Shared nothing architecture Yes ?
Restrictions
Value size max. 1 000 EB ?
System requirements
Operating system
Native driver
Memory recommended 32 GB ?
Memory minimum 16 GB ?
Architecture
Programming language
More
Description In-Memory Database used for real-time analytics. Big Data
Multi-user system Yes Yes
Database ?
Price rating ★★★★☆ ?
Standard compliance Yes ?
Software distribution
Object-Relational Mapping (ORM) Yes ?
Release Date 18ᵗʰ June 2012 ?
Documentation level ★★★★☆ ★★★☆☆
Distributed Counter Yes ?
Free to use Conditional Yes
Active Yes Yes
Database Connection Pooling Yes ?
Real time analytics Yes Yes
Web interface Yes ?
2 Letter Country Code US ?
Cloud platform support ?
Online backup Yes ?
Function Based Index Yes ?
Log Yes ?
Implementation flexibility (100% global votes) (0% global votes)
Download www.​memsql.​com/​#download ?
Backup functionality Good ?
Query Cache Yes ?
Ease of use ★★★★☆ ★★★☆☆
Free for commercial use No Yes
Sorts Yes ?
Open Source No Yes
Perfomance ★★★★☆ ?
Materialized Views No ?
Spring Data Support Yes ?
Predictive Analytics Yes ?
Geospatial Yes ?
JSON Yes ?
Stored Procedure Yes ?
Concurrency Yes ?
24/7 support Yes ?
Free edition Yes ?
Kafka Integration Yes ?
SQL Queries Yes ?
3D Support Yes ?
Minimum Java version 1.7 ?
Multi-statement Transactions Yes ?
Does your mom understand it No ?
Monitoring UI Yes ?
CLI` Yes ?
Columner Yes ?
:( No ?
Apache Spark Integration Yes ?
; drop table users; Yes ?
Redis API No ?
Compute Grid No ?
Incremental Backup No ?
 Exportar a Excel las personas relacionas con la solicitud No ?
Brand ?
In-Place Update ? No
? Yes
+ Add row ++
MemSQL teradata
  • 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