Big Data

NoSQL keeps rising, but relational databases still dominate big data

Even though MongoDB and Cassandra keep winning converts, enterprises are keeping their RDBMSes around, and will do so for quite some time.

Image: iStockphoto/Sergey Nivens

NoSQL promised to upend the database market as big data forced a sea change in how we think about and manage data. Several years into the big data revolution, that promise remains unfulfilled.

Oh, sure, NoSQL is having an impact on the $46 billion database market—still just 3% of the market, but growing at a rapid pace even as more traditional relational databases inch up by 5.4%, according to IDC. But, by that same measure, as well as the updated DB-Engines database popularity rankings, relational databases still dominate big data.

SEE: Research: Big data and IOT - Benefits, drawbacks, usage trends (Tech Pro Research)

On current trends, then, we can expect NoSQL and relational databases to share the big data winner's podium for many years to come.

NoSQL rising

NoSQL is a response to the dramatic growth of unstructured data within the enterprise, and promises to be the biggest challenge to the established relational database management system (RDBMS) hegemony. Though Oracle currently controls 40% of the paid database market, analyst Curt Monash warns that NoSQL is one of the biggest threats to its crown:

"[T]here are basically three things that can seriously threaten Oracle's market position, [the first of which is] growth in apps of the sort for which Oracle's RDBMS is not well-suited. Much of 'Big Data' fits that description."

Even so, there's a long way for NoSQL to go, as IDC data highlights:

Image: IDC

Despite the uphill battle, DB-Engines' broad view into database popularity shows a continued narrowing of the gap by the top NoSQL databases, including MongoDB, Datastax-sponsored Apache Cassandra, and Redis:

Image: DB-Engines

This growth is happening against the backdrop of a slowdown in the RDBMS market. Oracle, which sits atop the database popularity and revenue rankings, keeps deriving less and less of its revenue from new license sales, as Redmonk analyst Stephen O'Grady captures:

Image: Redmonk

However, the other side of the market leaders' ledger shows huge growth for MySQL, the open source RDBMS Oracle acquired with the purchase of Sun Microsystems (open source database growth has clocked 31%, according to IDC). While Oracle makes far less money from MySQL subscription sales than it does its eponymous database, MySQL is arguably doing more to keep it relevant to modern workloads (and the developers who love them).

RDBMS keeping pace

For all of NoSQL's rise, however, RDBMS isn't exactly falling. There are several reasons why this is the case.

The first is that, as much as enterprises may want to embrace NoSQL to tame mounting quantities of unstructured data, most of their workloads remain transactional in nature, which is the sweet spot for RDBMS.

Another reason is that analytics tooling for NoSQL is still in its infancy. As Gartner analyst Lynn Robison points out, NoSQL-friendly analytics tools are not user-friendly analytics tools, and "It will take years for analytical tools to mature and become accessible to people who are not in data science."

A third reason is the hardest to quantify and to overcome: Culture. Enterprises have spent the last 30-plus years living with relational databases. It's hard to change that overnight.

Finally, a fourth reason: It turns out an RDBMS is sometimes the best solution for a particular problem. Just ask Facebook's data chief, Ken Rudin:

"If we look at the granularity of the data, we keep the lowest level of grain in our Hadoop system. So whenever you want to look at something at the lowest level of detail, Hadoop is optimized for that. However, if we want to look at transformed data and aggregated data, relational is easier for doing that."

So, real-time monitoring is done in Hadoop and associated NoSQL databases, but for longer-term trending analytics, that's RDBMS.

SEE: Big data privacy must be fixed before the revolution can begin (ZDNet)

Two 'complete game changers'

Professor Michael Franklin, one of the industry's foremost database experts, has hailed NoSQL as a "complete game-changer," largely because of the flexibility of its schema. But, that very flexibility also leaves the door wide open for a relational database, which can perform fast, powerful queries against data that has been neatly packaged into rows and columns.

In other words, RDBMS and NoSQL are both "complete game changers," and together they can support winning big data strategies.

Also see

    About Matt Asay

    Matt Asay is a veteran technology columnist who has written for CNET, ReadWrite, and other tech media. Asay has also held a variety of executive roles with leading mobile and big data software companies.

    Editor's Picks

    Free Newsletters, In your Inbox