Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2
Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
FPGrowth Example Output Message
Output Information
Patterns are kept in table "fpgrowth_out_pattern"

Rules are kept in table "fpgrowth_out_rule"

The query below returns the output shown in the following table:

SELECT * FROM fpgrowth_out_pattern ORDER BY region, pattern_product;
FPGrowth Example Output Table fpgrowth_out_pattern
region pattern_product length_of_pattern count support
Atlantic Appliances, Chairs & Chairmats 2 1 0.0555555555555556
Atlantic Chairs & Chairmats, Computer Peripherals 2 1 0.0555555555555556
Atlantic Labels, Pens & Art Supplies 2 1 0.0555555555555556
Atlantic Office Furnishings, Binder s and Binder Accessories 2 1 0.0555555555555556
Atlantic Office Furnishings, Computer Peripherals 2 1 0.0555555555555556
Atlantic Office Furnishings, Paper 2 1 0.0555555555555556
Atlantic Office Furnishings, Paper, Storage & Organization 3 1 0.0555555555555556
Atlantic Office Furnishings, Storage & Organization 2 1 0.0555555555555556
Atlantic Paper, Labels 2 1 0.0555555555555556
Atlantic Paper, Storage & Organization 2 1 0.0555555555555556
Northwest Territories Binder s and Binder Accessories, Computer Peripherals 2 3 0.0111524163568773
Northwest Territories Binder s and Binder Accessories, Office Furnishings 2 4 0.0148698884758364
Northwest Territories Binder s and Binder Accessories, Office Machines 2 3 0.0111524163568773
Northwest Territories Binder s and Binder Accessories, Rubber Bands 2 3 0.0111524163568773
Northwest Territories Binder s and Binder Accessories, Telephones and Communication 2 4 0.0148698884758364
Northwest Territories Computer Peripherals, Chairs & Chairmats 2 3 0.0111524163568773
... ... ... ... ...

The query below returns the output shown in the table fpgrowth_out_rule:

SELECT * FROM fpgrowth_out_rule ORDER BY region, score;
FPGrowth Example Output Table fpgrowth_out_rule (Columns 1-6)
region antecedent_product consequence_product count_of_antecedent count_of_consequence cntb
Atlantic Paper Office Furnishings 1 1 1
Atlantic Office Furnishings Paper 1 1 1
Atlantic Binders and Binder Accessories Office Furnishings 1 1 1
Atlantic Office Furnishings Binders and Binder Accessories 1 1 1
Atlantic Labels Paper 1 1 1
FPGrowth Example Output Table fpgrowth_out_rule (Columns 7-12)
cnt_antecedent cnt_consequence score support confidence lift
4 5 0.05 0.0555555555555556 0.25 0.9
5 4 0.05 0.0555555555555556 0.2 0.9
3 5 0.0666666666666667 0.0555555555555556 0.333333333333333 1.2
5 3 0.0666666666666667 0.0555555555555556 0.2 1.2
3 4 0.0833333333333333 0.0555555555555556 0.333333333333333 1.5
FPGrowth Example Output Table fpgrowth_out_rule (Columns 13-17)
conviction leverage coverage chi_square z_score
0.962962962962963 -0.00617283950617285 0.222222222222222 0.0197802197802198  
0.972222222222222 -0.00617283950617285 0.277777777777778 0.0197802197802198  
1.08333333333333 0.00925925925925925 0.166666666666667 0.0553846153846154  
1.04166666666667 0.00925925925925925 0.277777777777778 0.0553846153846154  
1.16666666666667 0.0185185185185185 0.166666666666667 0.257142857142857  

The output tables contain only those rows that conform to MinSupport of 0.01. The rest of the rows that violate the condition are deleted.