The DataBee Set Extractor Rule Statistics Tab

The panel at the top of the Rule Statistics tab lists the rules contained within the currently loaded Extraction Set. Selecting a rule with the mouse will make the rule number appear in the field at the bottom of the screen. The panel is divided up into three vertical columns. These columns provide specific information on various components of the rule. Clicking on the column heading sorts the display based on the information in that column.

What the columns in the Rule Statistics Panel mean

Rule # column

This column shows the number of the rule and also contains a small icon which serves to indicate whether the rule is a Table-To-Table rule , a cross schema Table-To-Table rule or a WHERE Clause rule. It is important to note that the rule number also provides useful information as it indicates where the rule came from.

00001-02999 - given to rules derived from integrity constraints on the database.

03000-03499 - given to rules derived from generated reverse tails rules.

03500-03999 - given to manually added Table-To-Table rules.

04000-04999 - given to manually added WHERE Clause rules.

05000+ - given to rules added by the Bulk Rule Generator.

Rows column

This column shows the number of rows which each rule has extracted. This figure will be continuously updated as the extract progresses. Do not be alarmed if the number of rows for a rule exceeds the number of rows in the table as seen on the Table Statistics Tab, as duplicates are quite common.

Rows/Sec column

This column shows the average number of rows retrieved per second. A very slow speed usually indicates that either one or both tables involved in the rule need to be analyzed in the Oracle schema. Use the Rule Information button to obtain further information on the rule.

Passes column

The Set Extractor repeatedly processes each rule in an iterative manner. This column shows the number times the rule has been processed. Rules are processed as often as required. It is common and normal for the number of passes required to differ from rule to rule.

Sec. Active

This field indicates the total cumulative time in seconds (across all passes) that a rule has been active. This field is useful as it can identify rules which access tables which are slow to extract. A value of >1 means the rule has been active for less than 1 second.

What the buttons do

Rule Information

The Rule Information button starts a dialog box that provides more detailed information on the Rule and its statistics. Please see the Rule Information dialog box help for more specific information.

Set Hint

Oracle SQL hints can be used to improve the extraction performance of a rule. Usually the best way to make sure the performance is optimised is to ensure all tables have up-to-date statistics. More information on applying SQL hints to DataBee Extraction Rules can be found in the Rule Hints dialog box help file.

Note: Any hints entered from within the Set Extractor application are temporary. They will not be saved after the application shuts down or an Extraction Set is loaded or re-loaded. In order to permanently apply a hint to a rule use the Set Hint button on the Set Designer Set Rules tab.