database Oracle 是 DBMS 还是 RDBMS 的示例？

Is Oracle an example of DBMS or RDBMS?

提问by khushboo

I am confused about the terms "DBMS" and "RDBMS". What exactly is the difference between them and more specifically, can oracle be called a DBMS or an RDBMS? If it is an example of an RDBMS, then what are examples of a DBMS?

我对术语“DBMS”和“RDBMS”感到困惑。它们之间到底有什么区别，更具体地说，oracle 可以称为 DBMS 还是 RDBMS？如果它是 RDBMS 的示例，那么 DBMS 的示例是什么？

回答by gbn

• DBMS includes Object Orientated or Hierarchical or NoSQL DBMS.
• RDBMS means those DBMS that are Relational (more or less).

• DBMS 包括面向对象或分层或 NoSQL DBMS。
• RDBMS 是指那些关系型（或多或少）的 DBMS。

One aspect of an RDBMS is that it stores its metadata in tables and access them via the query language.

RDBMS 的一个方面是它将元数据存储在表中并通过查询语言访问它们。

SELECT * FROM sys.tables, SELECT * FROM DUAL etc

回答by Pablo Santa Cruz

I would think Oracle is both: DBMSand RDBMS. Relational databases (RDBMS) are a subset of more generic databases management systems (DBMS).

我认为 Oracle 既是：DBMS又是RDBMS。关系数据库 (RDBMS) 是更通用的数据库管理系统 (DBMS) 的子集。

回答by Jamiec

For a quick summary of what a RDBMS is, i'd think wikipedia is a good a source as any:

对于 RDBMS 是什么的快速总结，我认为维基百科是一个很好的来源：

A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the relational database model.

A short definition of an RDBMS may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.

关系数据库管理系统 (RDBMS) 是基于 EF Codd 引入的关系模型的数据库管理系统 (DBMS)。目前使用的最流行的商业和开源数据库都是基于关系数据库模型的。

RDBMS 的一个简短定义可以是数据以表格的形式存储并且数据之间的关系也以表格的形式存储的DBMS。

from: http://en.wikipedia.org/wiki/Relational_database_management_system

来自：http: //en.wikipedia.org/wiki/Relational_database_management_system

回答by Ankita

DBMS: software that helps to store data in a database in the form of tables, manage databases on a single system or across a local network. They are used to manage small amount of data and are used in small business applications. eg: MsExcel

DBMS：帮助以表格形式将数据存储在数据库中、管理单个系统上或跨本地网络的数据库的软件。它们用于管理少量数据并用于小型企业应用程序。例如：MsExcel

RDBMS: a DBMS that also allows relationships to be established across different tables and allows querying of the table to extract certain data. They are useful to efficiently manage vast amount of data and are used in large business applications. eg: Oracle, MySQL.

RDBMS：一种 DBMS，它还允许在不同的表之间建立关系，并允许查询表以提取某些数据。它们可用于有效管理大量数据并用于大型业务应用程序。例如：甲骨文、MySQL。

So essentially, RDBMS is a superset of DBMS.

所以本质上，RDBMS 是 DBMS 的超集。

回答by Hema Ganapathy

Oracle is an example of RDBMS.Example systems are SQL Server, Oracle , MySQL, MariaDB, SQLite. And for DBMS example systems are dBase, Microsoft Acces, LibreOffice Base, FoxPro.

Oracle 是 RDBMS 的一个示例。示例系统有 SQL Server、Oracle、MySQL、MariaDB、SQLite。对于 DBMS 示例系统有 dBase、Microsoft Acces、LibreOffice Base、FoxPro。

回答by onedaywhen

Any SQL product is considered to be a RDBMS. Therefore, Oracle is a RDBMS.

任何 SQL 产品都被视为 RDBMS。因此，Oracle 是一个 RDBMS。

The confusing thing is that the 'R' in 'RDBMS' stands for 'relational' and SQL has many features that make it fundamentally at odds with current relational theory. However, the concept 'SQL means RDBMS' is too well established, the damage is done. Therefore, a new term was coined: TRDBMS where 'TR' stands for 'truly relational'. Oracle is not a TRDBMS.

令人困惑的是，“RDBMS”中的“R”代表“关系”，而 SQL 的许多特性使其与当前的关系理论根本不符。然而，“SQL 意味着 RDBMS”的概念太成熟了，损害已经造成。因此，创造了一个新术语：TRDBMS，其中“TR”代表“真正的关系”。Oracle 不是 TRDBMS。

回答by Bob Jarvis - Reinstate Monica

