Synchronizing logical and physical models
 
Synchronization Display Options
Synchronization Display Options
"Logical to Physical" Synchronization Rules
Logical to Physical Synchronization: the Entities (or Classes)
Logical to Physical Synchronization: the Associations
Logical to Physical Synchronization: the Parts (UML)
From the Logical Model to the Physical Model
Running Synchronization (Logical > Physical)
Using Options (Logical > Physical)
Protecting Objects
Synchronization Results: Correspondences
Reduced Synchronization (Logical to physical mode)
Reduced Synchronization Source Objects (Logical > Physical)
Reduced Synchronization Strategies (Logical > Physical)
Running Reduced Synchronization (Logical > Physical)
Running Synchronization After Modifications
Synchronization after Modification of the Data Diagram
Synchronization after Modifications to the Physical Diagram
From the Physical Model to the Logical Model
"Physical to Logical" Synchronization Rules
Running Synchronization (Physical > Logical)
"Physical to Logical" Synchronization Results
Configuring Synchronization
Preparing Synchronization
Creation Options
Configuring Name Generation
Diagram Synchronization
Case of Diagram Update at Synchronization
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.