'SQL vs NOSQL : Explanation for few points
After reading more than 100 documents on SQL vs NOSQL, I still have two questions.
1). How latency of NoSQL DB is better than SQL DB?
2). How NoSQL DB's are auto scalable?
3). How NoSQL DB stores large data than SQL DB?
On every website , it says, NoSQL are having low latency, can handle large data and are auto-scalable. But no one explains how?
Looking for explained answers.
Solution 1:[1]
1) How latency of NoSQL DB is better than SQL DB?
In SQL databases, consistency is prioritized. As consistency is prioritized, the database manage system has to do lots of work to maintain the consistent state, which will definitely compromise the performance. In contrast, NoSQL databases have less constraints than SQL by reducing the overhead of consistency.
2) How NoSQL DB's are auto scalable?
SQL databases are vertically scalable, You're able to increase the load on a single server by adding more CPU, RAM, or SSD capacity. NoSQL databases are horizontally scalable. You’re able to handle higher traffic by adding more servers to your NoSQL database.
3) How NoSQL DB stores large data than SQL DB?
NoSQL systems are distributed, non-relational databases designed for large-scale data storage.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Mustafa Bazghandi |