SQL Vs NoSQL - MongoDB Tutorial




SQL Vs NoSQL Database

MongoDb


SQL NoSQL
Primarily called RDBMS or Relational Databases. Primarily called as non-relational or distributed database.
Rows and columns are fixed with Table. Document: JSON documents,
Key-value: key-value pairs,
Wide-column: tables with rows and dynamic columns,
Graph: nodes and edges.
It is not suited for hierarchical data storage. It is best suited for hierarchical data storage.
It becomes Vertically Scalable. It becomes Horizontally Scalable.
Created on 1970s with a focus on reducing
data duplication.
Created on late 2000s with a focus on scaling and allowing for rapid application change driven by agile and DevOps practices.
Examples: Oracle, MySQL, Microsoft SQL Server,
and PostgreSQL.
Examples: Document: MongoDB and CouchDB, Key-value: Redis and DynamoDB, Wide-column: Cassandra and HBase, Graph: Neo4j and Amazon Neptune
In this Schemas are Rigid. In this Schemas are Flexible.
It supports the multi-record ACID
transactions.
It does not support multi-record ACID transactions.
Structured Query Language used. There is no declarative query language.
Specialized DB hardware like Oracle Exadata, etc. Commodity hardware.
Hootsuite, CircleCI, Gauges like top companies
using SQL database.
Airbnb, Uber, Kickstarter like top companies using NoSQL database.
The average salary for SQL developers becomes high. The average salary for NoSQL developers is lower than SQL developers.

Related Searches to SQL Vs NoSQL - MongoDB Tutorial