301 Reading Eleven
nosql vs sql
| SQL | NoSQL |
|---|---|
| Relationship Databases | non-relationship database |
| Table Based | Document based |
| Predefined schema | Dynamic schema |
| Vertically scalable | Horizontally scalable |
| Uses structured query | Unstructured query language |
| language for defining data | focused on collection of documents |
- What kind of data is a good fit for an SQL database?
answer- Highly structured with clearly defined associations with program entities.
- Give a real world example.
answer- a point of sale system where you store orders and product records.
- What kind of data is a good fit a NoSQL database?
answer- Highly unstructured data with no clearly defined relationships between the data.
- Give a real world example.
answer- social media or website analysis data.
- Which type of database is best for hierarchical data storage?
answer- NoSQL
- Which type of database is best for scalability?
answer- if the data sets are going to be very large NoSQL is best.
- What does SQL stand for?
answer- Structured Query Language
- What is a relational database?
answer- A type of database that stores and accesses data points that are related to one another.
What type of structure does a relational database work with?
answer- Tables
What is a ‘schema’?
answer- the organization of a database used as a blueprint to show how a database is constructed.
What is a NoSQL database?
answer- They are built for specific data models that store information in JSON documents.
How does it work?
answer- They use collections instead of tables that use documents with key value pairs.
What is inside of a Mongo database?
answer- data stored as documents in json format.
Which is more flexible - SQL or MongoDB? and why.
answer- MongoDB because the flexibility of the schema allows you to dynamically add more without redefining structure.
What is the disadvantage of a NoSQL database?
answer- There is only so much power you can put into a computer so it has limits in scaling.