Database administrator - schema definition and functions

It is one of the important and the main reason for containing database management system (DBMS) is to have take control of the both data and programs that accessing

That database administrator (DBA).the DBA administers and the three levels of the database (The three level architects) and in discussion with the overall

The user group sets up the alternative of the global view or conceptual level of the database.

Here below are the discussions about the functions of the Database administrator:

Schema definition:

The development of the real database schema is achieved by writing a set of definitions, which are converted by Data definition language (ddi) complier to a set of tags that are stored in the data dictionary for permanently.

Storage method and access method definition:

The development of the suitable storage shape and entrance method this is achieved by compositions a set of definition, which are converted by the data storage and definition language compiler

Schema and physical organization modification:

One of the changes in the database schema or the description of the physical storage organization.

These are some changes that are very rare and unique and are achieved by compositions a set of alternative which are used by one of the data definition languages complier or the data storage and ddl complier to produce changes to the suitable internal system tables like data dictionaries.

Granting of authorization for data access:

It grants data access to the various types of database user by the different types of authorization to it and are useful in data administration system

Integrity constraint specification:

These limitations are kept in a very important system  formation that is seek by the database manager whenever it comes to one of the expensive tools that the DBA uses to transport out data administration in data dictionary