The Set Extractor Rules In Set tab provides information on the rules contained in the current extraction set. Note that the Set Extractor application has no ability to save changes back to the extraction set. All updates to the extraction rules and extraction set structure must be made using the Set Designer application. The primary function of the Set Extractor application is to run the rules and, although the rules can be temporarily disabled in the Set Extractor, those changes cannot be saved back to the extraction set.

The DataBee Set Extractor Rules In Set Tab

The panel at the top of the Rules In Set tab lists the rules contained within the currently active extraction set. Be aware that the order of the rules in the display is not necessarily the order in which the rules will execute. Not only can the rules can be sorted by the various columns which dramatically changes the order presented visually on the screen but many of the rules are placed in different extraction set stages. Each stage has its own execution methodology and scheduling method. For more information on the concept of extraction set stages please see the Extraction Set Overview help file.

There are seven vertical columns in the extraction rule display. These columns provide summary information on the configuration of the rule. Double click on any rule to fully view it's contents.

What the columns in the Rules Panel mean

Rule#

This column indicates the rule block and ID number of the rule and also contains a small icon which indicates the extraction rule type.

Rule Controller

Table-To-Table rule

Cross Schema Table-To-Table rule

Where Clause rule

All Rows rule

Stage 1 Command rule

Stage 3 Command rule

For some rules, a modifier is applied to the icon to indicate how the rule was created. For example, here is the icon for an All Rows rule which was created in bulk: . Rules like this are have been created in bulk by the Safe All Rows Rule Generator or other tools found on the Rule Tools tab of the Set Designer application.

The rule block and ID number are displayed as a sequence of digits in the form XX-YYYY. The XX value is the rule block and the YYYY component is the rule ID. The ID of the rule is not particularly significant and serves only to provide a unique identification number for the rule. The rule block, however, is of considerable significance for stage 1 and stage 3 rules since it controls the execution order of the rule.

The DataBee Set Extractor software is multi-threaded and can run up to eight rules in parallel. It is frequently the case within a extraction set that some stage 1 and stage 3 rules cannot run simultaneously and must run sequentially one after the other as a chain. The rule block value controls the execution sequence. Please see the discussion of Rule Blocks in the extraction set overview help page in order to understand how to explicitly control the execution order of stage 1 and stage 3 extraction rules. Note that the extraction rules can be sorted in any order by clicking on the column headers. The presentation order on the display will not change the execution order in any way since the execution order in stages 1 and 3 is totally dependent on the rule block configuration. The rule block and the rule ID can be modified in the Set Designer application (not in the Set Extractor) by clicking it with the mouse and editing the value as appropriate.

Only Table-To-Table rules can be used as stage 2 rules and in that case a rule block of fk means the rule was derived from a foreign key and a rule block of tt indicates the rule was manually added to enforce a logical relationship. The Table-To-Table rules in stage 2 execute as required according to an internal scheduling algorythm and the rule block value cannot be adjusted for them.

Rule Type

This column contains descriptive text indicating the type of extraction rule which is represented by that line of the display.

Source

The source object for the rule. For Table-To-Table rules this is the source table in the relationship. For other rule types this column just contains some descriptive text describing the relationship.

Rel

This column describes the relationship between the source and target columns and is only used for Table-To-Table rules. The -> value can be interpreted as meaning "requires supporting rows in and extracts rows for" as in "SOURCETABLE_A requires supporting rows in, and extracts rows for TARGETTABLE_B".

Target

This column lists the table for which the rule will extract rows. For Command rules and Rule Controllers this area just contains some descriptive information describing the operation of the rule.

Description

All rule types can have an optional description associated with them. Descriptions are useful documentation which clarifies the purpose of a rule.

What the buttons do

Disable Rule

This button disables an extraction rule in the extraction set. This change is only temporary as the Set Extractor application has no way to save any changes to the extraction set on disk. All permanent updates to the extraction set must be performed by the Set Designer application.

View Rule

Launches the rule in a separate form to its contents can be viewed. Double clicking with the mouse on the rule also perform this operation.