Oracle 是 DBMS 或 RDBMS 的一个例子吗？
我对术语“DBMS”和“RDBMS”感到困惑。它们之间到底有什么区别，更具体地说，oracle 可以称为 DBMS 还是 RDBMS？如果它是 RDBMS 的示例，那么 DBMS 的示例是什么？
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（11）
我认为 Oracle 既是：DBMS 又是RDBMS。关系数据库 (RDBMS) 是更通用的数据库管理系统 (DBMS) 的子集。
I would think Oracle is both: DBMS and RDBMS. Relational databases (RDBMS) are a subset of more generic databases management systems (DBMS).
为了快速总结什么是 RDBMS，我认为维基百科是一个很好的来源：
来自：http://en.wikipedia.org/wiki/Relational_database_management_system
For a quick summary of what a RDBMS is, i'd think wikipedia is a good a source as any:
from: http://en.wikipedia.org/wiki/Relational_database_management_system
RDBMS 的一方面是将其元数据存储在表中并通过查询语言访问它们。
One aspect of an RDBMS is that it stores its metadata in tables and access them via the query language.
DBMS：帮助以表的形式将数据存储在数据库中、在单个系统或跨本地网络上管理数据库的软件。它们用于管理少量数据并用于小型企业应用程序。例如：MsExcel
RDBMS：一种数据库管理系统，还允许在不同的表之间建立关系，并允许查询表以提取某些数据。它们对于有效管理大量数据非常有用，并用于大型业务应用程序。例如：Oracle、MySQL。
因此本质上，RDBMS 是 DBMS 的超集。
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
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.
So essentially, RDBMS is a superset of DBMS.
任何 SQL 产品都被视为 RDBMS。因此，Oracle是一个RDBMS。
令人困惑的是，“RDBMS”中的“R”代表“关系”，而 SQL 的许多特性使其与当前的关系理论从根本上不一致。然而，“SQL 意味着 RDBMS”这一概念过于深入人心，损害已经造成。因此，创造了一个新术语：TRDBMS，其中“TR”代表“真正的关系”。 Oracle 不是 TRDBMS。
Any SQL product is considered to be a RDBMS. Therefore, Oracle is a 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.
Oracle 是 RDBMS 的一个示例。示例系统有 SQL Server、Oracle、MySQL、MariaDB、SQLite。对于 DBMS 示例系统有 dBase、Microsoft Acces、LibreOffice Base、FoxPro。
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.
DBMS 是一个数据库管理系统。 “R”将关系添加到组合中。因此，任何 RDBMS 都是 DBMS。 Oracle是一个关系型数据库，因此它是一个RDBMS。
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 = 数据库管理系统。在我看来，这是一个通用术语，包括任何类型的数据库，包括关系数据库（例如 MySQL、Oracle、PostgreSQL、SQL Server 等）、分层数据库（例如 IMS）、网络数据库（例如：IDMS）、面向对象、NoSQL 等。
RDBMS = 关系数据库管理系统。对我来说，这是 DBMS 的一个子术语，仅包括那些实现（某种形式）关系模型的数据库产品。例如 Oracle、MySQL、SQL Server、PostgreSQL。
因此，要回答您的问题“Oracle 是 DBMS 还是 RDBMS 的示例”，答案是“是”。 :-)
分享并享受。
DBMS = Database Management System. In my mind this is a generic term which would include any sort 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.
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.
SO, to answer your question "Is Oracle an example of DBMS or RDBMS", the answer is "Yes". :-)
Share and enjoy.
单独支持 Select * from System.table-x 或 user-table 并不能使产品成为关系数据库。 SELECT 支持可以由任何 DBMS（包括非关系型）来实现。至于元数据，早在 1984 年，在线查询 SQL 前端就允许任何人对 IDMS 执行 SELECT * FROM USER_047（针对字典中的元数据）。当时 IDMS 是一个纯粹的 CODASYL 网络数据库。 IDMS 确实在 20 世纪 90 年代以原生形式的 SQL DDL 和 DML 提供了完整的 sql 支持。
纯 RDBMS 必须支持使用类似 SQL 的命令（SELECT、UPDATE、INSERT 和 DELETE）以及 GRANT、REVOKE 等进行访问控制的全面 DDL 和 DML。此外，人们可以坚持不允许其他访问。也就是说，如果不通过产品的DBMS软件，则不应允许读取任何数据。 20 世纪 80 年代的许多 PC 数据库都未能通过此测试。它们都是某种具有一定访问权限（Sql 或非 Sql）的文件系统。
在真正的 DBMS 中，数据库软件本身就应该能够更新甚至“查看”数据。操作系统自身的文件程序不应该被允许浏览ASCII/EBCDIC形式的数据。 DBMS 在某种程度上控制了从操作系统“借用”的文件的整个存储区域。最底层涉及操作系统的访问方法，但这里用户无法拦截。
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.
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 ).
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
RDBMS
DBMS
RDBMS
它与普通的 DBMS 有什么不同？
RDBMS 允许数据标准化。
RDBMS 维护其表中存储的数据之间的关系。一个
普通的 DBMS 不提供任何此类链接。它空白地存储数据是
它的文件。
RDBMS 的结构化方法支持分布式数据库，这与传统数据库不同
普通的数据库管理系统。
How is it different from a normal DBMS?
RDBMS allows for normalization of data.
RDBMS maintains a relation between the data stored in its tables. A
normal DBMS does not provide any such link. It blankly stores data is
its files.
Structured approach of RDBMS supports a distributed database unlike a
normal database management system.