For each relationship definition you create, Relationship Designer Express maintains advanced settings that affect the storage and processing of the relationship instance data.
To view or change the settings, select Advanced Settings from the Edit menu. In the Advanced Settings dialog, the settings that appear on the right side differ depending on which of the following items you have selected on the left:
To view or change the settings for a relationship definition, select the
relationship name. The following illustration shows an example of the
advanced settings at this level:
Figure 96. Advanced settings for a relationship definition
Table 67 summarizes the settings available for relationship
definitions. Default values for the DBMS settings come from the Global
Default Settings dialog box described in "Global default settings":
Table 67. Summary of advanced settings for relationship definitions
Setting | Description | |
---|---|---|
Relationship type |
| |
| Identity | When this option is enabled, relationship is an identity relationship. For more information, see "Defining identity relationships". |
| Static | When this option is enabled, relationship is a static relationship. For more information, see "Defining lookup relationships". |
| Cached | When the Static field is enabled, this field is enabled. Check this field to have the relationship tables cached in memory. For more information, see "Optimizing a relationship". |
Version | This field is read-only. Versions for relationship definitions are not supported in this release. | |
DBMS Settings |
| |
| URL | The JDBC path where the relationship tables for this relationship definition are located. The default location for all relationship tables is specified in Global Default Settings (see "Global default settings"). |
| Login | The user name for logging in to the relationship database. |
| Password | The password for logging in to the relationship database. |
| Type | The relationship database type, such as SQL Server or DB2. |
To view or change the settings for participant definitions, select the
participant definition name. The following illustration shows an
example of the advanced settings at this level:
Figure 97. Advanced settings for a participant definition
Table 68 summarizes the settings available for participant
definitions.
Table 68. Summary of advanced settings for participant definitions
To view or change the advanced settings for an attribute, select the
attribute. The following illustration shows an example of the advanced
settings:
Figure 98. Advanced settings for attributes
For attributes, the only setting available is the attribute column name. The column name is the name of the column in the relationship table that contains the values for the selected attribute. It is typically the same as the attribute name. You might want to change the column name if you are using tables you created instead of the default tables that the Relationship Designer Express creates.
When you save a new relationship definition and create the relationship table schemas, Relationship Designer Express must know the location of the database for the relationship tables, the type of database, and how to access the database with a valid user name and password. Relationship Designer Express maintains default values for these settings, which it uses for all new relationship definitions you create. Once a relationship definition is created, these settings are stored with the relationship definition, and you can change the settings for each relationship definition individually.
By default, the database name and access information is the same one used by the InterChange Server Express repository. If you want to store your relationship tables in another location, you can modify the global settings.
To view or change the global default settings, perform the following steps:
Result: The
Global Default Settings dialog box appears.
Figure 99. Global Default Settings dialog
Table 69 describes the global default settings for
relationships.
Table 69. Relationship global default settings