Database Reference
In-Depth Information
Database Administration
We have established the importance of a database as a valuable information resource
in the organization. This resource must be carefully administered (managed) in order
to ensure the continued operation and success of the organization. In this regard, the
database administrator is extremely important (database administrators are among
the highest paid IT professionals).
This chapter provides an overview of database administration. It discusses (from an
administrative view point) the following issues:
•
Database Installation, Creation and Configuration
•
Database Security
•
Database Management
•
Database Backup and Recovery
•
Database Tuning
•
Database Removal
•
Summary and Concluding Remarks
Please note that a solitary chapter which overviews database administration will not
make you a good database administrator (DBA). To achieve that objective, you will need
to apply the knowledge in this course, combined with additional knowledge gained from
a special course in database administration. This chapter helps to prepare you for that
vocation by providing an overview of database administration issues.
21.1 Database Installation, Creation, and
Configuration
Before any work can be done, the database software must be installed. This is usually
a straightforward, but time consuming process. For large, sophisticated products such
as Oracle and DB2, installation could get complicated, since decisions have to be made
about what components to install, where (in terms of directories or folders) to store certain
resources, and what environmental or configuration settings to choose. For simpler
products like MySQL and Delphi, the installation process is correspondingly simpler.
