Database
administrators are the people making the strategic and policy decisions
regarding the data of the enterprise, and providing the necessary support for
implementing these decisions. In other words, they are responsible for the
overall control of the system. Let’s see what are the major functions of the
Database administrators.
Defining the conceptual schema
This includes identifying what are the entities, what are the
information to be stored in each of the entity and so on, according to the
company requirements. Here, the database is designed logically.
Defining the internal schema
In here, the database administrators have to create the
physical database design. Afterwards,
they should create the corresponding storage structure and must define
the associated mapping between internal and conceptual schema.
Linking with the users
This explains that the database administrators should check
whether the data needed by the users are available in the database.
Defining Security and integrity rules
The database administrators should define and facilitate
security features and integrity rules to make sure that the database is secured
properly.
Defining backup and recovery procedures
It
is the responsibility of the database administrators to define and implement
proper backup and recovery plan in order to minimize the data
No comments:
Post a Comment