SQL databases v. NoSQL databases

  title={SQL databases v. NoSQL databases},
  author={Michael Stonebraker},
  journal={Commun. ACM},
The <i>Communications</i> Web site, http://cacm.acm.org, features more than a dozen bloggers in the BLOG@CACM community. In each issue of <i>Communications</i>, we'll publish excerpts from selected posts.<br /><br /><b>twitter</b><br />Follow us on Twitter at http://twitter.com/blogCACM<br /><br />Michael Stonebraker considers several performance arguments in favor of NoSQL databases---and finds them insufficient. 

SQL, NewSQL, and NOSQL Databases: A Comparative Survey

This work aims at providing an overview of the different NoSQL management systems, classifying them into four main categories: key-value stores, column- oriented, document-oriented, and graph oriented, comparing each of the categories using multiple criteria including the CAP theorem and BASE properties.

A Survey on NoSQL Databases

The goal of this document is to understand the current needs that have led to the evolution of NoSQL data stores, why relational database systems were not able to meet these requirements and a brief discussion of some of the successful No SQL data stores.

Performance Evaluation for CRUD Operations in Asynchronously Replicated Document Oriented Database

Asynchronous replication is examined, one of the key features for a scalable and flexible system for noSQL databases, and three of the most popular Document-Oriented Databases, Mongo DB, CouchDB, and Couchbase, are examined.

New Trends in Databases to NonSQL Databases

This chapter is to introduce the NonSQL databases, which have been constituted as an alternative mechanism to the relational model and its use is widely extended.

Which NoSQL Database? A Performance Overview

Five most popular NoSQL databases are evaluated in terms of query performance, based on reads and updates, taking into consideration the typical workloads, as represented by the Yahoo! Cloud Serving Benchmark.

Not Only SQL as a Alternative to Relational Database Systems

The goal of the paper is to provide the knowledge necessary to identify the differences between the systems and provide guidance through the available NoSQL stores to choose the best choice to the application needs.

Comparing NoSQL MongoDB to an SQL DB

This paper compares one of the NoSQL solutions, MongoDB, to the standard SQL relational database, SQL Server, and results show that MongoDB performs equally as well or better than the relationaldatabase, except when aggregate functions are utilized.

Bridging the gap between SQL and NoSQL

There was a need to expose the various arguments in favor of and against these properties as well as the attempts that have been and are being made to bring these two technologies closer, and why they are not satisfying enough.

NoSQL Databases: Yearning for Disambiguation

This paper presents a survey of NoSQL databases and their classification by data model type, and presents the major areas of ambiguity and confusion around NoSQL database concepts, and attempts to disambiguate them.

Comparison between relational and NOSQL databases

This paper is a qualitative research, based on detailed and intensive analysis of the two database types, through use and comparison of some published materials during last few years, to try and compare the pros and cons of each database' features and characteristics.



The End of an Architectural Era (It's Time for a Complete Rewrite)

The current RDBMS code lines, while attempting to be a "one size fits all" solution, in fact, excel at nothing and should be retired in favor of a collection of "from scratch" specialized engines.

OLTP through the looking glass, and what we found there

Overall, overheads and optimizations that explain a total difference of about a factor of 20x in raw performance are identified and it is shown that there is no single "high pole in the tent" in modern (memory resident) database systems, but that substantial time is spent in logging, latching, locking, B-tree, and buffer management operations.