What are the differences between NoSQL database and SQL database?

Answer»

The differences between the NoSQL and SQL database are as below.

Parameter	NoSQL database	SQL database
History	It is DEVELOPED in late 2000s with a focus to allow rapid implementation of changes in applications and scalability	It is developed in 1970S with a focus to reduce the problem of data duplication
Data Storage Model	Tables with rows and dynamic COLUMNS are used	Tables with fixed rows and columns are used
Schemas	Schemas are flexible	Schemas are rigid
SCALING	Horizontal scaling is possible	Vertical scaling is possible
Joins usage	Joins are not required in NoSQL	Joins are typically required in SQL
Examples	MongoDB and CouchDB	MySQL, ORACLE, Microsoft SQL Server, and PostgreSQL

Discussion