• 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.
0 comments