DBMS和RDBMS之间的区别

野性酷女 2022-12-07 13:58 138阅读 0赞

In this tutorial you will learn about difference between dbms and rdbms with example.

在本教程中，您将通过示例了解dbms和rdbms之间的区别。

**DBMS**

**数据库管理系统**

DBMS stands for Data Base Management System. This system is a computer software component introduced during 1960’s. It is a software that is used to store any type of data and it should provide easy manipulation of the data such as insertion, deletion, updation of the data. The data can be anything such as raw information about a person, company or it can be objects, for that purpose we use an object oriented DBMS or a Multimedia Database. DBMS has several components. Some of the major components are external interface, database language engine, query optimizer, database engine, storage engine, DBMS management component, etc.

DBMS代表数据库管理系统。 该系统是1960年代引入的计算机软件组件。 它是一种用于存储任何类型的数据的软件，它应该提供对数据的轻松操纵，例如数据的插入，删除，更新。 数据可以是任何东西，例如有关个人，公司的原始信息，也可以是对象，为此，我们使用面向对象的DBMS或多媒体数据库。 DBMS具有多个组件。 一些主要组件是外部接口，数据库语言引擎，查询优化器，数据库引擎，存储引擎，DBMS管理组件等。

**RDBMS**

**关系数据库管理系统**

RDBMS stands for Relational Database Management System. During 1970’s RDBMS or Relational database management system came into existence. It is a software which is used to store only that data which can be stored in the form of tables (also called relations). Data is managed and stored in rows and colums also known as tuples and attributes respectively. RDBMS can be thought of as an extension of DBMS inspite of the differences between them.

RDBMS代表关系数据库管理系统。 在1970年代，RDBMS或关系数据库管理系统应运而生。 它是一种仅用于存储可以以表格形式(也称为关系)存储的数据的软件。 数据被管理和存储在分别称为元组和属性的行和列中。 尽管RDBMS之间存在差异，但可以将它们视为DBMS的扩展。

Every RDBMS is a DBMS, but the opposite is not true. For a DBMS to be termed as RDBMS it must satisfy atleast 6-7 rules out of the 12 rules defined by E.F Codd. Till date no RDBMS satisfies all the 12 rules.

每个RDBMS都是一个DBMS，但事实并非如此。 对于要被称为RDBMS的DBMS，它必须满足EF Codd定义的12条规则中的至少6-7条规则。 到目前为止，没有RDBMS满足所有12条规则。

**Also Read:** [**Difference between SQL and PL/SQL**][Difference between SQL and PL_SQL]

**另请阅读：** [**SQL与PL / SQL之间的区别**][Difference between SQL and PL_SQL]

![Difference between DBMS and RDBMS][]

[Image Source][]

[图片来源][Image Source]

## DBMS和RDBMS之间的区别 **(**Difference between DBMS and RDBMS**)** ##

<table> 
 <tbody> 
 <tr> 
 <td> DBMS </td> 
 <td> RDBMS </td> 
 </tr> 
 <tr> 
 <td> A DBMS stores data in form of objects or in the form of files. </td> 
 <td> A RDBMS stores data in tables also called as relations. </td> 
 </tr> 
 <tr> 
 <td> Normalization is not possible in DBMS. </td> 
 <td> Normalization is possible in RDBMS. </td> 
 </tr> 
 <tr> 
 <td> Data is stored in hierarchial form generally. </td> 
 <td> Data is stored independently but are related through some constraints. </td> 
 </tr> 
 <tr> 
 <td> No use of constraints on the data stored. </td> 
 <td> To ensure data integrity and security several constraints are used. </td> 
 </tr> 
 <tr> 
 <td> No relationship with the data stored. </td> 
 <td> Data are related to each other. </td> 
 </tr> 
 <tr> 
 <td> Follows no specific properties for data security while manipulating the data </td> 
 <td> Follows ACID (Atomicity,Consistency,Integrity,Durability) properties for data security. </td> 
 </tr> 
 <tr> 
 <td> No support for Distributed Databases. </td> 
 <td> Supports Distributed Databases. </td> 
 </tr> 
 <tr> 
 <td> DBMS deals with small data and generally supports single user. </td> 
 <td> RDBMS deals with large data and generally supports multiple user. </td> 
 </tr> 
 <tr> 
 <td> Examples:- file systems,xml,etc. </td> 
 <td> Examples:- mysql, sql server, oracle etc. </td> 
 </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
 <tr> 
 <td> 数据库管理系统 </td> 
 <td> 关系数据库管理系统 </td> 
 </tr> 
 <tr> 
 <td> DBMS以对象形式或文件形式存储数据。 </td> 
 <td> RDBMS将数据存储在表(也称为关系)中。 </td> 
 </tr> 
 <tr> 
 <td> 在DBMS中无法进行规范化。 </td> 
 <td> 在RDBMS中可以进行标准化。 </td> 
 </tr> 
 <tr> 
 <td> 数据通常以分层形式存储。 </td> 
 <td> 数据是独立存储的，但由于某些约束而相互关联。 </td> 
 </tr> 
 <tr> 
 <td> 不对存储的数据使用约束。 </td> 
 <td> 为了确保数据完整性和安全性，使用了几个约束。 </td> 
 </tr> 
 <tr> 
 <td> 与存储的数据无关。 </td> 
 <td> 数据彼此相关。 </td> 
 </tr> 
 <tr> 
 <td> 在处理数据时不遵循特定的属性以确保数据安全 </td> 
 <td> 遵循ACID(原子性，一致性，完整性，耐用性)属性以确保数据安全。 </td> 
 </tr> 
 <tr> 
 <td> 不支持分布式数据库。 </td> 
 <td> 支持分布式数据库。 </td> 
 </tr> 
 <tr> 
 <td> DBMS处理小数据，通常支持单个用户。 </td> 
 <td> RDBMS处理大数据，通常支持多用户。 </td> 
 </tr> 
 <tr> 
 <td> 示例：-文件系统，xml等。 </td> 
 <td> 示例：-mysql，sql server，oracle等 </td> 
 </tr> 
 </tbody> 
</table>

> 翻译自: [https://www.thecrazyprogrammer.com/2017/03/difference-between-dbms-and-rdbms.html][https_www.thecrazyprogrammer.com_2017_03_difference-between-dbms-and-rdbms.html]

[Difference between SQL and PL_SQL]: https://www.thecrazyprogrammer.com/2016/09/difference-between-sql-and-plsql.html
[Difference between DBMS and RDBMS]: /images/20221123/33aa35fb591145fe8363d49ca6bf7fbf.png
[Image Source]: http://www.tvisha.com/blog/what-is-the-difference-between-dbms-and-rdbms/
[https_www.thecrazyprogrammer.com_2017_03_difference-between-dbms-and-rdbms.html]: https://www.thecrazyprogrammer.com/2017/03/difference-between-dbms-and-rdbms.html