SOGETI UK BLOG

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 :NewSQL-db-logos

Some “In-Memory” databases provided by big vendors

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

To read the original post and add comments, please visit the SogetiLabs blog: Our top 10 2014: NewSQL – what’s this?

Related Posts:

  1. NewSQL: what’s this?
  2. Top 10 post: “NoSQL: what’s in it for me?”
  3. NoSQL : What’s in it for me?
  4. It’s the platform, stupid

 

Laurent Guerin AUTHOR:
Specialized in Java and Web technologies with over 20 years of experience in the areas of databases, object development, code generation and project management.

Posted in: Business Intelligence, Opinion      
Comments: 0
Tags: , , , , ,

 

ComeInWereOpenHave you noticed that “OPEN” is a word more and more present in the IT ecosystem? Open source, open innovation, open data, open education resources, open hardware and so on… What does it imply for you?

Open Source

1-OpenSource

“Open Source” is probably the first thing that comes to mind when we talk about “openness” in IT.

But don’t be confused: “open” doesn’t mean “free.” A program is “free software” if the program’s users have the four essential freedoms (as defined by the Free Software Foundation):

– The freedom to run the program, for any purpose (freedom 0).
– The freedom to study how the program works and change it so it does your computing as you wish (freedom 1). Access to the source code is a precondition for this.
– The freedom to redistribute copies so you can help your neighbor (freedom 2).
– The freedom to distribute copies of your modified versions to others (freedom 3). By doing this you can give the whole community a chance to benefit from your changes. Access to the source code is a precondition for this.

But if you want to be able to study how the program works it’s necessary to see its source, then “free” implies “open”. And very often, an “open source software” is associated with an “open source license” that guarantees that it’s also “free”. The “real” open source licenses are listed on the “Open Source Initiative” web site (http://opensource.org/ ).

Anyway Open Source software is now everywhere in IT, and in most case it has become a kind of “reference”.

Open Innovation

2-OpenInnovation

Open Innovation is a new paradigm by which organizations use both internal and external knowledge to innovate. It has been promoted by Henry Chesbrough in his book Open Innovation: The New Imperative for Creating And Profiting from Technology.

Open Innovation is all about “co-creation” with external organizations in order to be more efficient and to accelerate the development of new technologies. It’s often opposed to “Closed Innovation” the classical way of thinking.

Open Data

3-OpenData

“Open data is data that can be freely used, shared and built-on by anyone, anywhere, for any purpose”. This is a definition found on the “Open Knowledge Foundation” blog.

According to this principle, data is now more and more available and inspiring a lot of new software. By consequence it leverages innovation.

Open Educational Resources (“OER”)

4-OpenEducationalResources

“OER” are education materials (documents and media) that can be freely used, adapted and customized.

With these kind of materials it’s actually possible to educate everyone. That’s why UNESCO is very active in promoting OER. (http://www.unesco.org/new/en/unesco/themes/icts/open-educational-resources/ )

Open Hardware

5-OpenHardware

Until recently most of us considered that the “openness” is by nature limited to immaterial things (software, data, resources, etc). But what can you do with open source software if you don’t have an affordable hardware to use it? Then the “Open Design” movement promotes the development of physical artifacts of technology based on the “open source” principle. Hardware design (mechanical drawings, schematics, etc), in addition to the software that drives the hardware, are all released with the “Free and Open Source Software (FOSS)” approach.

Moreover, 3D printers come with new exiting capabilities, for example the concept of “self-replicating machine” (a construct that can autonomously reproduce itself).

Examples:

– The famous Raspberry PI : http://www.raspberrypi.org/
– RepRap (3D printer – “Self-replicating machine”) : http://reprap.org/wiki/RepRap
– Arduino : http://www.arduino.cc/

Finally, “open your mind”

Don’t forget that in IT “everything is going fast,” but “open things go faster.” Then do not hesitate to share your ideas, your software, your data and your resources.

And enjoy the “Openness of IT”…

Links


 [MCD1]Confused by the numbering here ?

Laurent Guerin AUTHOR:
Specialized in Java and Web technologies with over 20 years of experience in the areas of databases, object development, code generation and project management.

Posted in: 3D printing, Open Data, Open Innovation, Open Sourced      
Comments: 0
Tags: , , , , , , , , , , , ,