什么时候应该使用 NoSQL 数据库而不是关系数据库?可以在同一个网站上使用两者吗? [英] When should I use a NoSQL database instead of a relational database? Is it okay to use both on the same site?

问题描述

使用 NoSQL 数据库有哪些优势?我最近阅读了很多关于它们的内容，但我仍然不确定我为什么要实现一个，以及在什么情况下我想使用一个.

What are the advantages of using NoSQL databases? I've read a lot about them lately, but I'm still unsure why I would want to implement one, and under what circumstances I would want to use one.

推荐答案

关系数据库强制执行 ACID.因此，您将拥有基于模式的面向事务的数据存储.它已被证明适用于 99% 的实际应用.您几乎可以使用关系数据库做任何事情.

Relational databases enforces ACID. So, you will have schema based transaction oriented data stores. It's proven and suitable for 99% of the real world applications. You can practically do anything with relational databases.

但是，当涉及到海量高可用性数据存储时，速度和扩展性会受到限制.例如，谷歌和亚马逊有数 TB 的数据存储在大数据中心.由于 RDBM 的阻塞/模式/事务性质，在这些场景中查询和插入性能不高.这就是他们实现自己的数据库(实际上是键值存储)以实现巨大的性能提升和可扩展性的原因.

But, there are limitations on speed and scaling when it comes to massive high availability data stores. For example, Google and Amazon have terabytes of data stored in big data centers. Querying and inserting is not performant in these scenarios because of the blocking/schema/transaction nature of the RDBMs. That's the reason they have implemented their own databases (actually, key-value stores) for massive performance gain and scalability.

NoSQL 数据库已经存在了很长时间 - 只是这个术语是新的.一些示例包括图形、对象、列、XML 和文档数据库.

NoSQL databases have been around for a long time - just the term is new. Some examples are graph, object, column, XML and document databases.

关于您的第二个问题:可以在同一个网站上同时使用两者吗?

For your 2nd question: Is it okay to use both on the same site?

为什么不呢?两者都有不同的用途对吧?

Why not? Both serves different purposes right?

这篇关于什么时候应该使用 NoSQL 数据库而不是关系数据库?可以在同一个网站上使用两者吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！