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
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.
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