DBMS = Database Management System. In my mind this is a generic term which would include anysort of database, including relational databases (such as MySQL, Oracle, PostgreSQL, SQL Server, etc), hierarchical databases (such as IMS), network (example: IDMS), object-oriented, NoSQL, and others.

DBMS = 数据库管理系统。在我看来，这是一个通用术语，包括任何类型的数据库，包括关系数据库（例如 MySQL、Oracle、PostgreSQL、SQL Server 等）、分层数据库（例如 IMS）、网络（例如：IDMS）、对象面向、NoSQL 等。

RDBMS = Relational Database Management System. To me this is a sub-term of DBMS, including only those database products which implement (some form of) the relational model. Examples would be Oracle, MySQL, SQL Server, PostgreSQL.

RDBMS = 关系数据库管理系统。对我来说，这是 DBMS 的一个子术语，仅包括那些实现（某种形式）关系模型的数据库产品。例如 Oracle、MySQL、SQL Server、PostgreSQL。

SO, to answer your question "Is Oracle an example of DBMS or RDBMS", the answer is "Yes". :-)

因此，要回答您的问题“Oracle 是 DBMS 还是 RDBMS 的示例”，答案是“是”。:-)

Share and enjoy.

分享和享受。

回答by Gopi Nathan

Supporting Select * from System.table-x or user-table alone does not qualify a product as a Relational database. SELECT support can be implemnted by any DBMS (non-relational inclusive). As for meta data, again an Online Query SQL front allowed anyone to do a SELECT * FROM USER_047 (against the meta data in Dictionary) to IDMS as early as 1984. That time IDMS was a pure CODASYL network database. IDMS did come up with full sql support in the 1990s with SQL DDL and DML in native form.

仅支持 Select * from System.table-x 或 user-table 不能使产品成为关系数据库。SELECT 支持可以由任何 DBMS（非关系型）实现。至于元数据，早在 1984 年，一个 Online Query SQL 前端允许任何人对 IDMS 执行 SELECT * FROM USER_047（针对字典中的元数据）。那个时候 IDMS 是一个纯 CODASYL 网络数据库。IDMS 确实在 1990 年代通过 SQL DDL 和本机形式的 DML 提供了完整的 sql 支持。

Pure RDBMS must support fullscale DDL and DML using SQL like commands (SELECT, UPDATE, INSERT and DELETE) and GRANT, REVOKE etc for Access Control. Besides one could insist that no other access should be allowed. That is one should not be allowed to read any data if one doesnot go through the DBMS software of the product. Many PC databases of the 1980s fail this test. They were all some kind of file systems with some access (Sql or not ).

纯 RDBMS 必须支持使用 SQL 之类的命令（SELECT、UPDATE、INSERT 和 DELETE）和 GRANT、REVOKE 等进行访问控制的全面 DDL 和 DML。此外，可以坚持不应该允许其他访问。也就是说，如果不通过产品的DBMS 软件，则不允许读取任何数据。1980 年代的许多 PC 数据库未能通过此测试。它们都是某种具有访问权限的文件系统（Sql 与否）。

In a real DBMS, the database software alone should be able to update or even 'see' data. Operating system's own file programs should not be allowed to browse through the data in ASCII / EBCDIC form. DBMS in a way takes control of the whole storage areas of the files which is 'loaned' from the operating system. OS access methods are involved at the lowest level, but here user cannot intercept.

在真正的 DBMS 中，数据库软件本身就应该能够更新甚至“查看”数据。不应允许操作系统自己的文件程序浏览 ASCII/EBCDIC 格式的数据。DBMS 以某种方式控制从操作系统“借出”的文件的整个存储区域。最底层涉及到操作系统的访问方式，但这里用户无法拦截。

回答by Ned Batchelder

DBMS is a Database Management System. "R" adds Relational into the mix. Any RDBMS is therefore a DBMS. Oracle is a relational database, so it is an RDBMS.

DBMS 是一个数据库管理系统。“R”将关系添加到组合中。因此，任何 RDBMS 都是 DBMS。Oracle 是一个关系型数据库，所以它是一个 RDBMS。

回答by Kush

DBMS

数据库管理系统

1. It doesn't allow relations between the tables.
2. follows object oriented and hierarchical model, e.g. Foxpro

1. 它不允许表之间的关系。
2. 遵循面向对象和分层模型，例如 Foxpro

RDBMS

关系型数据库管理系统

1. It allows relations between the tables
2. follows relational model, e.g. Oracle,SQL Server

1. 它允许表之间的关系
2. 遵循关系模型，例如 Oracle、SQL Server