The Built-in parameters node is only available in the Data Entities node. This section lists:
Summary of right hand panel options:
|Built-in types for data entities|| |
The list of built-in types for data entities is predefined by CAST. Object types that appear in this list are always considered Data Entities (e.g.: SQL Tables etc.) and have predefined Function Point values that cannot be modified. Note the following:
Generate data record object sets > See Generate sets for more information about this option.
|FK/PK analysis: table prefixes to exclude||This section allows you to define a list of prefixes that are used to name your SQL tables. Any prefix on the list will be excluded when the CAST Transaction Configuration Center algorithm attempts to detect data functions from SQL tables using Foreign key (FK) and Primary Key (PK) relationships. |
So if all or a majority of your tables use a naming convention that includes prefixes such as "T_" and "DT_" (for example), you need to add these prefixes to the list so that they are excluded and unrelated tables are not grouped together.
To add a new prefix:
|Names of tables to exclude (case insensitive regular expressions)||This section allows you to define criteria based on Regular Expressions that are used to match specific table names. All matching tables will NOT be considered Data Entities at all: |
The section will be pre-populated with rules pre-defined by CAST. These pre-defined rules target table names that should never be taken into account by the CAST Transaction Configuration Center, for example tables containing the words "temp", "session", "error" etc. This is in line with the OMG CISQ AFP Specifications.
To add a new Regular Expression:
Reset defaults > Use this button to reset the list to the rules pre-defined by CAST. Any rules you have defined yourself will be removed.
Generate excluded tables > This option will produce a list of the tables that are being excluded and not considered as Data Entities:
The Filtered By column shows whether the table is being excluded due to a default rule (LOOKUP TABLE ALGORITHM) or by a custom Regular Expression (REGULAR EXPRESSION) as shown in the image above.
By default, CAST will pre-populate the Names of tables to exclude (case insensitive regular expressions) with a set of pre-defined rules to EXCLUDE certain objects from being considered as Data Entities. These pre-defined rules are in line with the OMG CISQ AFP Specifications for Data Entities.
In addition, the OMG CISQ AFP Specifications dictate that other database tables (over and above the pre-defined rules discussed above) should NOT be considered as Data Entities. These objects are those with a lookup structure that match the following criteria:
Objects that match all of the above criteria will NOT be considered as Data Entities. This behaviour cannot be altered or overridden. This explains why some database tables are never displayed as Data Entities in the CAST Transaction Configuration Center. This behaviour can be altered in the Computation Configuration dialog - see Compute for more information.