Overview of managing changes to a database

The three most important tasks that a DBA can perform with Optim™ Database Administrator are change specification, deployment, and auditing.
The following figure depicts the sequence of steps that are required to manage changes to a database:
Figure 1. Steps required to manage changes
The steps that are required to manage changes to a database are change specification, deployment, and auditing.
Change specification
The process of defining a set of changes that you want to apply to a database. This phase involves defining the changes that you want to make, analyzing the impact of those changes, and generating the operations to implement the changes against the database.
Deployment
The process of changing the database to reflect the conditions that were specified in the change specification phase. Deployment encompasses the process of applying the changes to the actual database, and if necessary, undoing the changes.
Auditing
The process of looking back after a change is made to understand the evolution of the database model. This phase is important because the catalog reflects only the current state of a database and does not keep a record of its history. Auditing helps you keep track of who performed what actions and helps you to prevent unknown or unanticipated access to the data.

Feedback