The DataBee Set Designer Set Rules Tab

The panel at the top of the Set Rules Tab lists the rules contained within the currently active Extraction Set. Selecting the rule with the mouse will make additional information appear in the fields at the bottom of the screen. The panel is divided up into six vertical columns. These columns provide specific information on various components of the rule.

What the columns in the Rules Panel mean

Rule Number (#)

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.

User column

A DataBee Extraction Set can list rules for more than one source schema. This column lists the owner of the table referred to in the following column.

Table column

This column lists the table names associated with the rule. Each Table-to-Table style rule requires two tables. A WHERE Clause type rule only requires a single table.

Relationship column

This column shows the relationship between the tables listed in the rule. In general, the direction of the arrow indicates the relationship. For example a relationship of A -> B indicates that A is the Parent table and B is the Child table. In other words it means that "for every row in A get every matching row in table B based on the join conditions".

What the buttons do

New Rule

The New Rule button starts a dialog box which offers the option of creating a new WHERE Clause rule or a new Table-To-Table rule.

Edit Rule

The Edit Rule button will start a dialog box appropriate to the editing of the rule type. This feature allows minor changes to be made to the rule without the need to drop and re-create it.

Clone Rule

This button starts a dialog box similar to that of the Edit Rule button. However, before offering the option of editing, it creates a new rule from the contents of the old. This feature allows most of the contents of an existing rule to be used in a new rule without the necessity of re-entering all of the information.

Bulk Rule

This button starts a dialog box which can create multiple rules using the selected rule as a template. The type of the selected template rule (WHERE or Table-To-Table) determines whether the Bulk WHERE Rule or Bulk Table-To-Table Rule Dialog box is started.

Delete Rule

This button drops a rule from the Extraction Set.

Disable Rule

This button stops the DataBee Set Extractor application from using the rule when it extracts data from the Source Oracle database.

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.

The central two rows of six fields are used for the column join conditions for the rule. Each rule can join on a maximum number of six conditions. Above the join condition fields is an icon containing a large letter I. A green icon indicates that the columns present are indexed, a red icon indicates that the columns are not indexed. If the table is large it is very important that the join columns of the child table in the relationship are indexed otherwise the extract of the rows will be very slow for that rule. More information about this topic can be found on the Unindexed Rules Detector dialog box help page.

Successive clicks with the mouse on the Collapse Button button collapses or expands all information on display under each schema. This provides a useful way to present or hide the information below all schemas simultaneously without the necessity of clicking on each schema individually.

By default, the rule display lists the rules by parent table owner. Pressing the Invert Display button will change the view to list the rules by child table owner. This option will only make a difference to the visual display if you have cross schema rules.