CODEWITHSUNDEEP
sqljsonnosql
Mohit Gupta
Mohit Gupta

Reputation: 85

These days SQL databases can store JSON. Then why do we need NoSQL?

One of the advantages of NoSQL databases is to handle unstructured data. Since that issue is now resolved in SQL databases, is there any need left for NoSQL? Only advantage that I can think of is NoSQL is still better at scalability.

Upvotes: 2

Views: 368

Answers (2)

TS Kahlon
TS Kahlon

Reputation: 106

You might choose a NoSQL database for the following reasons:

  • To store large volumes of data that might have little to no structure.

    NoSQL databases do not limit the types of data that you can store together. NoSQL databases also enable you to add new data types as your needs change. With document-oriented databases, you can store data in one place without having to define the data type in advance.

  • To make the most of cloud computing and storage.

    In order for a cloud solution to be scalable, the data must be easy to share across multiple servers.

  • To speed development.

    When you are developing in rapid iterations or making frequent updates to the data structure, a relational database slows you down. However, because NoSQL data doesn’t need to be prepped ahead of time, you can make frequent updates to the data structure with minimal downtime.

  • To boost horizontal scalability.

    The CAP (consistency, availability, and partition tolerance) theorem states that in any distributed system, only two of the three CAP properties can be used simultaneously. Adjusting these properties in favor of strong partition tolerance enables NoSQL users to boost horizontal scalability.

Upvotes: 4

TS Kahlon
TS Kahlon

Reputation: 106

The following Link provides sufficient details about the requirement of NoSQL databases.

https://support.rackspace.com/how-to/reasons-to-use-a-nosql-db/

Upvotes: 2

Related Questions