What is the responsibility of DBA?
1. Decide the content and structure of information in the database: dba should participate in database design and cooperate with users, application programmers and system analysts. 2. Decide the storage structure and storage strategy of db: The purpose is to achieve high storage efficiency and space utilization. 3. Determine the security and integrity of data: determine the user's access rights to the database, data confidentiality level and integrity constraints. 4. In order to monitor the use and operation of db, dba should define and implement some backup and recovery strategies (periodic dumping, establishing log files, etc.). ) so that db can be restored as soon as possible when it is damaged due to system failure. 5. Improvement and reorganization of db: dba can use some applications provided by dbs to monitor and analyze db, monitor the space utilization rate and processing efficiency of DB, and analyze and record the running situation, thus improving DB design.