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)
61 Comments. Leave new
Sir,
Can we say that RBDMS is the dbms which satisfy 12 Effe Code rules?
Ihave created a database in sql 2005 with this script
SQL> create database ROCKINGHAM
Go
the database was created successfuly but i cannot see the database from the explorer window and also i can connect to the dabase but i cannot create table that i want inside the database. plis is anybody be a help plis is my assignment
You need to refresh the object explorer
Hi People,
I am Sagar, i am planning to change the current job. currenctly i am working as Prod MS SQL DBA, please can you send me some questions and answers realated to prod dba?
Please let me know about any opening for Prod DBA.
Thanks in advance.
Regards,
Sagar
Hi,
I think RDBMS is a type of DBMS because DBMS is collection of programs to maintain the database, and file system, xml are not an example of DBMS.
Regards,,,
REMYA
GUD EXPLANATION
SANGEETHA
SIR,
very thankfull
GOOD ANSWER
Nice Explanation
Hi,
I am working as a software support engineer(Dot Net, MS SQL). I want to move SQL Developer. Please guide me any one. Reply with my mail id
mostly in interview what type of questions they will ask in this subject… ???? pls reply me to my mail….
hii
I need log shipping details and log shipping interview question
Ganesh
hello sir i need to know about the limitation of RDBMS
i wnt to knw that sql is a dbms or rdbms????