Difference between DBMS and RDBMS

In this post, I will explain the difference between DBMS and RDBMS.

DBMS and RDBMS both are used to store information in a physical database but there are some remarkable differences between them. DBMS stands for Database Management System where RDBMS stands for Relational Database Management System. 

1. DBMS (Database Management System)

• DBMS applications store data as a file.
• In DBMS, data is generally stored in either a hierarchical form or a navigational form.
• Normalization is not present in DBMS.
• DBMS does not apply any security with regards to data manipulation.
• DBMS uses a file system to store data, so there will be no relation between the tables.
• DBMS must provide some uniform methods to access the stored information.
• DBMS does not support distributed database.
• DBMS is meant to be for small organization and deal with small data. it supports a single user.
• Examples of DBMS are file systems, XML etc.

2. RDBMS(Relational Database Management System)

• RDBMS applications store data in a tabular form.
• In RDBMS, the tables have an identifier called primary key and the data values are stored in the form of tables.
• Normalization is present in RDBMS.
• RDBMS defines the integrity constraint for the purpose of ACID (Atomicity, Consistency, Isolation and Durability) property.
• In RDBMS, data values are stored in the form of tables, so a relationship between these data values will be stored in the form of a table as well.
• RDBMS system supports a tabular structure of the data and a relationship between them to access the stored information.
• RDBMS supports distributed database.
• RDBMS is designed to handle a large amount of data. it supports multiple users.
• Example of RDBMS is SQL Server, Oracle etc.