Table 2 Technical feature analysis of selected DBMS
From: A survey on data storage and placement methodologies for Cloud-Big Data ecosystem
DBMS | Version | Data model | Technical features | Service model | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Architecture | Sharding | Elasticity | CAP | Replication | Big Data adapter | Community | Enterprise | DBaaS | |||
MySQL | 8.0.11 | RDBMS | Single/master–slave | Manual | No | CA | Cluster | 3rd party (SQL-based) | Yes | Yes | |
PostgreSQL | 10.4 | RDBMS | Single/master–slave | Manual | No | CA | Cluster | 3rd party (SQL-based) | Yes | Yes | |
VoltDB | 8.1.2 | NewSQL | Multi-master | Hash | Yes (commercial) | CP | Cross-cluster (commercial) | 3rd party (SQL-based) | Yes | Yes | No |
CockroachDB | 2.0.3 | NewSQL | Multi-master | Hash | Yes | CP | Cross-cluster (commercial) | 3rd party (SQL-based) | Yes | Yes | No |
Riak | 2.2.3 | Key-value | Multi-master | Hash | Yes | AP | Cross-cluster | Native | Yes | Yes | No |
Redis | 4.0 | Key-value | Multi-master | Hash | Yes | AC | Cluster | Native | Yes | Yes | |
MongoDB | 4.0.0 | Document | Multi-master | Hash/range | Yes | CP | Cross-cluster | Native | Yes | Yes | https://www.mongodb.com/ Cloud/atlas |
Couchbase | 5.0.1 | Document | Multi-master | Hash | Yes | CP | Cross-cluster | Native | Yes | Yes | |
Cassandra | 3.11.2 | Wide-column | Multi-master | Hash/range | Yes | AP | Cross-cluster | Native | Yes | Yes, By DataStax | https://www.instaclustr.com/solutions/managed-apache-cassandra/ |
HBase | 2.0.1 | Wide-column | Multi-master | Hash | Yes | CP | Cross-cluster | 3rd party | Yes | Yes, By Cloudera | No |
Neo4J | 3.4.1 | Graph | Master–slave | No | Yes | CA | Cross-cluster | Native | Yes | Yes | |
JanusGraph | 0.2.0 | Graph | Multi-master | Manual | Yes | AP/CP | Cluster | 3rd party | Yes | No | No |
ArangoDB | 3.3.11 | Multi-model (key-value, document, graph) | Multi-master | Hash | Yes | CP | Cross-cluster | Native | Yes | Yes | No |
OrientDB | 3.0.2 | Multi-model (key-value, document, graph) | Multi-master | Hash | Yes | – | Cross-cluster (commercial) | Native | Yes | Yes | No |
InfluxDB | 1.5.4 | Time-series | Multi-master (commercial) | Range | Yes (commercial) | AP/CP | Cross-cluster (commercial) | 3rd party | Yes | Yes | |
Prometheus | 2.3 | Time-series | Master–slave | Manual | No | – | Cluster | 3rd party | Yes | Yes | No |