DBMS和RDBMS有什么区别？ [英] What is the difference between DBMS and RDBMS?

问题描述

在其他网站上阅读了一些答案后，我现在很困惑。因此，提及DBMS和RDBMS之间的关键区别以及它们之间的任何关系将很有帮助。

After reading some answers on different websites I am confused now. So, it would be helpful to mention the key difference between DBMS and RDBMS and any relation between them.

推荐答案

_{这个问题在Stack Overflow上很流行，我正在发布一个答案，为我解答这个问题。我在 udemy网站上找到了这个答案。希望这将有助于将来的用户和新手在这个主题上寻找一个好的答案。}

_{Since this question become popular on Stack Overflow, I am posting an answer which answers this question for me. I found this answer on udemy website. Hope this will help future users and newbies searching for a good answer on this topic.}

主要区别在于RDBMS（关系数据库管理系统）应用程序以表格形式存储数据，而DBMS应用程序以文件形式存储数据。

这意味着在其中没有表一个DBMS？

Does that mean there are no tables in a DBMS?

可以，但是在表之间没有关系 ，就像在RDBMS中一样。在DBMS中，数据通常以分层形式或导航形式存储。这意味着单个数据单元将具有一个父节点和零个，一个或多个子节点。它甚至可以以图形形式存储，可以在网络模型中看到。

There can be, but there will be no "relation" between the tables, like in a RDBMS. In DBMS, data is generally stored in either a hierarchical form or a navigational form. This means that a single data unit will have one parent node and zero, one or more children nodes. It may even be stored in a graph form, which can be seen in the network model.

在RDBMS中，表将具有称为主键的标识符。数据值将以表格形式存储。这些数据值之间的关系也将以表格的形式存储。关系数据库中存储的每个值都是可访问的。该值可以由系统更新。此系统中的数据在物理和逻辑上也是独立的。

In a RDBMS, the tables will have an identifier called primary key. Data values will be stored in the form of tables. The relationships between these data values will be stored in the form of a table as well. Every value stored in the relational database is accessible. This value can be updated by the system. The data in this system is also physically and logically independent.

您可以说RDBMS是DBMS的扩展，即使它们之间存在许多差异他们俩。当今市场上的大多数软件产品都符合DBMS和RDBMS。从本质上讲，他们可以以（关系）表格形式和文件形式或同时以两种形式维护数据库。这意味着今天RDBMS应用程序是DBMS应用程序，反之亦然。但是，用于存储数据的关系数据库系统与普通数据库系统之间仍然存在主要差异。

You can say that a RDBMS is an extension of a DBMS, even if there are many differences between the two. Most software products in the market today are both DBMS and RDBMS compliant. Essentially, they can maintain databases in a (relational) tabular form as well as a file form, or both. This means that today a RDBMS application is a DBMS application, and vice versa. However, there are still major differences between a relational database system for storing data and a plain database system.

这篇关于DBMS和RDBMS有什么区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！