SQL vs NoSQL vs NewSQL

What is SQL Relational Database?

  • ACID property to maintain the reliability of transactions
  • Normalization — A process of designing efficient databases
  • Vertical scalability

Why SQL was not enough?

  • Explosion of social media sites with large data needs.
  • Rise of cloud-based solutions.
  • Shift to dynamically-typed data with frequent schema changes.
  • Expansion of Open-source community.
  • Handle big data.

What is NoSQL?

  • Key-value databases store pairs of unique keys and associated values. Ex:- Redis
  • Document databases store data in document-like structures encoded in formats such as JSON and XML. Ex:- MongoDB
  • Wide-column databases store data in tables that contain large numbers of columns (in a flexible schema). Ex:- Cassandra
  • Graph databases store data in graph form to highlight the connections between different data elements. Ex:- Neo4j.
  • Lack of schema
  • The BASE Principle — The base stands for Basically Available Soft-state, Eventually consistent.
  • Horizontal scalability

Why SQL and NoSQL was not enough?

  • NoSQL databases have limited query capabilities as compared to RDBMS.
  • NoSQL databases don’t offer any RDBMS capabilities like consistency and ACID transactions.
  • Most of the NoSQL databases use key-value pairs to store the data. Hence it isn’t easy to maintain as the volume increases.
  • NoSQL databases are new to the markets and can be challenging for RDBMS programmers to switch to these technologies.
  • Most of the NoSQL databases are open source and are a restricted choice for enterprises.

What is NewSQL?

  • Main Memory storage of OLTP databases enables in-memory computations of databases.
  • Scaling out by splitting a database into disjoint subsets called either partitions or shards, leading to the execution of a query into multiple partitions and then combining them into a single result.
  • NewSQL systems preserve the ACID properties of databases.
  • Enhanced concurrency control system benefits traditional ones.
  • Presence of a secondary index allowing NewSQL to support faster query processing times.
  • High availability and Strong data durability only possible with the use of replication mechanisms.
  • Configure NewSQL systems to provide synchronous updates of data over the WAN.
  • Minimizes Downtime, provides fault tolerance with its crash recovery mechanism.

Difference Between SQL, NoSQL, and NewSQL

Which is the Best Solution: SQL or NoSQL or NewSQL?

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store