Five DBA duties
(2) the decision database storage structure and access strategy
DBA to various user applications, and database designers to jointly determine the structure of data storage and access strategies in order to obtain higher access efficiency and storage space utilization.
(3) the definition of data security requirements and the integrity constraints
DBA is to ensure that the important function of database security and integrity. DBA is responsible for determining, therefore all users have access to the database, data-level confidentiality and integrity constraints.
(4) monitor the use and operation of the database
DBA was also an important duty is to monitor the operation of database system, running in time to deal with problems arising in the course. For example, a variety of system failure, the database will therefore be subject to varying degrees of damage, DBA will be in the shortest possible time to be restored to the correct state of the database and, if possible, or less does not affect other parts of the computer system affected the normal operation. Therefore, DBA to the definition and implementation of appropriate backup and recovery strategy. Dump data, such as cyclical, such as maintenance of log files.
(5) Improvement of the database and re-reconstruction
DBA is also responsible for the system during operation of the space surveillance system utilization, performance indicators, such as efficiency of operation recorded, statistical analysis, relying on the work practice and in accordance with the actual application environment, and continuously improve the database design. Many databases are available on the status of the database is running surveillance and analysis of utility, DBA can use the utility to complete the work.
In addition, the database is running, a large amount of data constantly insert, delete, modify, over time, will affect the performance of the system. Therefore, DBA database regularly re-organization, to improve system performance.
When the user's needs increase and change, DBA also on the transformation of a larger database, including the amendment of part of the design, that is, re-structure database.
This article comes from CSDN blog, reprint, please indicate the source: http://blog.csdn.net/wzy0623/archive/2007/06/26/1666737.aspx
Related Posts of Five DBA duties
-
DBA must have the personality characteristics of
The full name of OCP is ORALCE CERTIFIED PROFESSIONAL. OCP classified into two categories, a class-oriented development, known as the DEV; A class-oriented management, known as the DBA; What is DBA Database administrator, English is the Database Admi ...
-
DBA more commonly used functions and SQL commands
1.DBA a number of responsibilities: To install and upgrade the database server (such as Oracle, Microsoft SQL server), and application tools. Database design system storage and storage needs for the future plans. Once the developer has designed an ap ...
-
Oracle system to prevent hacking of the eight common method
Oracle's sales to customers in its database system has been selling it touted as unbreakable, Shuazuipizi easily, can be realized with a not so easy. No matter what computer system, it is always possible to find a way to attack it, Oracle is no e ...
-
See the "direct search results for the empty" view
Direct access to a number of view will not return any results. There are two reasons for this situation would lead to the occurrence of: view the use of ou shielding, the client query, it is necessary to simulate the operation of the application of u ...
-
Stream the first part of (1) an overview of articles based
Jun twice found today on an article written Stream is better, so afraid of losing things, so in this archive for more of the brother of All, it's hard to think of labor drum clap! The first part (1) an overview of articles based A, Streams Overvi ...
-
Oracle database used to maintain day-to-day command
Oracle database used to maintain day-to-day command At run-time Oracle database, DBA should run the database log and table space for the use of surveillance, early detection of problems that exist in the database. One, Oracle log file monitoring warn ...
-
Block Oracle paragraph (reprint)
Starting today, begin reading the second oracle document b10743, "conceps"; do not know can give me a new harvest. The master was oracle's Michele Cyran characters written by people such as cow, a really good book. Alas English not well ...
-
High Availability Oracle Flashback
Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...
Leave a Reply