在2008年的時(shí)候，我還是只知道DB2, Oracle, MS SQLServer, Sybase, MySQL, PostgreSQL,  Firebird等主流商業(yè)或者開(kāi)源數(shù)據(jù)庫(kù)。當(dāng)汲取知識(shí)于網(wǎng)絡(luò)之際，突然發(fā)現(xiàn)很多新的名詞魚(yú)躍而出，什么 SQLite, Memcached,  FastDB, MongoDB, Solr, Redis, HBase,  Cassandra, Teradata, Hive, CouchDB, HBase等等。也不免的困惑了很多。

試著逐步理清頭緒，首先數(shù)據(jù)庫(kù)分為關(guān)系型數(shù)據(jù)庫(kù)Relational DBMS和非關(guān)系型數(shù)據(jù)庫(kù)NoSQL 數(shù)據(jù)庫(kù)。

>> 關(guān)系型數(shù)據(jù)庫(kù)Relational DBMS包含:
     DB2, Oracle, MS SQLServer, Sybase, MySQL, PostgreSQL,  Firebird。

>> 非關(guān)系型數(shù)據(jù)庫(kù)NoSQL包含：
      SQLite, Memcached,  FastDB, MongoDB, Solr, Redis, HBase,  Cassandra,
      Teradata, Hive, CouchDB, HBase, Neo4j, Riak

簡(jiǎn)單應(yīng)用場(chǎng)景對(duì)比：

關(guān)系型數(shù)據(jù)庫(kù)的優(yōu)勢(shì)： 結(jié)構(gòu)化數(shù)據(jù)、范式模型、ACID事務(wù)。

NoSQL優(yōu)勢(shì)：性能、可擴(kuò)展性、靈活的模式和分析能力。在下列應(yīng)用中更有優(yōu)勢(shì)
a.存儲(chǔ)的數(shù)據(jù)實(shí)質(zhì)上是半結(jié)構(gòu)化或者松散的；
b.要求一定等級(jí)的性能和擴(kuò)展性；
c.存取該數(shù)據(jù)的應(yīng)用和最終的一致性相吻合

NoSQL非關(guān)系型數(shù)據(jù)庫(kù)典型支持功能：
a.模式靈活
b.無(wú)共享結(jié)構(gòu)
c.分片做為數(shù)據(jù)存儲(chǔ)模型的一部分
d.異步復(fù)制
e.使用BASE取代ACID事務(wù)。

 
繼續(xù)分類(lèi)：

其次，數(shù)據(jù)庫(kù)也可以分為基于磁盤(pán)的數(shù)據(jù)庫(kù)和基于內(nèi)存的數(shù)據(jù)庫(kù)。

硬盤(pán)型數(shù)據(jù)庫(kù)包含
>>關(guān)系型數(shù)據(jù)庫(kù)Relational DBMS: 全部
>>NoSQL：MongoDB

內(nèi)存型數(shù)據(jù)庫(kù)包含
>>NoSQL：SQLite, Memcached,  FastDB, Redis

繼續(xù)分類(lèi)：
NoSQL根據(jù)實(shí)現(xiàn)又分為：

You are here: InfoQ Homepage Research NoSQL Database Adoption Trends

NoSQL Database Adoption Trends

by Srini Penchikala on Jul 23, 2013 

UPDATE Aug 08 2013: The following new NoSQL database options were added today, after user request and feedback: GridGain, GigaSpaces, Tibco, and MarkLogic.

UPDATE Jul 25 2013: The following options were added today, after user request: Oracle Coherence, Terracotta BigMemory, Couchbase, and Oracle NoSQL Database.

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:
  ·     The data stored is semi-structured or unstructured in nature
  ·     The applications that access this data require a certain level of performance and scalability
  ·     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

(譯版：一網(wǎng)打盡2013最常用的NoSQL數(shù)據(jù)庫(kù)http://blog.chedushi.com/archives/7306)

>>文檔數(shù)據(jù)庫(kù)
     a. MongoDB：開(kāi)源、面向文檔，也是當(dāng)下最人氣的NoSQL數(shù)據(jù)庫(kù)。
     b. CounchDB：Apache CounchDB是一個(gè)使用JSON的文檔數(shù)據(jù)庫(kù)，使用Javascript做MapReduce查詢(xún)，以及一個(gè)使用HTTP的API。
     c. Couchbase：NoSQL文檔數(shù)據(jù)庫(kù)基于JSON模型。
     d. RavenDB：RavenDB是一個(gè)基于.net語(yǔ)言的面向文檔數(shù)據(jù)庫(kù)。
     e. MarkLogic：MarkLogic NoSQL數(shù)據(jù)庫(kù)用來(lái)存儲(chǔ)基于XML和以文檔為中心的信息，支持靈活的模式。

>>圖數(shù)據(jù)庫(kù)
     a. Neo4j： Neo4j是一個(gè)圖數(shù)據(jù)庫(kù)；支持ACID事務(wù)（原子性、獨(dú)立性、持久性和一致性）
     b. InfiniteGraph：一個(gè)圖數(shù)據(jù)庫(kù)用來(lái)維持和遍歷對(duì)象間的關(guān)系，支持分布式數(shù)據(jù)存儲(chǔ)。
     c. AllegroGraph：AllegroGraph是結(jié)合使用了內(nèi)存和磁盤(pán)，提供了高可擴(kuò)展性，支持SPARQ、RDFS++和Prolog推理。

>>鍵值數(shù)據(jù)存儲(chǔ)
    a. Riak：Riak是一個(gè)開(kāi)源，分布式鍵值數(shù)據(jù)庫(kù)，支持?jǐn)?shù)據(jù)復(fù)制和容錯(cuò)。
    b. Redis：Redis是一個(gè)開(kāi)源的鍵值存儲(chǔ)。支持主從式復(fù)制、事務(wù)，Pub/Sub、Lua腳本，還支持給Key添加時(shí)限。
    c. Dynamo：Dynamo是一個(gè)鍵值分布式數(shù)據(jù)存儲(chǔ)。它直接由亞馬遜Dynamo數(shù)據(jù)庫(kù)實(shí)現(xiàn)；在亞馬遜S3產(chǎn)品中使用。
    d. Oracle NoSQL Database：來(lái)自Oracle的鍵值NoSQL數(shù)據(jù)庫(kù)。它支持事務(wù)ACID（原子性、一致性、持久性和獨(dú)立性）和JSON。
    e. Oracle NoSQL Database：具備數(shù)據(jù)備份和分布式鍵值存儲(chǔ)系統(tǒng)。
    f. Voldemort：具備數(shù)據(jù)備份和分布式鍵值存儲(chǔ)系統(tǒng)。
    g. Aerospike：Aerospike數(shù)據(jù)庫(kù)是一個(gè)鍵值存儲(chǔ)，支持混合內(nèi)存架構(gòu)，通過(guò)強(qiáng)一致性和可調(diào)一致性保證數(shù)據(jù)的完整性。

