| SQL | NoSQL |
|---|---|
| Relational | Non-Reational |
| Table Based | Document Based |
| Predifined Schemas | Dynamic Schemas |
| Vertically Scalable | Horizontally Scalable |
| Used for defining and manipulating data | Used for collection of documents |
Structured Data
Retail where there is customers, products, orders, inventory.
Unstructured where the data will need lots of flexibility.
Social media where each user may have wildy different data and content
SQL
NoSQL
Structured Query Leanguage
It is basically a data base that has data that is related to other data within it. An example would be having orders, products that can be ordered and users that placed an order.
Each category is split into tables and each table has a number of fields (columns) and then each piece of data creates a new record that fills all fields.
its almost like categories for the data
a database that has no relations for the most part. You put all the information into a collection
It works like json objects
a document which is, much like a json object.
MongoDB it has less constraints that data needs to fit within. you can also horizontally scale and vertically scale easier.
It can be more difficult to keep consitent data. Some piece may have lots of inforamtion and some may not. Also if user data changes often it can be a longer process.