301 Class Eleven Reading Notes “MongoDB and Mongoose”
Questions
Fill in the chart below with five differences between SQL and NoSQL databases: Sql is relational databases and No Sql is a non relational database, SQL is table based storage and NoSql is document based storage, SQL databases have predefined schema whereas NoSQL databases have dynamic schema for unstructured data.
- What kind of data is a good fit for an SQL database? table based data
- Give a real world example. financial data
- What kind of data is a good fit a NoSQL database? no reklational data
- Give a real world example. facebook pages with image data and text data all together
- Which type of database is best for hierarchical data storage? NoSql
- Which type of database is best for scalability? SQL
- What does SQL stand for? standard query language
- What is a relational database? a type of database that stores and provides access to data points that are related to one another
- What type of structure does a relational database work with? a vertical strucutre
- What is a ‘schema’? a schema is a list of logical structures of data.
- What is a NoSQL database? a non-tabular database and stores data differently than relational tables
- How does it work? it uses key pairs to pull the data
- What is inside of a MongoDB database? a large nosql database that is effecient to use
- Which is more flexible - SQL or MongoDB? and why. MongoDB because it can store different schema in the same collection
- What is the disadvantage of a NoSQL database? duplicate data