|
▼ 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.