Difference between SQL database and Mongo database (NoSQL)
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) |
