Best NoSQL Databases
TrustMaps are two-dimensional charts that compare products based on satisfaction ratings and research frequency by prospective buyers. Products must have 10 or more ratings to appear on this TrustMap, and those above the median line are considered Top Rated.
What is a NoSQL Database?
NoSQL are databases designed to be used across large distrusted systems. They are notably much more scalable and much faster at handling very large data loads than traditional relational databases.
Advantages of NoSQL over Relational Databases?
Traditional relational databases store data in highly structured tabular form, with multiple rows and columns. While these data stores are highly flexible, easy to maintain, and effective for data stored on a single server, they do not scale very well in a distributed system.
Distributed systems using inexpensive storage and processing power are becoming much more common and are often used in environments where there is a need for high availability and speed. NoSQL databases work significantly better across this kind of distributed system.
The other main advantages are:
Non-Relational means table-less, which means they are easier to manage. They provide a higher level of flexibility with newer data models.
They are often open source and therefore lower cost. NoSQL databases can be an appealing solution for smaller organizations with limited budgets.
NoSQL database are optimized for specific data models that enable higher performance than trying to accomplish similar functionality with relational databases.
NoSQL Data Models
Not all NoSQL databases use the same data model. Although the primary distinction between a relational data store and a NoSQL database is the data model, there are several different types of NoSQL data model. Below are descriptions of three of the most popular data models used in NoSQL databases:
Graph model: Graph models usually require all the data to reside on one machine which negates one of the key advantages of NoSQL databases. This class of databases uses structures like data modes, edges and properties, making it easier to model relationships between entities in an application.
Key-value model: In this model, a key is required to retrieve and update data. The key-value data model is very simple and therefore scales well. However, this simplicity and scalability come at the cost of query complexity.
NoSQL Database Pricing
NoSQL database costs can be a complex issue. Although the database itself can be free or much less expensive than a traditional relational database, the cost of maintaining a NoSQL product can be higher. Part of the reason for this is that expertise in the various types of NoSQL database is harder to find than traditional SQL expertise.
NoSQL Databases Products
MongoDB (from "humongous") is an open source document-oriented database system developed and supported by 10gen. It is part of the NoSQL family of database systems. Instead of storing data in tables as is done in a "classical" relational database, MongoDB stores structured data as JSON-like...
Cloudant is an open source non-relational, distributed database service that requires zero-configuration. It's based on the Apache-backed CouchDB project and the creator of the open source BigCouch project. Cloudant's service provides integrated data management, search, and analytics engine...
Couchbase headquartered in Mountain View, California offers the Couchbase Server, a NoSQL database.
MarkLogic is a NoSQL database from the California-based company of the same name.
DataStax is a NoSQL database offering from the California-based company of the same name.
SAP HANA, Express Edition is a scaled down version of the HANA product that can run on laptops and other resource-constrained hosts, such as cloud-hosted virtual machines. The product is free to use for in-memory databases up to 32GB of RAM.
Apache Drill is a schema-free query engine for use with NoSQL or Hadoop data or file storage systems and databases.
Qubole is a NoSQL database offering from the California-based company of the same name.
The Aerospike Database is the flagship, NoSQL database from Aerospike Inc in Mountain View, California.
The Sqream DB is a NoSQL database from Israeli software company Sqream Technologies.
OrientDB is an open-source NoSQL embeddable database from UK company Orient Technologies.
Oracle offers a NoSQL Database.
Microsoft Azure Cosmos DB is Microsoft's Big Data analysis platform. It is a NoSQL database service and is a replacement for the earlier DocumentDB NoSQL database.