Companion or Substitute? A Comparison of SQL and NoSQL Databases
SQL v/s NoSQL
RDBMS \ SQL NoSQL
Best for low-velocity data Best Handle high-velocity data
Data arrives from one to a few locations Data moves from & to many locations
Support Complex queries and business logic using JOIN Support simple queries do not support JOIN
Single Point of failure No Dependency on single point failure
Handle data in low to moderate volume Handle data in high volume
Centralized deployment Decentralized deployment
Transactions can write only at one location The transaction can be written from multiple locations
Give Read Scalability Give Read Write Scalability
Support Vertical Scaling, add resources to the server when need more power Support Horizontal Scaling, add node when need more power
Support programming languages like TSQL, PSQL Support programming language like CQL, GQL
Stores data in tables Different data storing formats like document, graph, etc.
Each record has fixed properties Flexible properties
Fix Schema Dynamic \ Flexible Schema
For any change in properties, Schema needs to be altered New Property can be added any time
Support In-Memory Comes up with integrated caching
OLTP & OLAP are 2 types of RDBMS 4 Types of NoSQL Databases
Works on ACID Properties Follows CAP(consistency, availability, partition tolerance)
·Atomicity
·Consistency
·Isolation
·Durability
Watch video Companion or Substitute? A Comparison of SQL and NoSQL Databases online without registration, duration hours minute second in high quality. This video was added by user Decode ITES 29 November 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 199 once and liked it 2 people.