NewSQL

lightbulb

NewSQL

NewSQL is a modern approach to database management that combines the scalability and elasticity of NoSQL with the consistency and durability of traditional relational databases. It offers a hybrid solution that provides both high performance and data integrity, making it suitable for both online transaction processing (OLTP) and online analytical processing (OLAP) workloads.

What does NewSQL mean?

NewSQL is a class of database management systems (DBMSs) that aim to combine the scalability, performance, and high availability of NoSQL databases with the consistency and ACID (Atomicity, Consistency, Isolation, Durability) guarantees of traditional SQL databases.

NewSQL databases typically achieve this by using a shared-nothing architecture, in which each node in the cluster is responsible for a subset of the data. This architecture allows for horizontal scaling, as new nodes can be added to the cluster to handle increased load. NewSQL databases also often use a distributed consensus algorithm, such as Paxos or Raft, to ensure that updates to the database are applied consistently across all nodes.

Applications

NewSQL databases are ideal for applications that require both high performance and strong consistency. Some common applications include:

  • Online transaction Processing (OLTP) systems
  • E-commerce platforms
  • Mobile applications
  • Gaming
  • Financial services

History

The term “NewSQL” was first coined in 2011 by Gartner analyst Merv Adrian. At the time, there was a growing need for a new type of database that could handle the challenges of Big Data and Cloud Computing. NoSQL databases were popular at the time, but they did not offer the same level of consistency and ACID guarantees as traditional SQL databases.

Since then, a number of NewSQL databases have been developed, including:

  • CockroachDB
  • FoundationDB
  • Google Cloud Spanner
  • MariaDB X
  • MongoDB Atlas
  • NuoDB
  • TiDB

NewSQL databases are still a relatively new technology, but they are rapidly gaining popularity. As more and more applications require both high performance and strong consistency, NewSQL databases are likely to become even more important in the future.