Loading, please wait...

Difference between SQL database and Mongo database

MongoDB is the NoSQL database that is used to store the data in form of key-value pairs. It is an Open Source Document Database that provide high performance and scalability along with data modelling and data management of huge sets of data in an enterprise application.

MongoDB also provides the feature of Auto-Scaling. Since, MongoDB is a cross platform database and can be installed across different platforms like Windows, Linux etc.

 

 SQL may be a standard query language for accessing and manipulating databases. It was at first developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially known as SEQUEL (Structured English query Language), was designed to control and retrieve information keep in IBM's original quasi-relational management system.) It is the Relational database which supports SQL query language.

 

 

Mongo database vs. SQL database

 

SQL Database

NoSQL Database (Mongo DB)

 It is the Relational database

It is the Non-relational database

It Supports SQL query language

It Supports JSON query language

It is Table based

It is the Collection based and key-value pair

It is Row based

It is Document based

It is Column based

It is Field based

It Support foreign key

 No support for foreign key

Support for triggers

No Support for triggers

It Contains schema which is predefined

It Contains dynamic schema

Not fit for hierarchical data storage

Best fit for hierarchical data storage

It is Vertically scalable - increasing RAM

It is Horizontally scalable - add more servers

It emphasizes on ACID properties (Atomicity, Consistency, Isolation and Durability)

It emphasizes on CAP theorem (Consistency, Availability and Partition tolerance)