The DataBee Rule Information Dialog Box

The Rule Information dialog box is designed to provide additional information about a rule in an Extraction Set.

The Rules of Type "T" Panel

This panel gives a quick indication of the tables involved in a Table-To-Table rule and the column join conditions between them. This area is just a summary version of the detailed information presented on the Rules in Set Tab of the Set Extractor application.

This panel provides information on the table involved in a WHERE Clause type rule and the extract condition associated with it. The information is presented as a pseudo SQL statement illustrating the effect of the WHERE Clause.

Extraction Sets are simple text files. This panel shows the original line from the Extraction Set file that generated the rule.

What the fields mean

Rule #

This field shows the Rule number. The rule number 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.

Rule Type

This field will be a "T" or a "W" which indicates if the rule is a Table-To-Table rule or a WHERE Clause rule.

Ext. Rows Count

This field shows the number of rows which each rule has extracted. This figure is current as of the time the dialog box started. 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.

Src. Rows Count

This field shows the total number of source rows in the target table of the rule (the one pointed at by the -> symbol).

Rows/Sec column

The Set Extractor repeatedly processes each rule in an iterative manner. This column shows the 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 Advanced Rule Information button to obtain further information on the rule.

Seconds Active

This field indicates the total cumulative time (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.

Passes column

The Set Extractor repeatedly processes each rule in an iterative manner. This field 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.

Limit

WHERE Clause rules can have upper limits placed on the number of rows they will retrieve. This field displays that limit (if it exists).

Sample

WHERE Clause rules can sample a percentage the number of returning rows and discard the remainder. This field displays the percentage of the returned rows that are accepted (if it exists).