Skip to main content

Advertisement

Springer Nature is making SARS-CoV-2 and COVID-19 research free. View research | View latest news | Sign up for updates

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 https://Cloud.oracle.com/ mysql
PostgreSQL 10.4 RDBMS Single/master–slave Manual No CA Cluster 3rd party (SQL-based) Yes Yes https://aws.amazon.com/rds/postgresql/
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 https://redislabs.com/
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 https://www.couchbase.com/products/Cloud/managed-Cloud
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 https://www.graphstory.com/
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 https://cloud.influxdata.com/
Prometheus 2.3 Time-series Master–slave Manual No Cluster 3rd party Yes Yes No