Horizontal Partitioning Checks (PDM)

PowerDesigner provides default model checks to verify the validity of horizontal partitioning objects.

Check	Description and Correction
Horizontal partitioning name and code uniqueness	Horizontal partitioning names and codes must be unique in the model. Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code
Existence of partition	A horizontal partitioning object cannot be empty, it must contain at least one partition. Manual correction: Delete the horizontal partitioning object or create at least one partition in the horizontal partitioning object property sheet Automatic correction: Deletes empty horizontal partitioning object
Unavailable target table	A partition should have a corresponding table. You could delete a table that actually corresponds to a partition, this check verifies that each partition has a corresponding table. Manual correction: Delete the partition with no corresponding table Automatic correction: Deletes the partition with no corresponding table

Check

Description and Correction

Horizontal partitioning name and code uniqueness

Horizontal partitioning names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Existence of partition

A horizontal partitioning object cannot be empty, it must contain at least one partition.

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

Automatic correction: Deletes empty horizontal partitioning object

Unavailable target table

A partition should have a corresponding table. You could delete a table that actually corresponds to a partition, this check verifies that each partition has a corresponding table.

Manual correction: Delete the partition with no corresponding table

Automatic correction: Deletes the partition with no corresponding table