Friday, 15 August 2014

NoSQL Database Adoption Trends

NoSQL databases have been getting lot of attention over the last few years for their performance, scalability, schema flexibility and analytics capabilities. While relational databases are still good choice for certain use cases - like structured data and applications that require ACID transactions - NoSQL databases are better suited for use cases where:
  1. The data stored is semi-structured or unstructured in nature
  2. The applications that access this data require a certain level of performance and scalability
  3. The applications that access this data are ok with eventual consistency
Non-relational databases typically support the following capabilities:
  • Schema flexibility
  • Shared nothing architecture
  • Sharding as part of the data storage model
  • Asynchronous replication
  • BASE instead of ACID Transactions
InfoQ would like to learn what NoSQL databases you are currently using or planning on using in your applications.

Document Databases

  • MongoDB: MongoDB is an open-source document oriented database.
  • CouchDB: Apache CouchDB is a database that uses JSON for documents, JavaScript for MapReduce queries, and HTTP for an API.
  • Couchbase: NoSQL document database based on JSON model.
  • RavenDB: RavenDB is a document-oriented database based on .NET language.
  • MarkLogic: MarkLogic NoSQL database is used to store XML-based, document-centric information. It supports schema flexibility.
  • Other Document Database

Graph Databases 

  • Neo4j: Neo4j is a property graph database; supports ACID transactions.
  • InfiniteGraph: Graph database used to persist and traverse relationships between objects, supports distribute data stores.
  • AllegroGraph: AllegroGraph is a graph database that uses memory utilization in combination with disk-based storage for scalability, supports SPARQL, RDFS++, and Prolog reasoning.
  • Other Graph Database

Key Value Data Stores 

  • Riak: Riak is an open source, distributed key value database, supports data replication and fault-tolerance.
  • Redis: Redis is an open source key-value store. Supports master-slave replication, transactions, Pub/Sub, Lua scripting, Keys with a limited time-to-live.
  • Dynamo: Dynamo is a key-value distributed data store. It is directly implemented as Amazon DynamoDB; used in Amazon S3 product.
  • Oracle NoSQL Database: Key-value NoSQL database from Oracle. It supports ACID transactions and JSON.
  • Voldemort: Distributed key-value storage system with the data replication and partitioning.
  • Aerospike: Aerospike database is a key-value store; supports hybrid memory architecture and data integrity with strong or tunable consistency.
  • Other Key Value Data Store

Columnar Databases 

  • Cassandra: Cassandra is column database that supports data replication across multiple data centers. Its data model offers column indexes, log-structured updates, support for denormalization, materialized views, and built-in caching.
  • HBase: Apache HBase is an open-source, distributed, versioned, column-oriented store modeled after Google's Bigtable. It provides Bigtable-like capabilities on top of Hadoop and HDFS.
  • Amazon SimpleDB: Amazon SimpleDB is a non-relational data store that offloads the work of database administration. Developers store and query data items using web services requests.
  • Apache Accumulo: Apache Accumulo sorted, distributed key/value data store created based on Google's BigTable design and is built on top of Apache Hadoop, Zookeeper, and Thrift technologies.
  • Hypertable: Hypertable is an open source, scalable database, also modeled after Bigtable; supports sharding.
  • Azure Tables: Windows Azure Table Storage Service offers NoSQL capabilities for applications that require storage of large amounts of unstructured data. Tables can auto-scale to store up to several terabytes of data. They are accessible via REST and managed APIs.
  • Other Columnar Database

In-Memory Data Grids 

  • Hazelcast: Hazelcast CE is an open source data distribution platform. It allows the developers to share and partition the data across the database cluster.
  • Oracle Coherence: Oracle's in-memory data grid solution that provides fast access to frequently used data. Coherence supports event capabilities and dynamic partitioning of data.
  • Terracotta BigMemory: Distributed in-memory management solution from Terracotta. The product includes an Ehcache interface, Terracotta Management Console and BigMemory-Hadoop Connector (early access).
  • GemFire: VMware vFabric GemFire is a distributed data management platform and provides elastic in-memory data management, replication, partitioning, data-aware routing, and continuous querying.
  • Infinispan: Infinispan is a Java based open source key/value NoSQL datastore and distributed data grid platform. It supports transactions and peer-to-peer as well as client/server architecture.
  • GridGain: Distributed, object-based, in-memory, SQL+NoSQL key-value database. Supports ACID transactions.
  • GigaSpaces: GigaSpaces in-memory data grid (the Space) serves as the system of record for the applications and supports a variety of caching scenarios.
  • Tibco: ActiveSpaces product from Tibco provides an infrastructure to create virtual data caches from the aggregate memory of participating nodes in the cluster and to scale as nodes join and leave. 
  • Other In-Memory Data Grid
Please rank the following NoSQL database products, based on YOUR experience working with them or researching them for potential use in production environments, based on the following criteria:
  • Value Proposition: The value these databases can potentially bring to the business.
  • Adoption Readiness: How ready they are to be used in the real world applications.
You can drag and drop the option on the radar and click “Submit Now!” when you are done.

Value Proposition
 Amazon SimpleDB
 Apache Accumulo
 Azure Tables
 Oracle Coherence
 Terracotta BigMemory
 Oracle NoSQL Database

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...