Partition schemes

Chapter 15 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→PartitionScheme Objects to access the List of PartitionSchemes, and click the Add a Row tool
Right-click the model or package in the Browser, and select New→PartitionScheme

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 PartitionScheme Objects folder.

The following extended attributes are available on the Microsoft tab:

Name	Scripting Name	Description
Partition Function	PartitionFunction	Specifies the partition function using the scheme. Partitions created by the partition function are mapped to the filegroups specified in the partition scheme.
All Partitions	AllPartitions	Specifies that all partitions map to the filegroup specified by the File Groups property.
File Groups	Filegroups	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.