NewSQL

NewSQL is a class of relational database management systems that integrates and builds on the concepts and principles of structured query language (SQL). SQL is a standardized query language for requesting information from a database and is relational. NoSQL is a database that features fewer consistency restrictions than conventional relational databases, making it non-relational. NewSQL was created in 2011 for online transaction processing (OLTP) workloads while maintaining atomicity, consistency, isolation, and durability (ACID). It provides the scalability and performance of NoSQL with the reliability of SQL.

NewSQL databases support applications that have a large number of transactions, are repetitive in their processes, and use a small subset of data retrieving processes. They are intended for companies that handle high-profile data and need more scalability and consistency than NoSQL can provide.

NewSQL advantages

  • Application complexity is minimized and consistency is stronger
  • Familiarity with SQL
  • Richer analytics leveraging SQL and extensions
  • Many systems offer a cluster of shared-nothing nodes, allowing each node to manage a subset of data

NewSQL disadvantages

  • NewSQL systems are not as general purpose as traditional SQL systems
  • Offers only partial access to rich tooling of traditional SQL systems

NoSQL would be a better choice for those who need availability or have special data model needs. NewSQL would be a better choice for those who like the speed of NoSQL, but also need stronger consistency and are familiar with the SQL query language. Popular NewSQL databases include VoltDB, Apache Trafodion, Altibuse, ClusterixDB, CockroachDB, MemSQL, NuoDB, and TIBCO ActiveSpaces.

Webopedia Staff
Webopedia Staff
Since 1995, more than 100 tech experts and researchers have kept Webopedia’s definitions, articles, and study guides up to date. For more information on current editorial staff, please visit our About page.

Top Articles

List of Windows Operating System Versions & History [In Order]

The Windows operating system (Windows OS) refers to a family of operating systems developed by Microsoft Corporation. We look at the history of Windows...

How to Create a Website Shortcut on Your Desktop

Website Shortcut on Your Desktop reviewed by Web Webster   This Webopedia guide will show you how to create a website shortcut on your desktop using...

What are the Five Generations of Computers? (1st to 5th)

Reviewed by Web Webster Each generation of computer has brought significant advances in speed and power to computing tasks. Learn about each of the...

Hotmail [Outlook] Email Accounts

Launched in 1996, Hotmail was one of the first public webmail services that could be accessed from any web browser. At its peak in...

HighLevel CRM

HighLevel is a sales and marketing customer relationship management (CRM) solution designed by...

Unified Endpoint Management (UEM)

As enterprise networks become increasingly distributed with growing numbers of remote workers, unified...

Decision Intelligence

Decision intelligence combines business intelligence (BI) and artificial intelligence (AI) models to improve...