Below you will find some reading material, code samples, and some additional resources that support today’s topic and the upcoming lecture.
Review the Submission Instructions for guidance on completing and submitting this assignment.
1. Fill in the chart below with five differences between SQL and NoSQL databases:
| SQL | noSQL |
|---|---|
| tables | graphs, key-value pairs |
| predefined schema | dynamic schema |
| vertically scaled | horizontally scaled |
| professional support readily available | community-based support |
2. What kind of data is a good fit for an SQL database?
SQL is good for non-hierarchial data.
3. Give a real world example.
At my old civil engineering job, we used relational databases running Oracle to store metadata for points we captures during land surveys using gps and optical equipment.
4. What kind of data is a good fit a NoSQL database?
NoSQL is good for storing graph databases, key-value pairs, documents, column store databases, and XML databases.
5. Give a real world example.
Amazon offers NoSQL databases through AWS.
6. Which type of database is best for hierarchical data storage?
NoSQL is better for hierarchical data storage over SQL.
7. Which type of database is best for scalability?
Both are good for scalability under different contexts. SQL databases best for vertically scaling whilst NoSQL is better for horizontal scaling.
1. What does SQL stand for?
Structured Query Language.
2. What is a relational database?
A database where data that are related to each other using are stored using records and fields.
3. What type of structure does a relational database work with?
Tables.
4. What is a ‘schema’?
It’s a predefined data structure to groups tables and such.
5. What is a NoSQL database?
Non-tabular databases that can store data using a variety of documents.
6. How does it work?
It works by using a JSON database
7. What is inside of a Mongo database?
Documents, key-value pairs, wide-column databases, and graph databases
8. Which is more flexible - SQL or MongoDB? and why.
MongoDB is more flexible, since we won’t be limited to pre-defined schema
9. What is the disadvantage of a NoSQL database?
They may have to be manually cleaned of duplicates.