Partition schemes

Chapter 12 DBMS-Specific Features

Partition schemes

A partition scheme maps the partitions produced by a partition function to a set of user-defined filegroups. PowerDesigner models partition schemes as extended objects with a stereotype of <<PartitionScheme>>.

Creating a partition scheme

You can create a partition scheme in any of the following ways:

Select Model→Partition Schemes to access the List of Partition Schemes, and click the Add a Row tool.
Right-click the model or package in the Browser, and select New→Partition Scheme.

Partition scheme properties

You can modify an object's properties from its property sheet. To open a partition scheme property sheet, double-click its diagram symbol or its Browser entry in the Partition Schemes folder.

The following extended attributes are available on the Microsoft tab:

Name	Description
Partition Function	Specifies the partition function using the scheme. Partitions created by the partition function are mapped to the filegroups specified in the partition scheme. Scripting name: PartitionFunction
All Partitions	Specifies that all partitions map to the filegroup specified by the File Groups property. Scripting name: AllPartitions
File Groups	Specifies the names of the filegroups to hold the partitions specified by the partition function. If [PRIMARY] is specified, the partition is stored on the primary filegroup. If ALL is specified, only one filegroup name can be specified. Scripting name: Filegroups