Advances, Systems and Applications
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. | |
Yes | Under development | No | Clients for several languages | Â | Open source: Apache 2.0 license. | ||
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. | |