reading-notes

nosql vs sql

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

SQL	NoSQL
SQL databases are primarily called as Relational Databases	NoSQL database are primarily called as non-relational
SQL databases are table based databases whereas	NoSQL databases are document based
SQL databases represent data in form of tables which consists of n number of rows of data whereas	NoSQL databases are the collection of key-value pair, documents
SQL databases have predefined schema whereas	NoSQL databases have dynamic schema for unstructured data.
SQL databases are vertically scalable whereas	NoSQL databases are horizontally scalable

MySQL Community Edition

NoSQL databases do a better job at representing real world objects

NoSQL database fits better for the hierarchical data storage as it follows the key-value pair way of storing data similar to JSON data

In most typical situations, SQL databases are vertically scalable.

NoSQL databases are horizontally scalable.

Structured Query Language

database that works with creation assumptions

Structured Query Language like table , products table

so-called fields

is a type of database that stores and retrieves data without needing to define its structure first

accommodate a wide variety of data models, including key-value, document

document is a representation of a single entity of data in the MongoDB database

MongoDB because it does not have to worry about transactions or rollbacks