
Database Administrator by anil nain 9416077273
One of the main reasons for using DBMS is to have central control of both the data and the processes that access those data. The person who has such central control over the system is called the database administrator (DBA). The functions of the DBA include the following:
· Schema Definition: The DBA creates the original database schema by writing a set of definitions that is translated by the DDL (Data Defn. Lang.) Compiler to a set of tables that is store permanently in the data dictionary.
· Storage Structure and Access-Method Definition: The DBA creates appropriate storage structures and access methods by writing a set of definitions, which are translated by the DDL compiler.
· Schema and Physical-Organisation Modification: Programmers accomplish the relatively rare modifications either to the database schema or to the description of the physical storage organisation. By writing a set of definitions that is used by either the DDL compiler or the data-storage and data defn. language compilers to generate modifications to the appropriate intend system-tables (for example, the data dictionary).
· Growing of Authorisation for Data Access: The granting of different types of authorisation allows the DBA to regulate the parts of the database, which various users can access.
· Integrity-Constraint Specification: The data values stored in the database must satisfy certain consistency constraints e.g., perhaps the number of hours an employee may work in 1 week may not exceed a specified limit .
Database Administrator by anil nain 9416077273