▼ Actions
| |||
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 |
Just click a data cell to edit it.
Take part and share your knowledge with the world.