This article throws light upon the top three functions of Data Base Administrator. The functions are: 1. Managing the Data Base Structure 2. Managing the DBMS 3. Managing Data Activities.
This responsibility centers around the design of the schema and special programs for controlling redundancy, maintaining control of change requests implementing changes in the schema and maintaining user documentation.
In the case of documentation, the DBA must know what changes have been made, how they were made and when they were made.
Data base changes must be checked by a record of test runs and test results.
Next responsibility involves the central processing unit (CPU), compiling statistics on system efficiency, including CPU times and elapsed times of inquiries. CPU time is the amount of time the CPU requires to process a request. Elapsed time is the actual clock time needed to process the activities and return a result (output)
The DBA manages data base activities by providing standards, control procedures and documentation. By this process, the DBA ensure each user’s independence from other users. Every data base record must have a standard name, format and unique strategy for access. For managing, work is done by the DBA. Standardization, though resisted by users, simplifies reporting and facilitates management control.
DBA is concerned about data access and modification deciding who has authorization to modify that data is job in itself. Locks have to be established to implement this activity. Failures recovery procedures are added concerns.
Failures may be caused by machines, media, communications or users. The user must be familiar with recovery procedure for re-inputting reports. Training users and maintaining documentation for successful recovery are important responsibilities of the DBA.
Other elements also affect DBMS. The DBA investigates user performance complaints and keeps the system’s capabilities in time with user requirements. Modifications may have to be made to the communication network, the operating system or their interfaces with the DBMS.
It is the DBAs responsibility to evaluate changes and determine their impact on the data base environment. The DBA has a full-time, highly responsible job. In addition to a managerial back ground, the DBA needs technical knowledge to deal with data base designers.