Fill in the chart below with five differences between SQL and NoSQL databases:
| SQL | NoSQL |
|---|---|
| Relational | Distributed |
| Tables | Documents |
| Predefined Schema | Dynamic Schema |
| Vertically Scalable | Horizontally Scalable |
What kind of data is a good fit for an SQL database?
Complex query intensive environments
Give a real world example.
MySQL Community Edition
What kind of data is a good fit a NoSQL database?
Hierarchical data storage. NoSQL are preferred for large data set.
Give a real world example.
MongoDB
Which type of database is best for hierarchical data storage?
NoSQL
Which type of database is best for scalability?
SQL DBs are vertically scalable and NoSQL DBs are horizontally scalable.
What does SQL stand for?
Structured Query Language
What is a relational database?
Supports SQL and works with certain assumptions
What type of structure does a relational database work with?
Tables
What is a ‘schema’?
The fields contained in each table, a record makes a new row and includes entries for each of these fields
What is a NoSQL database?
MongoDB
How does it work?
Stores a lot of data in an efficient manner
What is inside of a MongoDB database?
Collections that contain documents
Which is more flexible - SQL or MongoDB? and why.
MongoDB because documents are not required to follow a specific schema, each can contain different data
What is the disadvantage of a NoSQL database?
Duplicate data without strictly relational data