Functions of DBA

Functions of DBA

Functions of a Database Administrator

One of the main reasons for using DBMS is to have a central control of both data and the programs accessing those data. A person who has such control over the system is called a Database Administrator(DBA). The following are the functions of a Database administrator

  • Schema Definition
  • Storage structure and access method definition
  • Schema and physical organization modification.
  • Granting authorization for data access.
  • Routine Maintenance

Schema Definition
The Database Administrator creates the database schema by executing DDL statements.  Schema includes the logical structure of database table(Relation) like data types of attributes,length of attributes,integrity constraints etc.

Storage structure and access method definition
Database tables or indexes are stored in the following ways: Flat files,Heaps,B+ Tree etc..                                            

Schema and physical organization modification
The DBA carries out changes to the existing schema and physical organization.

Granting authorization for data access
The DBA provides different access rights to the users according to their level. Ordinary users might have highly restricted access to data, while you go up in the hierarchy to the administrator ,you will get more access rights.

Routine Maintenance
Some of the routine maintenance activities of a DBA is given below.

 Taking backup of database periodically
 Ensuring enough disk space is available all the time.
 Monitoring jobs running on the database.
 Ensure that performance is not degraded by some expensive task submitted by some users.
 Performance Tuning