Friday, February 14, 2020

When to use SQL and when to use NoSQL

In this post you will know what is SQL and NoSQL and the main differences between them and also covered when to use SQL and Which scenario recommended to use NoSQL,

SQL stands for Structured Query language, pronounced as "S-Q-L" or sometimes as "See-Quel". SQL is the standard language for dealing with Relational Databases. SQL can be used to insert, search, update and delete database records. SQL can do lots of other operations including optimizing and maintenance of databases. Relational databases like MySQL Database, Oracle, Ms SQL server, Sybase, etc uses SQL.

 NoSQL is not a relational database. The reality is that a relational database model may not be the best solution for all situations. The easiest way to think of NoSQL, is that of a database which does not adhering to the traditional relational database management system (RDMS) structure. Sometimes you will also see it revered to as 'not only SQL'.





Now we will see the key differences between SQL and NoSQL

                SQL
 NoSQL
1.                      SQL is Relational data base(RDBMS)
2.                      It is a query based language
3.                      These databases are table based databases.
4.                      SQL databases are vertically scalable.
5.                      SQL databases are suitable for complex query intensive work environments.
6.                      SQL follow ACID model such as:
·      Atomicity
·      Consistency
·      Isolation
·      Durability
Examples: oracle,mysql,sql server etc..

1.          These databases are called non relational databases or distributed data bases.
2.          This database is no declarative query language.
3.          This database can be document based, graphs, key-value paired data bases.
4.          NoSQL databases are horizontally scalable.
5.          It is not suitable for complex query.
6.          NoSQL follows BASE model such as
·       Basically available
·       Soft State
·       Eventually Consistent

Examples:  MangoDB, DaynoDB, Cassandra etc..


when to use SQL:


SQL Preferred when building customer reports
When the requirement is to store and get data from a database.
If communication is required from different related tables then should use SQL
If you want write complex queries using joins, views , stored procedures.

When to use NoSQL:
Need to handle large volumes of structured, semi-structured, and unstructured data
Follow modern development practices such as agile sprints, quick iterations, and frequent code pushes
Prefer object-oriented programming that is easy to use and flexible
Used when logging data from variety of sources.

No comments:

Post a Comment

High Paying Jobs after Learning Python

Everyone knows Python is one of the most demand Programming Language. It is a computer programming language to build web applications and sc...