SQL and NOSQL

Yesterday I learned something new about SQL and NoSQL. There are two types of databases: SQL and NoSQL. The SQL stands for [ structured query language ] and stores data in a table format. It has a fixed Schema for storing data, and NoSQL stores data in a JSON format that is Key key-value pair example [ name: “ Sujeet Jain” ]. It is a flexible and dynamic Schema for storing data.

There are some databases present in the market.

SQL Database

1: MySQL
2: PostgreSQL
3: Oracle

NoSQL Database

1: MongoDB
2: Radis
3: Cassandra
4: Neo4j

Some Real-life Examples: The Use of Databases

Flipkart:

There are two categories on Flipkart: clothing and electronics. Both categories have different fields, like clothing, which has a colour, name, size, brand, and description.
The electronic category has different fields like specification, charging mode, wifi, SIM, camera, processor, RAM, etc.
If we use sql database in Flipkart the some fields are going Null because the electronic category has different fields. Instead of using SQL, we use noSql database that stores dynamic data.

Ola Cab:

Same as the Flipkart website that uses the NoSql for Dynamic Data. The Ola app also uses dynamic data. Because every time a new Person books a cab, the new location is added to the database. That‘s why it uses the NoSQL DB.

Netflix:

Netflix uses the SQL database because the fields are the same for storing movie data. But Netflix has a few sections that use the movie recommendation model that recommend movies based on your previous preferences. It becomes dynamic when the different users have different tastes in movies. It uses the hybrid model for storing different types of data.

SQL Uses:

SQL offers a consistent and structured data that is stored in rows and columns table format.
SQL is mostly used: Enterprise applications, Banking, and inventory Management.

NOSQL Uses:

NoSQL stores data in an unstructured format, which provides data scalability and flexibility. NoSQL is mostly used: streaming video applications, Uber applications, and data analytics.

NOSQL Uses:

NoSQL stores data in an unstructured format, which provides data scalability and flexibility
NoSQL is mostly used: streaming video applications, Uber applications, and data analytics.