Ticker

6/recent/ticker-posts

Functions of DBMS (Database Management System)

Data Definition: 

The DBMS provides functions to define the structure of the data in the application. These include defining and modifying the record structure, the type and size of fields and the various constraints to be satisfied by the data in each field. 

Data Manipulation: 

Once the data structure is defined, data needs to be inserted, modified or deleted. These functions which perform these operations are part of DBMS. These functions can handle plashud and unplashud data manipulation needs. Plashud queries are those which form part of the application. Unplashud queries are ad-hoc queries which performed on a need basis. 

Data Security & Integrity: 

The DBMS contains modules which handle the security and integrity of data in the application. 

Data Recovery and Concurrency: 

Recovery of the data after system failure and concurrent access of records by multiple users is also handled by DBMS. 

Data Dictionary Maintenance: 

Maintaining the data dictionary which contains the data definition of the application is also one of the functions of DBMS. 

Performance: 

Optimizing the performance of the queries is one of the important functions of DBMS.

ALSO SEARCH:

"functions of a database management system (dbms)"

"what are the five primary functions of a database management system (dbms)"

"explain the functions of a database management system (dbms)"

"describe a purpose of databases and the functions of a database management system (dbms)"

"list four (4) functions of a database management system (dbms)"

"main functions of database management system (dbms)"

"five functions of database management system"