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

Popular posts from this blog