(1) determine the information content and structure in the database
Which information should be stored in the database? DBAs should participate in the decision-making. Therefore, DBAs must participate in the whole process of database design and work closely with users, application programmers, and system analysts to negotiate and design databases.
(2) determine the database storage structure and Access Policy
DBAs should take into account the application requirements of various users and jointly determine the data storage structure and access policies with database designers to achieve high access efficiency and storage space utilization.
(3) define data security requirements and integrity constraints
DBA is responsible for ensuring the security and integrity of the database. Therefore, DBA is responsible for determining the database access permissions, Data Confidentiality levels, and integrity constraints of each user.
(4) monitor the use and operation of databases
DBAs also has an important responsibility to monitor the operation of the database system and handle problems in a timely manner. For example, in the case of various system faults, the database may be damaged to varying degrees. The DBA must restore the database to the correct state in the shortest time, do not affect or affect the normal operation of other parts of the computer system as much as possible. Therefore, DBAs must define and implement appropriate backup and recovery policies. Such as periodically dumping data and maintaining log files.
(5) database improvement and restructuring
DBA is also responsible for monitoring system performance indicators such as space utilization and processing efficiency during system operation, recording and analyzing the running status, relying on work practices and based on the actual application environment, constantly improve the database design. Many database products provide utilities for monitoring and analyzing the database running status. DBAs can use these utilities to complete this task.
In addition, during database operation, a large amount of data is constantly inserted, deleted, and modified, which takes a long time and affects the system performance. Therefore, DBAs should regularly reorganize databases to improve system performance.
When user requirements increase and change, DBA also needs to perform major changes to the database, including Modifying part of the design, that is, rebuilding the database.