Is Oracle an example of DBMS or RDBMS?

Question

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?

Answer 1

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.

Answer 2

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.

So oracle is an RDBMS. See 25 examples of most popular RDBMS and DBMS

Answer 3

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.

Answer 4

DBMS

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

RDBMS

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

Answer 5

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.

Answer 6

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

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

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

Answer 7

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.

Answer 8

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.

Answer 9

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

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.

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

Answer 10

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.

Answer 11

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