What is RDBMS? Explain its major functions

DBMSDatabaseBig Data Analytics

RDBMS is a relational database management system which is the root for SQL. It is designed totally for relational models. The relational model can be represented on a table with rows and columns. Oracle is an example of RDBMS.

  • RDBMS is a plan of action and employs a structure which permits to recognize, update and handle the relation database.

  • It is arranged in tables which contains rows and columns.

  • Every row in a table is nothing but a record through the unique ID known as key. Employs the normalization (method of arranging data in a database for eliminating the redundancy).

Functions of RDBMS

RDBMS provides the four major functions as listed −

Security

This is one of the most important functions of RDBMS. Security management sets rules that allow accessing the database. This function also sets restraints on what specific data any user can see or write.

Accuracy

In relational database management systems multiple tables are related to one another with the use of primary key and foreign key concepts. This makes data non repetitive so there is no chance for duplication of data. Hence, accuracy of RDBMS is good.

Integrity

Data integrity enforces the three constraints. Entity integrity means a table should have the primary key.

Consistency

The data consistency in relational model is best in RDBMS for maintaining data across application and database copies.

Advantages of RDBMS

The advantages of RDBMS are as follows −

  • RDBMS is based on rows and columns (table). So it is easier to understand RDBMS work.

  • RDBMS supports more than one user.

  • As it is advanced it can easily handle huge amounts of data.

  • Security is pretty good for RDBMS.

Disadvantages of RDBMS

The disadvantages of RDBMS are as follows −

  • It is very costly.

  • Special software is required for RDBMS.

Comparison of DBMS and RDBMS

The major differences between DBMS and RDBMS are as follows −


DBMSRDBMS
User AvailabilityIt only supports one user at a time.RDBMS supports more than one user at a time.
SecurityDBMS doesn’t have any kind of securityThere are multiple layers of security in RDBMS.
UsageDBMS is used to handle small amounts of data.RDBMS is used to handle huge sums of data.
OrderData is stored in forms of files.Data in RDBMS is stored in the form of tables.
SpeedDBMS takes time to load data.RDBMS loads data faster.
raja
Published on 08-Jul-2021 08:22:15
Advertisements