What is NewSQL ?

What is NewSQL :

NewSQL is a category of SQL database products that address the performance and scalability issues posed by traditional online transaction processing (OLTP) relational database management systems (RDBMS).

Such systems aim to achieve the scalability of NoSQL systems while still providing the ACID attributes ensured by traditional relational databases. NewSQL databases are primarily intended for companies that handle high profile data and require scalability, but also need more consistency than NoSQL databases can provide. Although various NewSQL databases differ in their internal architectures, they all utilize the relational data model and run on SQL.

The label NewSQL is credited to an analyst firm called The 451 Group.

Introduction :

Relational databases built around the SQL programming language have long been the top — and, in many cases, only — choice of database technologies for organizations. Now, with the emergence of various NoSQL software platforms, IT managers and business executives involved in technology decisions have more options on database deployments. NoSQL databases support dynamic schema design, offering the potential for increased flexibility, scalability and customization compared to relational software. That makes them a good fit for Web applications, content management systems and other uses involving large amounts of non-uniform data requiring frequent updates and varying field formats. In particular, NoSQL technologies are designed with “big data” needs in mind.

But for prospective users, the array of NoSQL database choices may seem confusing or even overwhelming. NoSQL databases are grouped into four primary product categories with different architectural characteristics: document databases, graph databases, key-value databases and wide column stores. Many NoSQL platforms are also tailored for specific purposes, and they may or may not work well with SQL technologies, which could be a necessity in some organizations. In addition, most NoSQL systems aren’t suitable replacements for relational databases in transaction processing applications, because they lack full ACID compliance for guaranteeing transactional integrity and data consistency.

As a result, IT and business professionals making database buying decisions must carefully evaluate whether the available NoSQL options fit their business needs. In this guide, you can learn more about what NoSQL software can do and how it differs from relational databases. Trend stories and user case studies document how NoSQL databases can be used to support big data, cloud computing and business analytics applications. And experienced users from companies that have already deployed NoSQL tools offer advice on how to make the technology selection and implementation process smoother.

What NoSQL databases bring to the table :
==============================

Depending on the business problem an organization is trying to solve, IT decision makers may need to compare the benefits of NoSQL software and relational databases. The term “NoSQL” doesn’t necessarily mean “no SQL at all” — it also is commonly defined as “not only SQL” because many NoSQL databases do support some elements of SQL. But they don’t rely on SQL’s fixed-schema design principles, giving NoSQL users more flexibility on structuring databases. In this section, learn more about NoSQL trends and developments, such as how NoSQL technologies work in cloud environments and how they compare with and relate to SQL-based relational databases.

Examples of NewSQL :
================

VoltDB
NuoDB
memsql