Discuss why control procedures over access to the data resource become more crucial under the database approach than in the flat-file environment. What role does the DBMS play in helping to control the database environment?
Control Access in DBMS
• The motivation of DBMS is to provide a control access for the database. DBMS is a privileged software program created to know the data record of the user in a secured and protected access.
• Access control is manly useful for defining rules and restrictions and give the access to database files.
• If any user wants to access database files then the user should provide the credentials. Credentials may be a combination of numbers or alphabetical which can send to the database to access the files.
• The access control compares the credentials given by the user and then permits to login into the database.
• If the user gave wrong credentials then he cannot login and access the database files. This case is known as access of denial.
• All these logs are saved into the database. Access control helps to only authorized users can access the database.
Roles of DBMS in controlling the database access
Database Management System provides a controlled environment so that user can effectively manage the database and the resources. Roles of DBMS in controlling database access are as follows:
• User Programs: It ensures that the DBMS is translucent to the database user.
• Direct Query: It gives an access to the authenticated users using simple commands.
• Application Development: There is a chance to create applications by the users. The DBMS having the facility to create several applications by the internal programmers and users by inbuilt software.
• Backup and Recovery: The DBMS should have the copy of the database when any conflicts occur for the database. Suppose, if any upgrade of database is going on and unfortunately the file is corrupted, and then the user can recover the old database from backup.
• Database Usage Reporting: The DBMS maintains all the information of the database usage. These reporting shows the data such as how many users logged in the database, at what time user logged in, how long the user accessed the database, etc.
• Database Access: Permits the secured access to database users. This process can be done using the different techniques which are data manipulation language, query language and data definition language.