Class 11
Back to home page
nosql vs sql
Q. Fill in the chart below with five differences between SQL and NoSQL databases:
| SQL |
NoSQL |
| structured data |
unstructured data |
| specific tables of data |
massive amounts of data |
| has a schema |
no schema |
| not flexible, but precise |
flexible, but duplication can occure |
Q. What kind of data is a good fit for an SQL database?
- Any sort of structured data.
Q. Give a real world example.
- Big social media platforms use sql databeses to store every users profile to be easily found.
Q. What kind of data is a good fit a NoSQL database?
- Mass amounts of data or unstructured data.
Q. Give a real world example.
- Big social media platforms use nosql databases to store terabites of user data everyday to see whats popular and filter targeted content.
Q. Which type of database is best for hierarchical data storage?
Q. Which type of database is best for scalability?
nosql vs sql video
Q. What does SQL stand for?
- Structured Query Language.
Q. What is a relational database?
- A database that works with assumptions and supports the SQL structure.
Q. What type of structure does a relational database work with?
Q. What is a ‘schema’?
- A list of logical structures inside the table.
Q. What is a NoSQL database?
- A database made to store tons of data.
Q. How does it work?
- Similar to a table in SQL, this database is structured with collections which have sub trees of documents. There can be however many collections inside the database. Similar to a json file.
Q. What is inside of a MongoDB database?
- No schema is needed, so you can structure the database in a variaty of ways.
Q. Which is more flexible - SQL or MongoDB? and why.
- MongoDB is very flexible because you can add new data stored in the saem collection.
Q. What is the disadvantage of a NoSQL database?
- You can run into duplicated data from not having a relationship set up, for example the same data would have to be manuelly placed in if not in the same collection.
Bookmark
Things I want to learn more about
Are there any other ways to structure a SQL database other than the table method?