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. |