Database Reference
In-Depth Information
us consider answers to broader questions. What are the responsibilities of the DA?
What responsibilities fall under the DBA's jurisdiction? We will consider how the
DA and DBA share the responsibilities for achieving the major goals of adminis-
tration. For these major goals, let us demarcate the areas of responsibility.
Data Administrator
Information requirements. Coordinate requirements gathering activities. Liaise
with user departments to analyze business needs and determine the information
requirements, current and future. Develop an enterprise-wide overall data model.
Determine information types and content to be included in the database
system.
Data integration and design. Identify and reduce data redundancy among various
departments. Define data names, types, and formats; establish standards. Approve
all modifications to data characteristics. Coordinate preparation for data dictionary
entries. Estimate current and future data volumes. Review logical design and ensure
that all requirements are included.
Information framework. Plan for database environment. Review feasibility studies.
Coordinate determination of hardware and system software upgrades. Coordinate
selection of any productivity software for administration, data definitions, data
design, and performance monitoring. Participate in selection of DBMS.
Physical implementation. No direct responsibility for physical design or DBMS
installation. Ensure that all of the original information requirements are included
in the final database system. Oversee verification of file conversions for initial pop-
ulation of database. Coordinate user training.
Data quality. Establish data quality standards. Coordinate with users on quality
assurance practices. Define data ownership and responsibilities of user departments.
Determine edits and constraints to be included in database system.
Data security. Establish security policy and procedures. Ensure that legal security
and privacy requirements are satisfied.
Data availability. Liaise with users on usage and requirements for database avail-
ability; work out details of scheduled database maintenance with users and get their
cooperation.
Data system performance. Establish database performance levels based on user
expectations.
Database Administrator
Information requirements. No direct responsibility. Provide file layouts and data
definitions from current data systems to DA and other interested professionals on
the project team.
Search WWH ::




Custom Search