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.
1 of 17
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.
Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio
How Enterprises Are Attacking the IT Security EnterpriseTo learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
IT Strategies to Conquer the CloudChances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.