Skip to content

Latest commit

 

History

History
30 lines (27 loc) · 1.24 KB

File metadata and controls

30 lines (27 loc) · 1.24 KB

Mongo and Mongoose

nosql vs sql

1. Fill in the chart below with five differences between SQL and NoSQL databases:

SQL

1.Called as Relational Databases (RDBMS).
2.Table based databases.
3.Have predefined schema.
4.Vertically scalable.
5.Uses SQL ( structured query language ) for defining and manipulating the data.

NoSQL

1.Called as non-relational or distributed database.
2.document based, key-value pairs, graph databases or wide-column stores.
3.Have dynamic schema for unstructured data.
4.Horizontally scalable.
5.Queries are focused on collection of documents. Sometimes it is also called as UnQL (Unstructured Query Language).

2.What kind of data is a good fit for an SQL database?

For the complex query intensive environment.

3.Give a real world example.

MySQL Community Edition

4.What kind of data is a good fit a NoSQL database?

Hierarchical data storage as it follows the key-value pair way of storing data similar to JSON data.

5.Give a real world example.

MongoDB.

6. Which type of database is best for hierarchical data storage?

NoSQL database.

7.Which type of database is best for scalability?

SQL databases.