Database Reference
In-Depth Information
TECHNICAL FUNCTIONS
The DBA is also responsible for database design, testing, and performance tuning.
Database Design
The DBA establishes a sound methodology for database design, such as the one discussed in Chapter 6, and
ensures that all database designers follow the methodology. The DBA also verifies that the designers obtain all
pertinent information from the appropriate users. After the database designers complete the information-level
design, the DBA does the physical-level design.
The DBA establishes documentation standards for all the steps in the database design process. The DBA
also makes sure that these standards are followed, that the documentation is kept up to date, and that the
appropriate personnel have access to the documentation they need.
Requirements don
269
t remain stable over time; they change constantly. The DBA reviews all changes to
requirements and determines whether the changes will require that modifications be made to the database.
If so, the DBA makes the changes in the design and in the data in the database. The DBA also verifies that
programmers modify all programs and documentation affected by the change.
'
Testing
The hardware, software, and database for the users is called the production system,orlive system. The DBA
strictly controls the production system. With just two exceptions, the DBA grants access and update privileges
to the production system only to authorized users. The first exception is when problems occur, for example,
with software. The DBA and others must troubleshoot the problem by accessing the production system. The
second exception is when programmers complete new programs or modify existing programs for the produc-
tion system. For both exceptions, the DBA performs any necessary database modifications or closely controls
the activities of others.
Other than for these two exceptions, the DBA does not grant programmers access to the production sys-
tem. Instead, the DBA and the programmers create a separate system, called the test system,orsandbox, that
programmers use to develop new programs and modify existing programs. After programmers complete the
testing of their programs in the test system, a separate quality assurance group performs futher tests, the DBA
and the users review and approve the test results, and the DBA reviews and approves the programs and docu-
mentation. The DBA then notifies all affected users when the new or corrected features will be available. The
DBA then transfers the programs to the production system and makes any required database changes, as
shown in Figure 8-9.
