What is the Difference between DBMS and RDBMS?

ADVERTISEMENT

Author

shabbir ( Go4Expert Founder )

Shabbir is a developer in the field of Applications, web as well as database designing and is devoted to the optimization and usability of the code. He maintains Programming forum and is a C++ addict.

All articles By shabbir

Recent Articles

• SQL Server, Oracle and MySQL basic questions and answers, Started by Shree Limbkar in Database
• Calculating Date Differences, Started by Janu in Database
• Small Bug tracking utility in C# with access as database, Started by shabbir in Database
• Query Optimization, Started by coderzone in Database
• Difference between Stored procedures and User Defined functions[UDF], Started by shabbir in Database

Similar Articles

• Oops, No Similar Articles found for What is the Difference between DBMS and RDBMS? but you can check out the Recent Articles.
• Also see more articles by shabbir.

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 is a Relational Data Base Management System Relational DBMS. This adds the additional condition that the system supports a tabular structure for 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.

Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.

Yes you can say DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard bcz rdbms define the integrity constraint for the purpose of holding ACID PROPERTY.

I have found many answers on many websites saying that

DBMS are for smaller organizations with small amount of data, where security of the data is not of major concern and RDBMS are designed to take care of large amounts of data and also the security of this data.

and this is completely wrong by definition of RDBMS and DBMS

More Database Articles

100+ SQL Server, Oracle and MySQL basic questions and answers
Database interview questions for beginner
Difference between Stored procedures and User Defined functions[UDF]
Basics of Database Normalization
What you should know for Query Optimization

[coderzone]

Originally Posted by shabbir

I have found many answers on many websites saying that

and this is completely wrong by definition of RDBMS and DBMS

I also found the same and I think the difference that you have mentioned is the genuine ones.

[eddiecraig]

hi shabbir,
thanks for explaining about the differnce between dbms and rdbms...

[eddiecraig]

hi shabbir,
thanks for explaining about the differnce between dbms and rdbms...

[ahabeebur]

hi shabbir,

TnX ,,,

[micman]

short and clear!

[sachinsasneh]

thanks for given in simple and short language..

[seangtz]

Thx for sharing useful information.

[XXxxImmortalxxXX]

thanks for the info mate

[VasanPonnusamy]

Thanks a lot..
Vasan Ponnusamy