The Rule Report Dialog Box

The Set Designer Rule Report dialog box is designed to write out to a file the rule relationships displayed on the Set Designer Rules tab. A rule report can be used as a printed reference when designing a set and are also useful as permanent documentation of the schema and table relationships.

What the options mean

Sort by Parent

The rule report will be sorted alphabetically by the parent table name in the rule.

Sort by Child

The rule report will be sorted alphabetically by the child table name in the rule.

Sort by RuleID

Sort the output by RuleID. The RuleID is an arbitrary number given to each rule as it is entered.

Mark rules in which columns are indexed

The rule report contains a list of all columns associated with the rule. If this option is checked, the rule columns will be checked against the schema indexes and each side of the rule will be marked to indicate if the rule columns are indexed. In general, it is important for performance reasons to have indexes on the columns used on the child side of the rule relationship.

Include WHERE rules

If checked, this option will include pseudo code documenting the WHERE clause extraction rules.

Rule Report Sample

 DATABEE SET RULES REPORT

 DataBee Version:      v03.00 beta 10
 Report Written:       Wed 19 Mar 2003, 09:05
 Extraction Set:       C:\Program Files\DataBee\DataBee Extraction Sets\sampleX.set
 Schema File:          samplex.schema
 Row Count File:       samplex.rowcount


#######
####### User: SRC_BILL
#######

0001  SRC_BILL.DTB_INVOICE -> SRC_BILL.DTB_DISCOUNT
              DISCOUNT_ID  --  DISCOUNT_ID
              (Un-Indexed) -- (Is-Indexed)

0002  SRC_BILL.DTB_INVOICE -> SRC_BILL.DTB_INVOICE_STATUS
          INV_STATUS_CODE  --  INV_STATUS_CODE
              (Un-Indexed) -- (Is-Indexed)

3500  SRC_BILL.DTB_INVOICE -> SRC_BILL.DTB_INVOICE_LINE
           INVOICE_NUMBER  --  INVOICE_NUMBER
              (Is-Indexed) -- (Un-Indexed)

4000  SRC_BILL.DTB_INVOICE -> SELECT  FROM SRC_BILL.DTB_INVOICE DTB1   [ limit=, sample=25% ]

0003  SRC_BILL.DTB_INVOICE_LINE -> SRC_BILL.DTB_INVOICE
                INVOICE_NUMBER  --  INVOICE_NUMBER
                   (Un-Indexed) -- (Is-Indexed)

0004  SRC_BILL.DTB_INVOICE_LINE -> SRC_CUST.DTB_CUSTOMER
                   CUSTOMER_ID  --  CUSTOMER_ID
                   (Is-Indexed) -- (Is-Indexed)

0005  SRC_BILL.DTB_INVOICE_LINE -> SRC_INVN.DTB_INVENTORY_ITEM
                       ITEM_ID  --  ITEM_ID
                   (Un-Indexed) -- (Is-Indexed)

0006  SRC_BILL.DTB_INVOICE_LINE -> SRC_WARE.DTB_WAREHOUSE
                  WAREHOUSE_ID  --  WAREHOUSE_ID
                   (Is-Indexed) -- (Is-Indexed)

3501  SRC_BILL.DTB_INVOICE_LINE -> SRC_WARE.DTB_WAREHOUSE_STOCK_HK
                  WAREHOUSE_ID  --  WAREHOUSE_ID
                       ITEM_ID  --  ITEM_ID
                   (Is-Indexed) -- (Is-Indexed)

5000  SRC_BILL.DTB_INVOICE_LINE -> SRC_WARE.DTB_WAREHOUSE_STOCK_LA
                  WAREHOUSE_ID  --  WAREHOUSE_ID
                       ITEM_ID  --  ITEM_ID
                   (Is-Indexed) -- (Is-Indexed)

5001  SRC_BILL.DTB_INVOICE_LINE -> SRC_WARE.DTB_WAREHOUSE_STOCK_LO
                  WAREHOUSE_ID  --  WAREHOUSE_ID
                       ITEM_ID  --  ITEM_ID
                   (Is-Indexed) -- (Is-Indexed)

5002  SRC_BILL.DTB_INVOICE_LINE -> SRC_WARE.DTB_WAREHOUSE_STOCK_NY
                  WAREHOUSE_ID  --  WAREHOUSE_ID
                       ITEM_ID  --  ITEM_ID
                   (Is-Indexed) -- (Is-Indexed)

0007  SRC_BILL.DTB_INVOICE_LINE_HISTORY -> SRC_BILL.DTB_INVOICE_LINE
                           CUSTOMER_ID  --  CUSTOMER_ID
                        INVOICE_NUMBER  --  INVOICE_NUMBER
                               ITEM_ID  --  ITEM_ID
                           (Un-Indexed) -- (Is-Indexed)



#######
####### User: SRC_CUST
#######

0008  SRC_CUST.DTB_CUSTOMER -> SRC_CUST.DTB_POSTCODE
               POSTCODE_ID  --  POSTCODE_ID
               (Un-Indexed) -- (Is-Indexed)

0009  SRC_CUST.DTB_SUPPLIER -> SRC_CUST.DTB_POSTCODE
               POSTCODE_ID  --  POSTCODE_ID
               (Un-Indexed) -- (Is-Indexed)



#######
####### User: SRC_INVN
#######

0010  SRC_INVN.DTB_INVENTORY_ITEM -> SRC_INVN.DTB_INVENTORY_ITEM
                     OLD_ITEM_ID  --  ITEM_ID
                     (Un-Indexed) -- (Is-Indexed)



#######
####### User: SRC_WARE
#######

0011  SRC_WARE.DTB_WAREHOUSE_STOCK_HK -> SRC_INVN.DTB_INVENTORY_ITEM
                             ITEM_ID  --  ITEM_ID
                         (Un-Indexed) -- (Is-Indexed)

0012  SRC_WARE.DTB_WAREHOUSE_STOCK_HK -> SRC_WARE.DTB_WAREHOUSE
                        WAREHOUSE_ID  --  WAREHOUSE_ID
                         (Is-Indexed) -- (Is-Indexed)

0013  SRC_WARE.DTB_WAREHOUSE_STOCK_LA -> SRC_INVN.DTB_INVENTORY_ITEM
                             ITEM_ID  --  ITEM_ID
                         (Un-Indexed) -- (Is-Indexed)

0014  SRC_WARE.DTB_WAREHOUSE_STOCK_LA -> SRC_WARE.DTB_WAREHOUSE
                        WAREHOUSE_ID  --  WAREHOUSE_ID
                         (Is-Indexed) -- (Is-Indexed)

0015  SRC_WARE.DTB_WAREHOUSE_STOCK_LO -> SRC_INVN.DTB_INVENTORY_ITEM
                             ITEM_ID  --  ITEM_ID
                         (Un-Indexed) -- (Is-Indexed)

0016  SRC_WARE.DTB_WAREHOUSE_STOCK_LO -> SRC_WARE.DTB_WAREHOUSE
                        WAREHOUSE_ID  --  WAREHOUSE_ID
                         (Is-Indexed) -- (Is-Indexed)

0017  SRC_WARE.DTB_WAREHOUSE_STOCK_NY -> SRC_INVN.DTB_INVENTORY_ITEM
                             ITEM_ID  --  ITEM_ID
                         (Un-Indexed) -- (Is-Indexed)

0018  SRC_WARE.DTB_WAREHOUSE_STOCK_NY -> SRC_WARE.DTB_WAREHOUSE
                        WAREHOUSE_ID  --  WAREHOUSE_ID
                         (Is-Indexed) -- (Is-Indexed)