ABSTRACT

This chapter discusses the roles performed by database administration, distinguishes database administration and data administration, and describes several database operation and maintenance issues. Database administration is responsible for developing a strategy for the control and use of corporate data and for developing, implementing and supporting standards, guidelines, and tools that are consistent with the strategy. The database administration group supports existing operational systems and is responsible for data integrity, security, availability, and the performance of the database management system. The management side of the database administration group is sometimes called data administration. Database administration is responsible for the error-handling routines that protect the integrity of the database. Security is a means of ensuring data integrity and protecting confidential information by controlling who has the authority to view, alter, or delete the data in a database. Concurrency issues arise when multiple users can access a database simultaneously.