Database Administrator (DBA)

Submitted by inder on Fri, 16/01/2009 - 11:18.

Scheme definition: the creation of the original database scheme. This involves writing a set of definitions in a DDL (data storage and definition language), compiled by the DDL compiler into a set of tables stored in the data dictionary.
Storage structure and access method definition: writing a set of definitions translated by the data storage and definition language compiler
Scheme and physical organization modification: writing a set of definitions used by the DDL compiler to generate modifications to appropriate internal system tables (e.g. data dictionary). This is done rarely, but sometimes the database scheme or physical organization must be modified.
Granting of authorization for data access: granting different types of authorization for data access to various users
Integrity constraint specification: generating integrity constraints. These are consulted by the database manager module whenever updates occur.