Difference between DBMS and RDBMS

RDBMS is a super set of DBMS plus some more features.

Consolidated few differences here.


DBMS RDBMS
Organization, storage, management, and retrieval of data Yes Yes
Flat file design Yes No
Relational design No Yes
Password protection Yes Yes
Enforce referential integrity No Yes
Null or blank data management Yes Yes
Meta data support Yes Yes
Support relatively large set of data No Yes
Support complex business applications No Yes

Microsoft Access is an example of  DBMS.

Oracle, Microsoft SQL Server, DB2 are few examples for RDBMS.

Advertisements

Introduction – DBMS and RDBMS

What is DBMS ?

A DBMS is a set of software programs that controls the system organization, storage, management, and retrieval of data in a database. The DBMS determines how data are stored and retrieved.

Data is the back bone of any organization. So it is very essential to manage it in a efficient way. DBMS accepts request from application and processes in the operating system and vice verse.

Examples :- Oracle, Microsoft SQL Server, DB2, MySQL etc.

Features of DBMS

1. Data Security –

DBMS is capable of protecting the data stored inside the database. Examples are database passwords, schema management etc.

2. Data Integrity –

DBMS ensures the data integrity by maintaining the transcriptional and user level access. It eliminates the unwanted duplicity.

3. Data Access –

DBMS provides an efficient way to access and manage the data called SQL (Structured Query Language). All modern databases support SQL.

4. Data Audit –

DBMS should allow to audit and manage the data stored inside the database.

What is RDBMS ?

Any DBMS which has the ability to represent the data in set of tuples (related set of data) which share the same type is called RDBMS. In another way it organizes data into related rows and columns. All RDBMS terms can be defined in mathematical terms. In RDBMS all tables will have a relationship among.

Relational Model

The fundamental assumption of the relational model is that all data is represented as mathematical n-tuples relations. The relational model of data permits the database designer to create a consistent, logical representation of information.

Comparing Relational and Mathematical models

Relational Model Mathematical Model
Column Attribute
Row Tuple
Table Relation
Data Set Element