reading-notes

Mongo and Mongoose

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

SQL NoSQL
primarily called as Relational Databases (RDBMS) primarily called as non-relational or distributed database.
table based databases document based, key-value pairs, graph databases or wide-column stores.
have predefined schema have dynamic schema for unstructured data.
SQL databases are vertically scalable NoSQL databases are horizontally scalable
SQL databases are scaled by increasing the horse-power of the hardware NoSQL databases are scaled by increasing the databases servers in the pool of resources to reduce the load.

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

SQL databases are table based databases This means that SQL databases represent data in form of tables.

2. Give a real world example

  1. MySQL Community Edition,MySQL database is very popular open-source database. It is generally been stacked with apache and PHP, although it can be also stacked with nginx and server side javascripting using Node js.

  2. Oracle Express Edition,It is a limited edition of Oracle Enterprise Edition server with certain limitations. This database is free for development and deployment.

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

document based, key-value pairs, graph databases or wide-column stores.

4. Give a real world example

  1. MongoDB,is one of the most popular document based NoSQL database as it stores data in JSON like documents. It is non-relational database with dynamic schema. It has been developed by the founders of DoubleClick, written in C++ and is currently being used by some big companies like The New York Times, Craigslist, MTV Networks.

  2. CouchDB,a document based NoSQL database. It stores data in form of JSON documents.

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

NoSQL database.

6. Which type of database is best for scalability?

SQL Database.

Things I want to know more about