Horizontal and Vertical Partitioning and Table Collapsing Checks (PDM)

PowerDesigner provides default model checks to verify the validity of horizontal and vertical partitioning and table collapsing objects.

Check

Description and Correction

Name/Code contains terms not in glossary

[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - None.

Name/Code contains synonyms of glossary terms

[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - Replaces synonyms with their associated glossary terms.

Name/Code uniqueness

Object names must be unique in the namespace.
  • Manual correction - Modify the duplicate name or code.
  • Automatic correction - Appends a number to the duplicate name or code.

Existence of partition

[horizontal and vertical partitionings] A partitioning object cannot be empty, it must contain at least one partition.

  • Manual correction: Delete the partitioning object or create at least one partition in its property sheet

  • Automatic correction: Deletes empty horizontal partitioning object

Existence of target table

[collapsings] A table collapsing must have a table as result of the collapsing.

  • Manual correction: Delete the table collapsing object

  • Automatic correction: None

Unavailable target table

A partition or collapsing object requires a table to act upon.

  • Manual correction: Delete the partitioning or collapsing with no corresponding table

  • Automatic correction: Deletes the partitioning or collapsing with no corresponding table