From SQL to NoSQL to NewSQL

History of RDBMS

Every time new technology emerged it’s evolution ended up in realisation as relational system (RDBMS). In other words, the business before adopting the stuff always demanded atomicity, consistency, isolation, and durability (ACID).

data_storage_evolution

The reasons why NoSQL concept appeared

cloud_migrationThe main reasons are: mass data work migration from in-house realisations to a cloud, growing data sets, replacement of relational systems with NoSQL that pushes on them consistence requirements.

 

Requirements the business need (listed in NewSQL section) cannot be satisfied by existing systems (in other two sections):

newSQL_strength

Characteristics of NewSQL

NewSQL definition by 451 Group

“A DBMS that delivers the scalability and flexibility promised by NoSQL while retaining the support for SQL queries and/or ACID, or to improve performance for appropriate workloads.”

Translating to business language: flexible, reliable and allows rapid development.

Shared nothing architecture

  • No single point of failure
  • Each node is independent and self-sufficient
  • No shared memory or disk
  • Scale infinitely
  • Data partitioning

For business all this means low storage&processing costs and high reliability.

DBs that belongs to NewSQL

At the moment NewSQL World consists of the next competitors:

NewSQL_World

All players can be split into 3 major categories:

  • New approaches: VoltDB, Clustrix, NuoDB
  • New storage engines: TokuDB, ScaleDB
  • Transparent clustering: ScaleBase, dbShards

Conclusions

  • NewSQL is an established trend with a number of options
  • Hard to pick one because they’re not on a common scale – no silver bullet
  • Growing data volume requires ever more efficient ways to store and process it
Advertisements

About fdtki

Sr. BI Developer | An accomplished, quality-driven IT professional with over 16 years of experience in design, development and implementation of business requirements as a Microsoft SQL Server 6.5-2014 | Tabular/DAX | SSAS/MDX | Certified Tableau designer
This entry was posted in Big Data, Business Capability, Business Delivery, R&D, Uncategorized and tagged , , , , , , , , . Bookmark the permalink.

One Response to From SQL to NoSQL to NewSQL

  1. Pingback: Knowledge Immersion: From SQL to NoSQL to NewSQL : MSR Communications

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s