SQL vs NO SQL

Structure Query Language (SQL) is the conventional way of storing and accessing the data from the database. But as the Internet grows, data also had grown significantly which has resulted in giving birth to various storage problems.

Now we are going to provide you the difference between SQL and No-SQL 


SQL

NO SQL


It stores data in relational representation, i.e, data is stored in tables

Data is not stored in the form of tables

It has a fixed structure or schema

It does not have any fixed structure

It's architecture is centralized database i.e, it stores and process data centrally.

Centralized SQL database
Fig 1.a. Centralized SQL Database

In this data is stored in various distributed machines.
Distributed NoSQL Database
Fig 1.b. Distributed NoSQL Database


If the central DB server goes down, no users request can be processed

If any DB server goes down, user request can be processed from remaining servers
Response time gets slower as the concurrent users increases
Since user requests are distributed across many servers, response time is much faster than centralized server

To meet the growing load, you can upgrade the server (as shown in the fig 1.c) This is called vertical scalability. But this is limited by hardware constraints.

To meet growing load, more servers can be rapidly added (as shown in fig 1.d). This is called horizontal scalability. In this case scalability in infinite


Fig 1.c. Upgradation of Server in SQL

Fig 1.d. Upgradation of Server in NoSQL
So you can see from the figure that upgradation is easier in case of NoSQL.

Thanks for reading.

Comment your views!!!

Comments

Popular posts from this blog

CAP THEOREM NOSQL

TYPES OF NOSQL DATABASE