Data Driver

Blog archive

Survey Shows SQL Dominates NoSQL in the Cloud

Recent research sponsored by Database as a Service (DBaaS) company Tesora shows SQL databases are holding their own in cloud usage.

The start-up, which is developing a DBaaS product for the open source Trove DBaaS project introduced in the April "Icehouse" release of the open source OpenStack cloud platform, today released a report titled ""Database Usage in the Public and Private Cloud: Choices and Preferences." More than 500 developers in North American open source developer communities responded, providing insights into database usage in public and private clouds.

Of those respondents, 79 percent were using a SQL database, while 16 percent were using NoSQL.

Which database(s) does your company currently use?
[Click on image for larger view.] Which Databases Does Your Company Currently Use?(source: Tesora)

"Use of relational databases remains well ahead of NoSQL, whether as a traditional database system or as a service, and whether it is provided in a public or private cloud," Tesora said in a news release announcing the new research.

The research report itself provided more details. "The leaders were the 'Big Three' relational databases: Microsoft SQL Server, MySQL and Oracle," it stated. "MongoDB was the most popular NoSQL DB with slightly more than 10 percent, behind all relational database choices."

So much for SQL becoming obsolete in the new era of Big Data, mobile and cloud computing.

The new findings echo recent similar research, such as a recent "data connectivity" study, and reports of SQL usage in Big Data scenarios.

The whole SQL-vs.-NoSQL thing should have been long over by now, but the new research must be heartening to SQL Server developers whose livelihoods seemed to be threatened by upstart database movements not that long ago.

SQL Server was reported in use by 57 percent of respondents, followed by MySQL (40 percent), Oracle (38 percent), DB2 (14 percent) and PostgresSQL (13 percent). "The results suggest that relational databases still dominate despite rapid adoption of NoSQL solutions by high-profile enterprises like Twitter and Facebook," the survey report said.

Of course, things might change.

"Going forward, this gap can be expected to close since NoSQL databases have only been on the market for a few years or less, as opposed to decades for some of the incumbents," the report stated. "The results seem to indicate the need for coexistence rather than displacement (at least in large, established organizations), with relational databases running in tandem with NoSQL for specialized workloads."

Microsoft didn't fare so well in some other areas. For example, Azure placed third in public cloud usage, at just 8 percent of respondents, behind Amazon AWS (24 percent) and Google Compute Engine (16 percent).

A report caveat noted: "This is a survey of open source software developers, and surveys of other groups will have different results."

Tesora used SurveyMonkey to conduct the survey (available for download after registration), while The Linux Foundation, MongoDB and Percona helped distribute it.

Posted by David Ramel on 06/18/2014 at 12:40 PM


comments powered by Disqus

Featured

  • How to Do Machine Learning Evolutionary Optimization Using C#

    Resident data scientist Dr. James McCaffrey of Microsoft Research turns his attention to evolutionary optimization, using a full code download, screenshots and graphics to explain this machine learning technique used to train many types of models by modeling the biological processes of natural selection, evolution, and mutation.

  • Old Stone Wall Graphic

    Visual Studio Code Boosts Java Dependency Viewer

    Easier management of project code dependencies and improvements to extensions for popular Java frameworks and runtimes highlight the February update to Java in Visual Studio Code functionality.

  • Blule Squares

    Visual Studio 2019 for Mac 8.5 Preview Adds ASP.NET Core Authentication

    Microsoft, after shipping Visual Studio 2019 for Mac v8.4 with support for ASP.NET Core Blazor Server applications last month, is now previewing the v8.5 series, adding new authentication templates for ASP.NET Core along with other improvements.

  • Q&A with Brice Wilson: What's New in Angular 9

    We caught up with expert web developer/trainer Brice Wilson to get his take on Angular, which always appears at or near the top of periodic rankings of the most popular JavaScript-based web development frameworks.

  • Entity Framework Core Migrations

    Eric Vogel uses code samples and screenshots to demonstrate how to use Entity Framework Core migrations in a .NET Core application through the command line and in code.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events