Annotating an association
Tagged values on an
association
The tagged
values used to annotate associations are presented in the following table:
|
The ... tagged value |
Role |
SQL |
|
{external} |
Indicates that the association should be managed by a specific table,
whatever its multiplicity. |
|
|
{cluster(cluster_name)} |
Links the table to a predefined cluster. |
CLUSTER |
|
{tablespace(tablespace_name)} |
Indicates the name of the "tablespace" for Oracle or
the name of the "segment" for Sybase, used during table
creation. |
TABLESPACE (Oracle) SEGMENT (Sybase) |
|
{partition(partition_name)} |
Used to parameterize the physical model table, which manages this
external association. |
|
|
{pctfree(value)} |
Used to parameterize the physical model table, which manages this
external association. |
PCTFREE |
|
{pctused(value)} |
Used to parameterize the physical model table, which manages this
external association. |
PCTUSED |
|
{initrans(value)} |
Used to parameterize the physical model table, which manages this
external association. |
INITRANS |
|
{maxtrans(value)} |
Used to parameterize the physical model table, which manages this
external association. |
MAXTRANS |
|
{storage(value)} |
Used to parameterize the physical model table, which manages this
external association. |
STORAGE |
|
{maxRowsPerPage(value)} |
Used to parameterize the physical model table, which manages this
external association. |
|
|
{fillfactor(value)} |
Used to parameterize the physical model table, which manages this
external association. |
|
The {external}
tagged value
The {external}
tagged value is used to force the creation of an external
table, and applies to those associations normally included (in other words,
whose maximum multiplicity is 1).
In the SQL tab
of the auxiliary window, the {external} tagged value is represented by the
"External association" tickbox.
This can be modified from the association itself but also from its
roles.
Note: For an association with "*-*" multiplicity, the "External association" tickbox is checked by default, although the association does not have the {external} tagged value. This graphic particularity is intended to inform the user that the association will generate an intermediary table. In order to modify the state of the graphic object, one of the association's roles must have a maximum multiplicity of 1.
The {cluster}
tagged value
The {cluster}
tagged value is used to link the table to a predefined
cluster.
The {tablespace}
tagged value
The {tablespace}
tagged value is used to specify the logical storage unit of
the data.
The {partition}
tagged value
The {partition}
tagged value is used to specify the number of pages linked
together in the table.
The {pctfree}
tagged value
The {pctfree}
tagged value is used to change the table's characteristics.
The {pctused}
tagged value
The {pctused}
tagged value is used to change the table's characteristics.
The {initrans}
tagged value
The {initrans}
tagged value is used to change the table's characteristics.
The {maxtrans}
tagged value
The {maxtrans}
tagged value is used to change the table's characteristics.
The {storage}
tagged value
The {storage}
tagged value is used to change the table's characteristics.
The
{maxRowsPerPage} tagged value
The
{maxRowsPerPage} tagged value is used to specify the maximum number of
tuples per page.
The {fillfactor}
tagged value
The {fillfactor}
tagged value is used to specify the percentage of pages
taken up by the index.