What is the difference between RDBMS and DBMS ?

What is a database management system?

Database management system (DBMS) is a software to manage large set of data on a computer hardware. RDBMS stands for relational database management system.

What is the key difference between DBMS and RDBMS?

Actually they are closely related. You can say that an RDBMS is a subset/extension of a DBMS.

DBMS applications can be relational or non-relational. Note that DBMS often used in place of non-relational DBMS (one of the reason newbies get confused).

A non-relational DBMS stores data as tables (without any relations between tables) or flat files. Document databases (Neo4j) and graph databases (MongoDB) are examples of DBMS.

On the other hand a RDBMS application store data in tabular form with relations between the tables. MySQL, PostgresSQL are examples of RDBMS. Tables in RDBMS can have a unique identifier (called primary key). Data values are stored in the tables and each of these values can be accessible through structured query language (SQL).

This post is licensed under CC BY 4.0 by the author.