ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Editors / Data model editor / Conceptual Data Model
  • Overview
  • Generating the CDM
  • Special case: Updating an existing LDM
  • Remarks
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
To associate a CDM (Conceptual Data Model) with a project, you must generate the associated LDM (Logical Data Model). In fact, it is the MLD that is associated with the project and not the MCD.
Generating the CDM enables you to automatically create the corresponding LDM after checking the validity of the CDM .
Generating the CDM
To generate the LDM from the CDM:
  1. On the "CDM" tab, in the "Analysis" group, click "Generate logical model".
  2. Define the parameters for generating the LDM from the CDM:
    • the name and path of the generated LDM. The LDM corresponds to a ".WDA" file. By default, this file will be created in the directory of the project analysis (<Project name>.ANA directory). This directory must be accessible in read/write mode.
    • In the "Generation" tab:
      • if the labels of associations without properties (from the MCD) are retained to identify MLD links.
      • if the analysis logic model needs to be reset.
    • In the "Data files" tab, the options for generating the data files created:
      • the type of access to the data files. Depending on the type chosen, data files will be handled by the WINDEV engine, by an OLEDB driver or by one of WINDEV's native Connectors, WEBDEV and WINDEV Mobile (SQL Server, Oracle, etc.).
      • the data files access type used.
  3. Validate the generation. The LDM corresponding to the CDM is automatically created.
Special case: Updating an existing LDM
If the name and path of the LDM specified when generating the CDM correspond to an existing LDM, the existing LDM will be updated with the new description of the CDM.
When updating an existing LDM, the generation checks:
  1. The existence of the entity in the LDM:
    • if the entity is new, the corresponding data file is created.
    • if the entity already exists, its properties are updated.
  2. The existence of the properties in the LDM:
    • if the property is a new one, the corresponding item is created.
    • if the property already exists, with the same description, no action is performed.
    • if the property already exists, with a different description, a conflict occurs. The data model editor proposes:
      • to ignore the new description of the property and to perform no modification.
      • to update the existing item with the new description of the property.
      • to create a new description synonym with the new description of the property.
  3. The existence of relationships and associations. When the association requires the creation of one or more relationship files, the data files and LDM fields are updated as described above. When a relationship has been modified, the LDM link is recreated or updated:
    • if the identifying properties of one of the entities have been modified, the cardinality of the existing links are updated and new links are created.
    • if no identifying property of one of the entities was modified, the cardinalities are updated.

Remarks

  • Deleting entities, relationships or associations is not taken into account when generating the MCD in LDM.
  • The deletion of entity properties can be taken into account by checking the "Reinitialize LDM of analysis" option in the LDM MCD generation options. In this case, the files of the LDM only contain the items of the corresponding entity in the CDM after the conversion.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/11/2025

Send a report | Local help