SQL SERVER – Difference Between DBMS and RDBMS

What is the difference between DBMS and RDBMS?

DBMS – Data Base Management System

RDBMS – Relational Data Base Management System or Relational DBMS

A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored.

RDBMS adds the additional condition that the system supports a tabular structure of the data, with enforced relationships between the tables. This excludes the databases that don’t support a tabular structure or don’t enforce relationships between tables.

DBMS does not impose any constraints or security with regard to data manipulation it is used or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the RDBMS is more with this regards because RDBMS defines the integrity constraint for the purpose of holding ACID PROPERTY. RDBMS may be or may not be Client Server Database System.

Examples :

DBMS – File System, XML

RDBMS – SQL Server, Oracle

Reference : Pinal Dave (https://blog.sqlauthority.com)

Data Warehousing, Database, DBA, Software Development
Previous Post
SQLAuthority News – Famous Quotes From Bill Gates – Part 2
Next Post
SQL SERVER – 2008 – High Availability – Hot Add CPU

Related Posts

61 Comments. Leave new

Leave a Reply