Difference between DBMS & RDBMS

[skyway]

Salam All..
One of the important questions which u may have asked urselves about one day and which u may encounter in job interviews ... this very important question is :

WHAT IS THE DIFFERENCE BETWEEN DataBase Management Sysytem(DBMS) and Relational DataBase Management System(RDBMS)?
Here is the answer


DBMS/RDBMS
1. DBMS - Database Management Systems
Companies need to process a large amount of data. Manual storage of this data wastes a lot of time while retrieving it. It also requires tedious clerical hours to arrange the data in the form required by top management. Storing this data in a way to facilitate easy access is very important and that is why computers are used in organizations. This is possible using DBMS. DBMS, besides allowing you to store large amounts of data, allows you to retrieve information easily whenever and in whichever format it is desired.

2. RDBMS - Relational Database Management Systems
The functionality of RDBMS is the same as DBMS except that the features offered for data storage and retrieval are very advanced. These systems are based on mathematical SET theory. A RDBMS ensures that the data stored in the database is accurate and relevant. Excellent security features are offered by these systems. RDBMS packages are used in medium to large-scale organizations, especially, those where data has to be made available on distributed networks.

These systems have capability to store a very large amount of data and have quick data retrieval mechanisms. They also have elaborate database administration for handling multi-users, storage, and failures.

An RDBMS uses SQL (Structures Query Language) to access data from database. This is a standard language commonly used across different RDBMS.

3. What is the difference between RDBMS & DBMS?
DBMS are for smaller organizations with small amount of data, where security of the data is not of major concern. Also DBMS are not necessarily client server based systems. With DBMS, one can develop a complete application, starting from processing inputs to generating output.

RDBMS are designed to take care of large amounts of data and also the security of this data. They are also client server based systems. To create a complete application, one requires client software like VB, Developer 2000.