Find your content:

Search form

You are here

NoSQL vs SQL Database - Help Interview Questions

 
Share

If data is not structured and expect to receive high volume of data use nosql database.

 

Pros

1. Joins may not required if document contains all the data

2. Schema flexible

3. Horizontal partitioning is default in NoSQL

4. Store massive amount of data

 

Disadvantages

1. Financial systems won't use nosql because transaction may have a ACID problem.

2. Joins are hard if data splitted in multiple places.

3. Not read optimize ( Need to read entire document to read the data)

My Block Status

My Block Content