sql - 如今，SQL数据库可以存储JSON。 那为什么我们需要NoSQL？(These days SQL databases can store JSON. Then why do we need NoSQL?)

Question

One of the advantages of NoSQL databases is to handle unstructured data.

(NoSQL数据库的优点之一是处理非结构化数据。)

Since that issue is now resolved in SQL databases, is there any need left for NoSQL?

(由于该问题现在已在SQL数据库中解决，因此NoSQL是否还有需要？)

Only advantage that I can think of is NoSQL is still better at scalability.

(我能想到的唯一优点是NoSQL在可伸缩性上仍然更好。)

  ask by Mohit Gupta translate from so

Answer 1

You might choose a NoSQL database for the following reasons:

(您可能出于以下原因选择NoSQL数据库：)

• 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数据库不限制可以存储在一起的数据类型。)

  NoSQL databases also enable you to add new data types as your needs change.

  (NoSQL数据库还使您能够根据需求的变化添加新的数据类型。)

  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.

  (但是，由于不需要提前准备NoSQL数据，因此您可以在停机时间最少的情况下频繁更新数据结构。)

• 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.

  (CAP（一致性，可用性和分区容限）定理指出，在任何分布式系统中，三个CAP属性中只有两个可以同时使用。)

  Adjusting these properties in favor of strong partition tolerance enables NoSQL users to boost horizontal scalability.

  (调整这些属性以增强分区容忍度，可使NoSQL用户提高水平可伸缩性。)