Over a million developers have joined DZone.

Report: Vast Majority of Cloud Databases Use SQL

DZone's Guide to

Report: Vast Majority of Cloud Databases Use SQL

· Java Zone
Free Resource

Learn how to troubleshoot and diagnose some of the most common performance issues in Java today. Brought to you in partnership with AppDynamics.

Originally Written by Tony Barbagallo

If a business uses a cloud database—whether delivered as a service or managed traditionally through a public or private cloud—chances are it is going to be an SQL one.

According to a recent survey of 500 developers, 79 percent were using a SQL database—either MySQL or NewSQL—while only 16 percent said they were using NoSQL. At one point in time, industry pundits speculated as to whether NoSQL would threaten SQL’s dominance of the database market. Based on the previous results, this is no longer thought to be the case.

So why hasn’t NoSQL gained much traction? Perhaps because of the rise of NewSQL, the scale-out relational cloud database that is proving its merits in e-commerce applications.

Like traditional RDBMS’s such as MySQL, NewSQL ensures that all transactions that occur in the cloud database are ACID-compliant, as they guarantee atomicity, consistency, isolation and durability (ACID) during each transaction. NoSQL cannot ensure ACID compliance, and as such is a non-starter for e-commerce applications.

Correspondingly, because of the evolution of technology and the rise of Big Data, MySQL has reached its limits. It cannot scale horizontally or process large amounts of data concurrently. NewSQL, on the other hand, scales horizontally and is able to accommodate large amounts of transactions. It also ensures an optimal e-commerce experience for customers.

Therefore, NewSQL is the answer for e-commerce retailers that want to ensure that their cloud databases can accommodate traffic spikes, whether occurring predictably or not. A seller of school supplies can assume that business will pick up in August every year. However, a small retailer that makes hand-knit ties, for example, might be surprised to have a product “go viral,” and be suddenly inundated with Internet traffic.

As the need for stronger, faster and more versatile cloud databases continues to proliferate, it’s likely even more companies will turn toward NewSQL to enhance their e-commerce operations.

Understand the needs and benefits around implementing the right monitoring solution for a growing containerized market. Brought to you in partnership with AppDynamics.


Published at DZone with permission of Lisa Schultz, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}