Create entry

teradata vs. MemSQL

teradata MemSQL + Add column
Apache Hive MemSQL
Category
Preference 25% votes 75% votes
Website hive.​apache.​org www.​memsql.​com
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 No Yes
Referential integrity Yes Yes
Revision control ? Yes
Locking model ?
Indexing
Secondary Indexes Yes Yes
Composite keys ? Yes
Full text search ? No
Geospatial Indexes No Yes
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 Big Data In-Memory Database used for real-time analytics.
Brand ?
Multi-user system Yes Yes
Software distribution
Documentation level ★★★☆☆ ★★★★☆
Free to use Yes Conditional
Active Yes Yes
Real time analytics Yes Yes
Ease of use ★★★☆☆ ★★★★☆
In-Place Update No ?
Free for commercial use Yes No
Open Source Yes No
Yes ?
Database ?
Price rating ? ★★★★☆
Standard compliance ? Yes
Object-Relational Mapping (ORM) ? Yes
Release Date ? 18ᵗʰ June 2012
Distributed Counter ? Yes
Database Connection Pooling ? Yes
Web interface ? Yes
2 Letter Country Code ? US
Cloud platform support ?
Online backup ? Yes
Function Based Index ? Yes
Log ? Yes
Implementation flexibility (0% global votes) (100% global votes)
Download ? www.​memsql.​com/​#download
Backup functionality ? Good
Query Cache ? Yes
Sorts ? 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
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
+ Add row ++
teradata 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