Role of Database Administrator

[Previous] [Table of Contents] [Next]

Responsibility of DBA

1. —Schema definition:

Creation of the original database schema is accomplished by writing a set of tables.

—2. Storage Structure and access method definition:

The creation of appropriate storage structure and access method is accomplished by writing a set of definition.

—3. Schema and Physical organisation modification:

DBA involves either the modification of the database schema or the description of the physical storage organisation.

4. —Granting of authorisation for data access:

DBA allows the granting of different types of authorisation for data access to the various users of the database.

5. Integrity constraint specification:

The DBA specifies the constraints. These constraints are kept in a special system structure, the data dictionary that is consulted by the database manager prior to any data manipulation.