Database management system DBMS notes for knowledge

  database management system (DBMS) allows users to create, retrieve, update, and manage data in a database. A DBMS also ensures data security and reduces redundancy.

A database management system is a piece of software designed to facilitate data manipulation and database structure management. It also acts as a gate between the database and the users and apps that want to view or change the data.

The general features of a DBMS are:

User accessible catalog describing metadata.

DBMS library management system.

Data abstraction and independence.

High security level.

Performance monitoring.

Activity logging and auditing.

Concurrency and transaction support.

Access authorization.

Remote access support.

Data recovery in case of damage.

Constraints ensuring the data follows the rules set by the administrator.