Functions, Advantages, and Disadvantages

 Functions of DBMS

DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are

1. Data Dictionary Management

One of the most crucial features of a database management system is data dictionary management. The DBMS searches the data dictionary for the necessary data component structures and relationships, saving you from having to code such intricate associations manually for each program.

2. Data Storage Management

The creation and management of the intricate structures needed for data storage is one of the DBMS capability, which frees you from the challenging process of specifying and implementing the physical data characteristics.

3. Data transformation and presentation

The DBMS converts inputted data into the necessary data structures. You are relieved of the burden of differentiating between the logical data format and the physical data format by the DBMS. In order to make the physically retrieved data consistent with the user's logical expectations, the DBMS prepares the data.

4. Security Management

A vital component of database management systems is security management (DBMS). A security system that upholds user confidentiality and data privacy is developed by the DBMS. The database's users, the data items they can access, and the data actions (read, add, delete, or edit) they can carry out are all controlled by security rules. Particularly in relation to multiuser database systems, this is crucial.

5. Multi User Access Control

Another crucial DBMS function is multiuser access control. The DBMS uses sophisticated algorithms to ensure that several users can access the database concurrently without compromising the integrity of the database in order to provide data integrity and data consistency.

6. Backup and Recovery Management

To guarantee the security and integrity of data, the DBMS offers backup and data recovery. Today's DBMS systems include specialized utilities that let the DBA carry out standard and unique backup and restore procedures. Recovery management deals with the recovery of the database following a failure, such as a faulty sector in the disk or a power outage. The integrity of the database depends on this capability.

7. Data Integrity Management

Data integrity management is another important DBMS function. The DBMS promotes and enforces integrity rules, thus minimizing data redundancy and maximizing data consistency. Data integrity is kept via the data relationships that are contained in the data dictionary. In transaction-oriented database systems, it's crucial for DBMS functionality to ensure data integrity.

8. Database Access Languages and Application Programming Interfaces

Through a query language, the DBMS offers data access. A non-procedural language, such as a query language, enables users to express what needs to be done without also defining the specifics of how it should be done.

9. Database Communication Interfaces

DBMSs of the current generation may receive requests from users across a variety of networks. For instance, the DBMS might enable Internet access to the database using Web browsers like Mozilla Firefox or Microsoft Internet Explorer. Several methods of communication are possible in this setting:

- End users can generate answers to queries by filling in screen forms through their preferred Web browser.

- The DBMS can automatically publish predefined reports on a Website.

- The DBMS can connect to third-party systems to distribute information via e-mail or other productivity applications.



Advantages of DBMS


  • A database management system(DBMS) may store and retrieve data in a series of manners.
  • A database management system(DBMS) is a reliable manager for handling numerous applications requiring identical data.
  • Data Integrity and Security are guaranteed by DBMS.
  • The DBMS implements integrity contraints to provide a high degree of protection against unauthorized access to information.

Disadvantages of DBMS

  • The expense of DBMS hardware and software is enormously expensive which impacts your organization's overall budget.
  • A database management system(DBMS) is inadequate for doing complex mathematical calculations 
  • Since most database management systems are difficult and complicated, employees must always be instructed on how to operate them.
  • Many individuals using the same application simultaneously time potentially lead to data loss.

Comments

Post a Comment