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.

Related Articles

Human Resources Management System

A Human Resources Management System (HRMS) is a software application that supports many functions of a company's Human Resources department, including benefits administration, payroll,...

How To Defend Yourself Against Identity Theft

Almost every worldwide government agency responsible for identity theft issues will tell you the same thing: The first step to fighting identity theft is...

Infographic

An infographic is a visual representation of information or data. It combines the words information and graphic and includes a collection of imagery, charts,...

Phishing

What is phishing? Phishing is a type of cybercrime in which victims are contacted by email, telephone, or text message by an attacker posing as...

ScalaHosting

ScalaHosting is a leading managed hosting provider that offers secure, scalable, and affordable...

HRIS

Human resources information system (HRIS) solutions help businesses manage multiple facets of their...

Best Managed Service Providers...

In today's business world, managed services are more critical than ever. They can...