SQL Vs NoSQL - MongoDB Tutorial
SQL Vs NoSQL Database
| 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. |