Function of database administrator for management
Individuals familiar with database systems and creating, manipulating, modifying, enhancing, managing, and managing databases
The person who is skilled enough in the work of control is the ebb administrator. That is, he is the database control officer. The Database Administrator defines and controls the database structure. He is about three levels of database system Has a thorough idea and defines the overview of the database in consultation with the users. Hardware, Measures to prevent data loss due to software errors, human and natural disasters Accepts. That is, data is required for back-up and recovery and conditions or data obligation at low tide Controls.
So, in a database management system, the person who centrally designs the database, controls the ebb flow, the database
The person who is in charge of managing the system is called the Database Administrator.
The administrator in the database needs to be a good and efficient controller. Because of his administrative and technical skills
The overall success of database management depends.
1. Schema definition: The temporary design of the database is called schema. The Database Administrator provides the schema definition of the database. He created the original database schema by writing a set of definitions. The DDL compiler compiles it into a set of tables and data Permanently stored in a file called Dictionary.
2. Schema and physical organization modification:
Database administrator Description set definition for database schema or physical storage organization Modify them by typing DDL compiler or data storage and DDL compiler Is used. The result is an internal system table such as a data dictionary Modifications are generated. However, the Database Administrator rarely does the work of modification.
3. Storage structure and access method definition:
Database Administrator composes a set of definitions to create appropriate storage and access methods. Later
It is translated by Data Storage and Definition Language Compiler.
4. Granting of authorization for data access:
Database administrators allow different types of user authority. That is, the administrator of the database specifies that the user can access, modify, etc. in any part of the database. This makes it possible to control the user’s access to certain parts of the database and ensure the security of the database. Through this It is possible to prevent a person from accessing the database in an unauthorized corner.
5. Integrity constraint specification:
The data value stored in the database must satisfy certain types of Consistency constraints. Workers in such corners will not be able to work overtime for more than 4 hours per day and above 90 hours per month. Such an obligation must be specifically specified by the Database Administrator and if he specifies, then the Database Manager is required to do so later. Will take action.
The Database Administrator puts Integrity constraint in the Special system structure. As a result, when an update occurs in a corner of the system, the database manager performs the work according to that structure.