Week 12

SQL VS NoSQL

SQL	NoSQL
Structured data (with tables and rows)	Unstructured data
Better for small datasets	Better for large datasets
Frequent updates	High write loads
Strong dependency on multi-row transactions	High availability in unstable environment
Modify large volume of records	Data is location based

NoSQL is better for dealing with collections of JSON documents (<key>:<value>) pairs

Note

In this week, we also learned how to use restDB.