Synchronizing logical and physical models
Synchronization is a process that translates a class diagram expressed in classes/parts formalism to a physical model expressed in relational formalism, and vice-versa. It therefore ensures correspondence of objects in the two models.
+ A compatibility option enables to synchronize a data model (entities/associations) and a physical model. See Logical Formalism and Synchronization.
The procedure should be carried out periodically. Throughout the modeling project, these models are each subject to their particular changes. Synchronization intervenes when we wish to compare the two models and automatically restore canonical mappings that connect them.
The synchronization functionality is available with "Advanced" access to the HOPEX repository.
Synchronization of models of a database can be in one direction or another - either in physical > logical direction or in logical > physical direction, but not both at the same time. When synchronization direction has been determined, synchronization should not be reversed. Mapping justification between the logical and physical levels is not guaranteed if this rule is not followed.Synchronization Display Options
Certain synchronization options are filtered by default. To display these:
1. Click Main Menu > Settings > Options.
2. In the Options tree in the left pane, unfold the HOPEX Solutions > Information Architecture folder.
3. Click the Database synchronization sub-folder.
4. In the right pane, check the desired synchronization options:
• Synchronization (Logical to Physical)
• Synchronization (Physical to Logical)
• Reduced synchronization (Logical to Physical)
• Reduced synchronization (Physical to Logical)
Note that the UML notation is applied by default in the synchronization. See Formalisms.