DBMS and RDBMS

DBMS: A database management system (DBMS) is a software  that interacts with the user, other applications, and the database itself to capture and analyse data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

RDBMS: A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational models invented by E. F. Codd.

“RDBMS store the data into collection of tables, which might be related by common fields (database table columns). RDBMS also provide relational operators to manipulate the data stored into the database tables.

The key difference is that RDBMS applications store data in a tabular form, while DBMS applications store data as files. Does that mean there are no tables in a DBMS? There can be, but there will be no “relation” between the tables, like in a RDBMS. In DBMS, data is generally stored in either a hierarchical form or a navigational form.

Examples : SQL Server, ORACLE, DB2, MySQL, Teradata and etc…

-- By Shivasagar V