Understanding the function, advantages and disadvantages of DBMS

 

What is DBMS?

The Database Management System is a software for creating, storing, updating, and managing structured data. Without DBMS, data would be scattered across multiple files making it difficult to locate or update.

Function of DBMS

Data Definition - Define database structured and rules.

 Data Security and Access - Control who can see or access data using password and permission. 

 Data Integrity - keep data accurate and consistent. 

Data Backup and Recovery - Create copies of data to restore or prevent loss if the system crashes.

Advantages of DBMS

Reduce Redundancy - Eliminates duplicates data stored in different files and saving space. 

  Data Sharing - Allows different users and programs to access the same data safely.

Data Security - Protects sensitive information with restrict access control.

Backup and Recovery - Automated safety nets prevent data loss from crashes.

Disadvantages of DBMS

High Cost - Software and hardware are expensive to purchase and maintain.

Complexity - Requires specialized training to design, set up, and manage.

Overhead - The system uses processing power and memory to manage itself, which can slow down simple task.

Single Point of Failure - If the database crashes, all applications relying on it stop working.