Database Reference
In-Depth Information
are not primary responsibilities. The DBA gets the technical work done. The DBA's
role of getting down to technical details is evident throughout the development and
implementation of the database system.
Typical functions for the database administration role are as follows:
•
Participate in the selection of the DBMS.
•
Define requirements for hardware and system software upgrades to accom-
modate the new database.
•
Work with the DA on data standards to conform to the provisions in the target
DBMS.
•
Perform physical design of the database system.
•
Liaise with the database vendor and install the DBMS.
•
Set up data dictionary entries in coordination with the DA.
•
Create user accounts and maintain data access authorizations.
•
Manage database backup and recovery.
•
Monitor and tune database performance.
•
Coordinate with the database vendor and plan for upgrades.
•
Provide DBMS-specific information to analysts and database designers.
SKILLS AND RESPONSIBILITIES
You have grasped the significance of the administration functions in a database
environment. You have understood why these functions are absolutely essential not
only to initiate a database system but also to keep it going in an organization. We
reviewed the broad objectives of administration. You have also learned the essen-
tial difference between data administration and database administration. Because
of the enormous importance of administration functions in a database environment,
let us focus on these from slightly different perspectives.
You have noted the need for a DA and also for a DBA. How are they different,
and why do you need both roles? What specific roles do these two types of admin-
istrators assume in a database environment? What major responsibilities do the DA
and DBA fulfill?
By now you must assume that, given the significance and specialty of data admin-
istration and database administration functions, the DA and DBA have to be given
specialized training and must acquire extraordinary skills. It is true that these pro-
fessionals must possess specialized knowledge and have expertise in management
and technical areas. We will elaborate on these as we proceed.
Administrative Roles
As you must have understood by now, the administrative roles assumed by the DA
are more pronounced in the earlier stages of the database development life cycle.
The early phases need a corporate-wide view of the organization's data, more
intense planning, and coordination among the various departments who intend to
be benefited by the database. On the other hand, the administrative roles of the
Search WWH ::
Custom Search