Open In App

Difference between Relational database and NoSQL

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Share
Report issue
Report

1. Relational Database : 
RDBMS stands for Relational Database Management Systems. It is most popular database. In it, data is store in the form of row that is in the form of tuple. It contain numbers of table and data can be easily accessed because data is store in the table. This Model was proposed by E.F. Codd. 

2. NoSQL : 
NoSQL Database stands for a non-SQL database. NoSQL database doesn’t use table to store the data like relational database. It is used for storing and fetching the data in database and generally used to store the large amount of data. It supports query language and provides better performance.

Difference between Relational database and NoSQL : 

Relational Database NoSQL
It is used to handle data coming in low velocity. It is used to handle data coming in high velocity.
It gives only read scalability. It gives both read and write scalability.
It manages structured data. It manages all type of data.
Data arrives from one or few locations. Data arrives from many locations.
It supports complex transactions. It supports simple transactions.
It has single point of failure. No single point of failure.
It handles data in less volume. It handles data in high volume.
Transactions written in one location. Transactions written in many locations.
support ACID properties compliance doesn’t support ACID properties
Its difficult to make changes in database once it is defined Enables easy and frequent changes to database
schema  is mandatory to store the data schema design is not required
Deployed in vertical fashion. Deployed in Horizontal fashion.

Last Updated : 25 Oct, 2022
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads