Does NoSQL Spell the End of Relational Databases?

The surge of interest in NoSQL databases — and the slew of big-name production NoSQL implementations — has led some people to wonder whether relational databases are on their way out. Definitely not ? that?s the short answer. Relational databases are here to stay, and will continue to do what they do best: manage generic data, with relative simplicity, speed, high-performance, flexibility and scalability for users.

Of course, relational databases such as Oracle, SQL Server, and MySQL, achieve their simplicity and other benefits by being very complex internally.

[login]The Achilles heel of these databases is their inability to scale quickly in fast-growing environments with massive workloads such as web services.

Generally, relational databases scale well but only when the scaling is done on a single-server node. When the capacity of a node is reached, the scaling need to be distributed across multiple server nodes -a situation that pits the complexity of relational databases with their scalability.

In a scenario where hundreds of hundreds or thousands of nodes need to scale quickly, the complexities can be overwhelming, and the characteristics that make RDBMS so appealing drastically reduce their viability as platforms for large distributed systems.

For an increasing number of companies, the solution to scalability involves NoSQL databases — non-relational, distributed databases that typically scale horizontally, and provide superior data replication to SQL databases.

NoSQL has been attracting a lot of attention in recent years, primarily due to big-name production implementations. Two of the best known are Amazon’s Dynamo and Google’s BigTable.

NoSQL is very much a user-led phenomenon highlighted by the likes of Google, Amazon, Facebook, LinkedIn and Twitter, which created their own distributed data management technologies, says Mathew Aslett, an analyst at the 451 Group.

Aslett says Google and the other companies above chose NoSQL to deliver the performance and scalability benefits that traditional database products cannot match.

The database space is becoming more specialized with the emergence of alternative, non-relational databases, says Nosh Petigara, director of product strategy at10gen, creator of MongoDB, an open-source NoSQL database.

“Many of these database tools were created with the intention of scaling web applications,” says Petigara. “In order to achieve this horizontal scalability, most non-relational databases don’t support ‘join’-like operations and relax ACID requirements. This has led to new data modeling patterns emerging (such as MongoDB’s document-oriented model) to allow for data structures and operations to be modeled without joins and complex transactions.”

While the shift to these models has been primarily driven by a need for scalability, NoSQL databases are proving to be a good match for a variety of data in web and enterprise applications, Petigara notes.

“Consequently, developers are now turning to databases such as MongoDB, not only for scalability, but also for ease-of-development,” says Petigara.

There will always be a place for relational databases, but non-relational solutions are proving to be fast, flexible, and scalable for many tasks, he adds.

Petigara says many customers begin using MongoDB for logging or real-time analytics (typically semi-structured or unstructured data completely unsuited to a relational model), but over time start to migrate much of their content to MongoDB.

In the web world, textual or binary content, product catalogs, user profiles or actions, are all good fits for products such as MongoDB.

To ease the pain of developers switching from the relational to the non-relational database world, Petigara says 10gen has tried to maintain much of the rich functionality of a relational database, (such as dynamic queries and secondary indexes) — “so that it feels very natural for those coming from a relational background.”

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may

man on floor with data

DevX Quick Guide to Data Ingestion

One of the biggest trends of the 21st century is the massive surge in internet usage. With major innovations such as smart technology, social media, and online shopping sites, the internet has become an essential part of everyday life for a large portion of the population. Due to this internet

payment via phone

7 Ways Technology Has Changed Traditional Payments

In today’s digital world, technology has changed how we make payments. From contactless cards to mobile wallets, it’s now easier to pay for goods and services without carrying cash or using a checkbook. This article will look at seven of the most significant ways technology has transformed traditional payment methods.