During the life of a database system, the structure of the data store may be constantly modified to satisfy the changing business environment. The change is usually carried out by two persons or teams: the data modeler and the database administrator. The data modeler creates the data models which are used to create the database system. The database administrator maintains the database system and works closely with the data modeler in making changes to the database system.
The data modeler uses the workbench to update the data models. The changed data model is compared with the original source of the data model using the data object compare and synchronize functionality. The differences between the changed model and the original source are displayed in the compare editor. Before the changes are deployed, the data modeler can use the workbench to create difference reports, impact analysis reports, and change reports to help the database administrator understand the changes before the changes are deployed.