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