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, modification 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 columns also known as tuples and attributes respectively. RDBMS can be thought of as an extension of DBMS inspire 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 at least 6-7 rules out of the 12 rules defined by E.F Codd. Till date no RDBMS satisfies all the 12 rules.

Difference between DBMS and RDBMS

DBMS

• A DBMS stores data in form of objects or in the   form of files.
• Normalization is not possible in DBMS.
• Data is stored in hierarchical form generally.
• No use of constraints on the data stored.
• No relationship with the data stored.
• Follows no specific properties for data security while manipulating the data
• No support for Distributed Databases.
• DBMS deals with small data and generally supports single user.
• Examples:- file systems, XML etc.

 RDBMS

• A RDBMS stores data in tables also called as relations.
• Normalization is possible in RDBMS.
• Data is stored independently but are related through some constraints.
• To ensure data integrity and security several constraints are used.
• Data are related to each other.
• Follows ACID (Atomicity,Consistency,Integrity,Durability) properties for data security.
• Supports Distributed Databases.
• RDBMS deals with large data and generally supports multiple user.
• Examples:- MySQL, SQL server, Oracle etc.