The DataBee Create/Edit All Rows Rule Form
When building target subset databases there is often a requirement to extract all of the rows from certain tables - even if those rows are not strictly required to support the extracted rows in other tables. Most databases have reference or support tables the rows of which need to be present in full in the target schema.
The Create/Edit All Rows Rule form is used to create and edit DataBee All Rows rules. All Rows rules are designed to extract all of the rows from a table.
Important Note: Great care is necessary when adding an All Rows rule to a table. If that table has dependent rules (perhaps because it is involved in foreign keys) then the extraction of all rows from the source table will cause those rules to activate. This could cause undesirable effects leading to an extraction set explosion. A far better way to add All Rows Rules to tables is to use the Safe All Rows Rule Generator Tool. See the discussion on the Safe All Rows Rule Generator tool for a detailed discussion.
Configuring the target table is a straightforward process. The Create/Edit All Rows Rule form is started by pressing the New All Rows Rule button on the New Extraction Rule form in the Set Designer application. It is not possible to create or edit All Rows rules in the Set Extractor application, although they can be viewed there. Once the Create/Edit All Rows Rule form has started, the mouse can be used to select the table from the Tables panel on the left hand side of the form. The choice of available tables is entirely determined by the Rule Controller with which the All Rows rule is associated. Only tables from within the schema for which the Rule Controller is configured will be visible. If the required tables are not visible, the schema structure can be refreshed using the Refresh Schema and Indexes button on Options tab of the edit Rule Controller form.
Once the table has been selected, the table name will be listed in the panel on the right hand side. The rule is fully configured and can be saved to the extraction set. The example screen shot above shows columns which list the source row count, extracted row count and also a column indicating how well that table matches the extraction set plan. These columns were added to the display using the Options button on the lower left hand side of the form.
All Rows rules execute in Stage 1 of the extraction process. The DataBee extraction process is multithreaded and can run multiple rules simultaneously. If necessary, (it usually isn't) the execution order of the All Rows rules can be explicitly controled by adjusting the rule block component of the rule ID number. 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.