class12.md

nosql vs sql

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

Relational Databases || distributed database.

databases represent data || databases are the collection of key-value pair, in form of tables || documents, graph databases or wide-column || stores

predefined schema || dynamic schema

databases are vertically || databases are horizontally scalable. scalable

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

Give a real world example. What kind of data is a good fit a NoSQL database? Give a real world example. Which type of database is best for hierarchical data storage? Which type of database is best for scalability?