JCC Seminar Description

Oracle Rdb databases are robust, but do require care and attention, particularly when the database plays a key role in a mission critical application. This seminar addresses the database administration issues and tools in an Rdb environment. The seminar contains the following modules:

DBA Responsibilities This seminar is organized around the various responsibilities of a Database Administrator (DBA). The first module examines these responsibilities.

Verification and Backup Among the most important of the DBA tasks are to assure the user community that the data in the database will be preserved despite system and applications failure and that data access paths to the database will be available when needed. Two basic processes are appropriate to these tasks:

1. Database verification to ensure data and database correctness
2. Database backup to ensure that the database can be reconstructed in a timely fashion.

Tuning Database tuning cannot be altogether separated from application tuning. Therefore, the DBA interested in a serious tuning effort must also be prepared to communicate to the application developers how to define the best query and navigation strategies to satisfy their requirements. In this section you will learn how to develop a physical database design oriented toward minimal system requirements, develop generalized query strategies for common queries, and develop system and database monitoring procedures for the database application. You will also discuss how to communicate with the developers on these important topics.

Security and Access Control Different applications have different needs for security and access control. However, some level of access control is a benefit in all database applications because it can be a way of preventing errors. Security and access control consist of control, monitoring, and response. In this section, you will learn how to define and implement all phases of a security model for the database.

Planning Many database applications grow over time. They increase both in the amount of data being manipulated as well as in the number of accesses made to that data, both over time and concurrently. The information necessary to develop the planning functions can be accomplished, often, in concert with other activities in the data. In this section, you will learn how to plan for the resources needed for application growth and upgrades, such as: disk and tape storage, I/O requirements, processor and memory requirements, evolution of the database, programming updates to the application, and updates to the database and operating system software.