What are the capabilities of DBMS and why relational DBMS is powerful?

Database management system (DBMS) is a software or tool which can be used for managing and maintaining the data within the database.

Major Capabilities of DBMS

The major capabilities of DBMS are listed below −

• Data Storage
• Data Retrieval
• Data Update
• Security
• Data Independence

Explanation

Generally a person has to work with a huge amount of information every day. In order to interact with the large amount of data we need a system where we can store, manipulate, security, sharing the information all over the world. It is a core reason the industries are maintaining database management tools.

Powerful Relational DBMS

The relational DBMS is more powerful because of the reasons explained below −

• In the RDBMS model the data will be stored in the form of tabular format, whereas, table is nothing but a collection of rows and columns.

• The RDBMS model will provide high level security by using authentication and authorisation.

• RDBMS maintains accuracy and consistency of the data with the help of data integrity mechanism.

• RDBMS supports the data manipulations by using DML commands.

• RDBMS provides faster rate retrieving the data by using index mechanism.

Benefits of RDBMS

Some of the key benefits of relational DBMS are as follows −

• Reduction in data duplication.

• Risk of inconsistent data is reduced, resulting in better data integrity.

• The Independence of data allows other views as well of the same data.

• Allows the easy extension to the structure of the database.

One of the limitations of relational DBMS is its rigidity which comes from organizing data into tables and relations.