Skip to main content

Advances, Systems and Applications

Journal of Cloud Computing Cover Image

Table 1 Querying capabilities

From: Data management in cloud environments: NoSQL and NewSQL data stores

NoSQL data stores Querying License
Map reduce REST Query Other API Other features
Key-value stores Redis http://redis.io No Third-party APIs Does not provide SQL-like querying CLI and API in several languages Server-side scripting support using Lua. Open source: BSD (Berkeley Software Distribution).
Memcached http://memcached.org No Third-party APIs Does not provide SQL-like querying CLI and API in several languages. Binary and ASCII protocols for custom client development No server-side scripting support. Open source: BSD 3-clause license.
BerkeleyDB http://www.oracle.com/us/products/database/berkeley-db/overview/index.html No Yes SQLite CLI and API in several languages. No secondary indices, no server-side-scripting support. Closed source: Oracle sleepycat license.
Voldemort http://www.project-voldemort.com/voldemort Yes Under development No Clients for several languages   Open source: Apache 2.0 license.
Riak http://basho.com/riak Yes Yes Riak search, secondary indices CLI and API in several languages Provides filtering through key filters. Configurable secondary indexing. Provides Solr search capabilities. Provides server-side scripting. Open source: Apache 2.0 license.
Column family stores Cassandra http://cassandra.apache.org Yes Third party APIs Cassandra query language CLI and API in several languages. Supports Thrift interface Secondary indexing mechanisms include column families, super-columns, collections. Open source: Apache 2.0 license.
HBase http://hbase.apache.org Yes Yes No, could be used with Hive Java/Any Writer Server-side scripting support. Several secondary indexing mechanisms. Open source: Apache 2.0 license.
DynamoDB (Amazon service) http://aws.amazon.com/dynamodb Amazon Elastic MapReduce Yes Proprietary API in several languages Provides secondary indexing based on attributes other than primary keys. Closed source: Pricing as pay-per-use basis.
Amazon SimpleDB (Amazon service) http://aws.amazon.com/simpledb No Yes Amazon proprietary Amazon proprietary API Automatic indexing for all columns. Closed source: Pricing as pay-per-use basis.
Document stores MongoDB http://www.mongodb.org Yes Yes Proprietary CLI and API in several languages Server-side scripting and secondary indexing support. A powerful aggregation framework. Open source: Free GNU AGPL v3.0 license.
CouchDB http://couchdb.apache.org Yes Yes SQL like UnQL, under development API in several languages Server-side scripting and secondary indexing support. Open source: Apache 2.0 license.
Couchbase server http://www.couchbase.com Yes Yes No Memcached API + protocol (binary and ASCII) in several languages. Server-side scripting and secondary indexing support. Open source: Free community edition. Paid enterprise edition.
Graph databases Neo4J http://www.neo4j.org No Yes Cypher, Gremlin and SparQL CLI and API in several languages Server-side scripting and secondary indexing support. Open source license: NTCL + (A)GPLv3.
HyperGraphDB http://www.hypergraphdb.org/ No Yes SQL like querying Currently has Java API. Could be used with Scala. Provides a search engine and Seco scripting IDE. Open source license: GNU LGPLv3.
Allegro graph http://www.franz.com/agraph/allegrograph No Yes SparQL and Prolog API in several languages Support for Solr indexing and search. Closed source: free, developer and enterprise versions.
NewSQL VoltDB http://voltdb.com/ No Yes SQL CLI and API in several languages. JDBC support Stored procedures are written in Java. Tables cannot join with themselves, and all joined tables must be partitioned over the same value. Open source AGPL v3.0 license.
Commercial enterprise edition.
Spanner Yes NA SQL like language NA Tables are partitioned into hierarchies, which describe locality relationship between tables. Google internal use only.
Clustrix http://www.clustrix.com/ No No SQL Wire protocol compatible with MySQL.   Closed source. Available as a service in the AWS marketplace, as an appliance, and as standalone software.
NuoDB http://www.nuodb.com/ No No SQL CLI and drivers for most common data access APIs (JDBC, ODBC, ADO.NET). Also provides a C++ API. No support for stored procedures. Closed source. Pro and developers editions. Available as a service in the AWS marketplace.