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
- 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.