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 loaded 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 (#) 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.

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 "for every row in A get every matching row in table B based on the join conditions".

What the buttons do

Get Rule Info

This button launches the Rule Information dialog box which provides detailed information on the extraction rule.

Disable Rule

This button stops the DataBee Set Extractor from using the rule when it extracts data from the Source Oracle database. Any rules disabled in the Set Extractor will not be remembered if the Extraction Set is reloaded or the application is shutdown and restarted. In order to permanently disable a rule mark it disabled using the Set Rules Tab in the Set Designer application.

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. Any hints applied in the Set Extractor application will not be remembered if the Extraction Set is reloaded or the application is shutdown and restarted. In order to permanently apply a hint use the Set Hint button in the Set Rules Tab in the Set Designer application.

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.

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.