Tablespace and Storage Properties

To view or edit a tablespace or storage's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

The General tab contains the following properties:
Property Description

Name/Code/Comment

Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

Stereotype

Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file.

Keywords

Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

Cost tab

The Cost tab is available if data lifecycle modeling (see Lifecycles (PDM)) is supported by your DBMS.

Property

Description

Cost (per GB)

Specifies the cost per GB of the storage represented by the tablespace

Currency

Displays the currency to use for the cost per GB of storage. You can change the currency by selecting Tools > Model Options and choosing a currency from the list on the Model Settings page.

Other tabs

The following tabs are also available:

  • Physical Options - lists all the physical options that can be applied to the tablespace or storage (see Physical Options).

  • Physical Options (Common) - lists the most commonly used physical options that can be applied to the tablespace or storage.

Note: For detailed information about tablespace and storage options for a particular DBMS, see its reference manual.