16 NoSQL, NewSQL Databases To Watch

Traditional relational databases weren't invented with mobile, social, and big data types -- or extreme scale -- in mind. Get expert context on 16 next-era NoSQL and NewSQL choices.
Aerospike memory supports real-time decisions.
Cassandra tops global scalability charts.
Clustrix promises Web scale with SQL.
Couchbase goes after mobile applications.
DynamoDB keeps high-scale cloud apps humming.
HBase does NoSQL on Hadoop.
IBM snaps up Cloudant, but what's next?
MarkLogic brings maturity to flexible data management.
MemSQL combines in-memory performance with SQL appeal.
MongoDB appeals to modern developers.
NuoDB counts on SQL, cloud.
Oracle NoSQL Database: Old vendor, fresh alternative
Riak goes big, goes cloud.
Splice Machine puts transactional SQL on Hadoop.
Translattice scales out PostgreSQL.
VoltDB handles fast-streaming data.

Why are businesses increasingly choosing alternatives to the leading relational database management systems when grappling with new data types and extreme scale?

We put that question to Bryson Koehler, CIO of The Weather Company, which is using a NoSQL database, Riak, as the foundation of a cloud-based weather prediction and forecasting system handling 20 terabytes of data per day. His answer was emphatic:

"We knew that we needed to run globally, and we knew we needed to scale to an astronomical level. I knew that I needed that to be fundamentally baked in to how we built the system. I didn't want it to be an add-on. I didn't want it to be an option. I didn't want it to have to require a team of people to maintain it. Your traditional relational data approaches are incredibly cumbersome, complicated, and don't, in my view, scale globally."

That's as strong an endorsement as you can get for NoSQL in a high-scale cloud deployment. We've heard equally positive comments about the flexible, schema-agnostic data-handling characteristics and ease of development offered by products like MongoDB and Couchbase. These guys get mobile, social, clickstream, and sensor data, proponents argue, and they might note that adding JSON support to a conventional database is like putting lipstick on a pig.

If there's one complaint raised, it's that NoSQL products, well, don't speak SQL, a mature language that supports all sorts of transactional and analytical capabilities. Enter NewSQL, an emerging category populated by vendors like Clustrix, MemSQL, VoltDB, and others that promise the global scalability of NoSQL without giving up SQL.

To date, NewSQL options have been far less popular than the NoSQL options, in part because they are very new, but also because a relational approach and data flexibility aren't easily combined. What's more, NewSQL vendors face more competition from old SQL vendors and complacent customers who give familiar products the first crack at solving new problems. That's an expensive mistake, argue the NewSQL vendors.

This collection offers a closer look at 16 notable NoSQL and NewSQL database management systems that deserve a closer look. Excluded from this portfolio are graph databases, which serve a very specific network-analysis role and do not serve in the same broad transactional role as these NoSQL and NewSQL databases. Also excluded are hugely popular products including Redis and Memcached, which tend to serve as data-caching tiers rather than as durable data stores.

This collection is distinguished from our 16 Top Big Data Analytics Platforms analysis, in that these are not, generally speaking, analytical platforms. Running transactional applications is the name of the game here, although these products can also address operational analytical needs. We're also not calling this a "top" collection because the dust hasn't even begun to settle, particularly in the NewSQL category.

Read on to get a bead on new options for modern data-management needs.

Next slide