DBA (DataBase Administrator)

DBA (Database Administrator)

One of the main reasons for using DBMS to having central control of both the data and the programs that access  the data , the person who has such central control  over the system is called the database administrator (DBA) . The functions of DBA  as follows

Schema Definition: The DBA creates the original database schema   by writing a set of Definitions that are translated by the compiler to a set of tables that are stored in permanently in the data dictionary.

Storage structure and access method definition: The DBA creates appropriate storage structures to access methods by writing  a set definitions by translated these are to data storage and data definition language compiler.

Schema physical organization modification: programmers accomplish the relatively rare modifications either to the data schema or to the description of the physical storage structure . Organization writing a set of definitions that are used either the DDL compiler or the data storage and data definition language compiler to generate modifications to the appropriate internal system table.

Granting of authorization for data access: The granting of different types of authorization allows the DBMS administrators to regulate which parts of the database various users can access the authorization  information is kept in a separate structure that is consulted by  the database systems when ever access to the user data is attempt in the system.

 Integrity constraints specification: The   data value stored in the database must satisfied certain consistency constraints . The integrity constraints are must specify external system of DBA. These are kept in a special system structure that is consulted by database system when ever update in the  system.

DBA Goals:

Protecting  the database from unauthorized users and also to handle total data from the table  in this way the DBA has two types of goals. These are

Integrity : It is considered with making certain operations which are performed by the users or correct and maintain the data consistency in these ways the DBA should be maintained  a key values to the related table.

 Security: It is considered with limiting users to performing only  certain operations that are allowed the DBA should provide security for data accessing from the database.