Difference between Relational and NoSQL Database

Relational vs NoSQL Database:

NoSQL Database Relational Database
A very simple query language. A powerful query language.
No fixed schema. A fixed schema.
Only eventually consistent. Follows acid properties, i.e, Atomicity, Consistency, Isolation, and Durability.
Support only simple transactions. Also supports complex transactions with joins.
Used to handle high-velocity incoming data. Used to handle low-velocity incoming data.
Data arrives from different locations. Data arrives only from one or a few locations.
Supports structured, unstructured and semi-structured data. Support only structured data.
No single point of failure. Single point of failure with failover.
Used to handle big data or data in a very high volume . Used to handle moderate volume of data.
Decentralized structure. Centralized structure.
Facilitates both read and write scalability. Facilitates read scalability only.
Deployed in horizontal fashion. Deployed in vertical fashion.
Comparatively Faster. Comparatively Slower.
Simplicity of design. Comparatively complex design.


Content Protection by DMCA.com