>>列存儲(chǔ)數(shù)據(jù)庫(kù)
    a. Cassandra：Cassandra是列存儲(chǔ)數(shù)據(jù)庫(kù)，支持跨數(shù)據(jù)中心的數(shù)據(jù)復(fù)制。它的數(shù)據(jù)模型提供列索引，log-structured修改，支持反規(guī)范化，實(shí)體化視圖和嵌入超高速緩存。
    b. HBase：Apache Hbase源于Google的Bigtable，是一個(gè)開(kāi)源、分布式、面向列存儲(chǔ)的模型。在Hadoop和HDFS之上提供了像Bigtable一樣的功能。
    c. Amazon SimpleDB：Amazon SimpleDB是一個(gè)非關(guān)系型數(shù)據(jù)存儲(chǔ)，它卸下數(shù)據(jù)庫(kù)管理的工作。開(kāi)發(fā)者使用Web服務(wù)請(qǐng)求存儲(chǔ)和查詢(xún)數(shù)據(jù)項(xiàng)。
    d. Apache Accumulo：Apache Accumulo的有序的、分布式鍵值數(shù)據(jù)存儲(chǔ)，基于Google的BigTable設(shè)計(jì)，建立在Apache Hadoop、Zookeeper和Thrift技術(shù)之上。
    e. Hypertable：Hypertable是一個(gè)開(kāi)源、可擴(kuò)展的數(shù)據(jù)庫(kù)，模仿Bigtable，支持分片  
    f. Azure Tables：Windows Azure Table Storage Service為要求大量非結(jié)構(gòu)化數(shù)據(jù)存儲(chǔ)的應(yīng)用提供NoSQL性能。表能夠自動(dòng)擴(kuò)展到TB級(jí)別，能通過(guò)REST和Managed API訪(fǎng)問(wèn)。

>>內(nèi)存數(shù)據(jù)網(wǎng)格
  a. Hazelcast：Hazelcast CE是一個(gè)開(kāi)源數(shù)據(jù)分布平臺(tái)，它允許開(kāi)發(fā)者在數(shù)據(jù)庫(kù)集群之上共享和分割數(shù)據(jù)。
   b. Oracle Coherence：Oracle的內(nèi)存數(shù)據(jù)網(wǎng)格解決方案提供了常用數(shù)據(jù)的快速訪(fǎng)問(wèn)能力，一致性支持事務(wù)處理能力和數(shù)據(jù)的動(dòng)態(tài)劃分。
  c. Terracotta BigMemory：來(lái)自Terracotta的分布式內(nèi)存管理解決方案。這項(xiàng)產(chǎn)品包括一個(gè)Ehcache界面、Terracotta管理控制臺(tái)和BigMemory-Hadoop連接器。
  d. GemFire：Vmware vFabric GemFire是一個(gè)分布式數(shù)據(jù)管理平臺(tái)，也是一個(gè)分布式的數(shù)據(jù)網(wǎng)格平臺(tái)，支持內(nèi)存數(shù)據(jù)管理、復(fù)制、劃分、數(shù)據(jù)識(shí)別路由和連續(xù)查詢(xún)。
  e. Infinispan：Infinispan是一個(gè)基于Java的開(kāi)源鍵值NoSQL數(shù)據(jù)存儲(chǔ)，和分布式數(shù)據(jù)節(jié)點(diǎn)平臺(tái)，支持事務(wù)，peer-to-peer 及client/server 架構(gòu)。
 f. GridGain：分布式、面向?qū)ο蟆⒒趦?nèi)存、SQL+NoSQL鍵值數(shù)據(jù)庫(kù)。支持ACID事務(wù)。
 g. GigaSpaces：GigaSpaces內(nèi)存數(shù)據(jù)網(wǎng)格能夠充當(dāng)應(yīng)用的記錄系統(tǒng)，并支持各種各樣的高速緩存場(chǎng)景。