Scalable SQL and NoSQL Data Stores

In this paper, we examine a number of SQL and so-called "NoSQL" data stores designed to scale simple OLTP-style application loads over many servers. Originally motivated by Web 2.0 applications, these systems are designed to scale to thousands or millions of users doing updates as well as reads, in contrast to traditional DBMSs and data warehouses. We contrast the new systems on their data model, consistency mechanisms, storage mechanisms, durability guarantees, availability, query support, and other dimensions. These systems typically sacrifice some of these dimensions, e. g. database-wide transaction consistency, in order to achieve others, e. g. higher availability and scalability.