Difference between DBMS and RDBMS

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

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.

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.

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.

Also Read: Difference between SQL and PL/SQL

Difference between DBMS and RDBMS

Image Source

Difference between DBMS and RDBMS

DBMS

RDBMS

A DBMS stores data in form of objects or in the form of files.

A RDBMS stores data in tables also called as relations.

Normalization is not possible in DBMS.

Normalization is possible in RDBMS.

Data is stored in hierarchial form generally.

Data is stored independently but are related through some constraints.

No use of constraints on the data stored.

To ensure data integrity and security several constraints are used.

No relationship with the data stored.

Data are related to each other.

Follows no specific properties for data security while manipulating the data

Follows ACID (Atomicity,Consistency,Integrity,Durability) properties for data security.

No support for Distributed Databases.

Supports Distributed Databases.

DBMS deals with small data and generally supports single user.

RDBMS deals with large data and generally supports multiple user.

Examples:- file systems,xml,etc.

Examples:- mysql, sql server, oracle etc.

Category: SQL

2 thoughts on “Difference between DBMS and RDBMS

  1. ravi mewada

    awesome website I learn lot of think in dbms from there…..

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *