Database Reference
In-Depth Information
companies have only database administrators, who perform most of the data admin-
istration functions as well. Analysts and project leaders pitch in and perform any
remaining data administration functions.
In the following subsections, we will explore the nature of data administration
and database administration functions. For the rest of this chapter, even though we
discuss these two functions separately, remember that in many organizations you
will only find DBAs and no group designated as data administrators (DAs).
Although in these organizations the functions are combined as the responsibility of
DBAs, for the purpose of our discussions, it is worthwhile to consider the functions
separately. In this way, our discussions will be complete.
Data Administration
As already mentioned, data administration is more of a managerial function to
manage and control the database environment. The DA practices all the key
elements of management in his or her involvement in the database environment—
planning, coordination, execution, control, and communication. The DA is generally
responsible for policies and procedures. The DA is like a custodian of corporate
data resource. He or she is intimately involved in planning the various aspects of
the database environment.
In some large enterprises, a group of professionals form the data administration
group. The group—not a single individual—assumes the data administration role.
Nevertheless, whether a single individual or a group has the responsibility for data
administration, the role is still the same and the same tasks are performed.
Here is a typical list of functions of data administration:
•
Establish corporate-wide data requirements.
•
Ascertain future requirements.
•
Communicate with users on data ownership and data control policies.
•
Set up centralized control over the data resource.
•
Play a leading role in planning for the database system—what data to collect,
how to store data, and how to promote data usage.
•
Plan for hardware and system software upgrades to support the new database
system.
•
Organize education for users on database technology and its great advantages.
•
Establish realistic expectations and set guidelines to measure user satisfaction.
•
Standardize data names, data types, and definitions for universal use.
•
Establish standards and procedures for data integrity.
•
Institute data security policy.
•
Constantly communicate with IT management, corporate management, user
departments, the DBA, and other IT professionals on plans, policies, and
procedures.
Database Administration
The database administration role comprises a different set of responsibilities.
Although the DBA participates in database planning, coordination and planning
Search WWH ::
Custom Search