Posts

Showing posts from January, 2022

Why do we need NoSQL over SQL and how do we choose the best database for the project?

Image
In this article we will learn about databases RDBMS and NoSQL. What is a Database? Database is Structured, provides Random access that will help us to search data quickly based on index, having low latency and provides ACID properties. source: Google images ACID properties: A tomicity : The data will be transfer either full or none will be transferred.  Example: When you transfer money online using netbanking , either full amount should be transferred or none should be transferred. C onsistency : Data should be consistent. I solation : If multiple people are working in same bank / doing transfers at the same time, the there should be a sequencing/locking mechanism D urability : Whenever there is a database failure, the system should be up and running to save the data. Why do the companies want NoSQL over SQL? NoSQL databases offer many benefits over relational databases.  NoSQL databases have flexible data models, scale horizontally, have incredibly fast queries, and are ...

SQL and NoSQL Comparison

Image