reading-notes

SQL vs NOSQL

SQL	NOSQL
databases are primarily called as Relational Databases (RDBMS)	database are primarily called as non-relational or distributed database.
databases are table based databases	NoSQL databases are document based, key-value pairs, graph databases or wide-column stores
databases have predefined schema	databases have dynamic schema for unstructured data
databases are vertically scalable	databases are horizontally scalable

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

if the project needs to handle small and homogeneous data, and the databases entities are clearly defined with unambiguous relationships.

The following illustrates (SQL server) the BikeStores database diagram

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

If the project is expected to see drastic changes, needs to handle the huge and versatile amount of data, or the database entities and scheme is ambiguous at the start.

SQL vs NOSQL examples