SQL VS NOSQL
SQL |
No SQL |
Data is in Structured Format |
Accept both |
Define Schema |
Dynamic Schema |
For Transactional Data |
Not for Trasactional Data |
Based ACID Property |
BASED on BASE propoerty and supports CAP |
Scaled Vertically |
Scaled Horizandally
|
Supports complex Queries |
Does not support the Complex Query |
Based on table based DB |
Based on Document/Graph/Key Value /Column based |
Its either Open Source/ Vendors specific |
Mostly Open Source
|
Comments
Post a Comment