Databases Reference
In-Depth Information
INTRODUCTION
Administration includes a set of critical responsibilities that begin with data-
base planning and continue as long as the database is in use. Considering the
importance of the data contained in corporate databases, administration is def-
initely not an area to shortchange. In this chapter, we'll look at justifying
administration roles, identify the two basic administration roles and responsi-
bilities related to each, and talk a little about guidelines for performing admin-
istration tasks.
9.1 Understanding the Need for Administration
Administrative tasks touch on every aspect of database implementation and use.
There are administrative requirements throughout the life cycle of a database
application, though the specifics change depending on where you are in the
cycle. To understand the requirements, it helps to understand the basic life cycle
(Figure 9-1).
Figure 9-1
Design
Data analysis, database
design and application
design and testing
Implementation
Database deployment
and baseline monitoring
Production
Day-to-day use and
ongoing maintenance
Retirement
Replacement or migration
and archiving
Database application life cycle.
