Operating the DBMS Utilities and Applications ?

DBMS operations can be divided in to four main areas. System support Performance monitoring & tuning Back up & recovery Security auditing & monitoring

1. System support : cover all tasks directly related to the day – to – day operations of DBMS & its applications. Those activities are 1.  filling out – job logs 2. changing tape & verifying status of computer hardware 3. Disk packages, power sources.

2. performance monitoring & Tuning :

This  require DBA attention & time.

To carry out the performance monitoring & tuning takes the DBA must. Establish DBMS performance goals. Monitor the DBMS performance Isolate the problem & find solution Implement performance solution.

In performance monitoring DBA also consider storage resources in terms of primary & secondary memory storage parameters can be used to determine.

The amount of primary memory assigned to each data base.

Performance monitoring issues are DBMS specific.

3. Backup & recovery :  There are primary concern during the DBMS operation.

Backup frequency is dependent on the application type & on the relative importance of the data.

Back up’s may be incremental  (or) full.

4. Security auditing & monitoring :

It assigns access rights & proper use of data by programmers & end users.

This step involves, creating users, assigning access rights, like grant & revoke in SQL provide security violations

5. Training & supporting users: DBA provides or secures technical training in the use of the DBMS for the application programmers.

Application programmers training covers the use of DBMS tools as well as the producers & standards required for data base programming.

Support is provided by interaction with DBMS vendors establish good relation ship with software supplies. 6. Maintaining the DBMS utilities and applications : Maintenance activities of the DBA are an extension of the operational activities. Maintenance include management of the physical & secondary storage devices.