January 22, 2014

NewSQL: what’s this?

BY :     January 22, 2014

NewSQLAs mentioned in my previous publication about NoSQL databases it’s impossible to have Consistency, Availability and Partitioning simultaneously (it’s the “CAP theorem”).

On the other hand, classical Relational Databases are not scalable enough and cannot provide the same performance as the NoSQL solutions.

That’s why some relational databases providers are trying to find technical alternatives to close the gap between SQL and NoSQL capabilities.

The “NewSQL” is a movement promoting a new type of relational databases (or extensions for existing relational databases). It seeks to provide the same scalable performance of NoSQL systems but it’s still based on a relational paradigm and it keeps the good old SQL as the query language. Moreover it guarantees ACID transactions (Atomicity, Consistency, Isolation, and Durability).

The term “NewSQL” has been created by Matt Aslett from “the 451 group”. He writes:
“ ’NewSQL’ is our shorthand for the various new scalable/high performance SQL database vendors. We have previously referred to these products as ‘ScalableSQL’ to differentiate them from the incumbent relational database products. Since this implies horizontal scalability, which is not necessarily a feature of all the products, we adopted the term ‘NewSQL’ in the new report.
And to clarify, like NoSQL, NewSQL is not to be taken too literally: the new thing about the NewSQL vendors is the vendor, not the SQL.”

The NewSQL’s goals are to bring the benefits of the relational paradigm to distributed architectures or to provide so good performances that horizontal scalability is no longer a necessity.

The “NewSQL promise” in brief:

NewSQL-comparison

Is NewSQL a competitor for NoSQL ?

A priory no, technically NoSQL offers specific benefits (flexibility due to the “schema-less” approach, natural integration with REST and JSON, etc) but with the historical usage of SQL everywhere and with the inevitable resistance to change it could curb the NoSQL adoption because it allows to continue to use existing SQL code and SQL skills.…

Some NewSQL solutions :

Some “In-Memory” databases provided by big vendors

SQL, NoSQL or NewSQL : now you have the choice !

Sogeti Labs

About

SogetiLabs gathers distinguished technology leaders from around the Sogeti world. It is an initiative explaining not how IT works, but what IT means for business.

Related Posts

Your email address will not be published. Required fields are marked *

5 + 7 =


  1. Kees Dijk · January 24, 2014 Reply

    Hi Laurent,

    Great article, thanks, I had no idea there were already this many newSql solutions.

    There is a small error in the “NewSQL promise” table. Old SQL has a schema and noSql is schema-less. ( http://martinfowler.com/articles/schemaless/ )

    Thanks again. kind regards,
    Kees Dijk

  2. reza · November 17, 2017 Reply

    hi
    may you introduce one article to me related to SAP HANA database, please?
    thanks.

*Opinions expressed on this blog reflect the writer’s views and not the position of the Sogeti Group