Databases Reference
In-Depth Information
tABle 7.7
Market Basket BI Table with Correlation Hierarchy
Driver
Object
Key
Itemset
Key
Driver
Quantity
Driver
Dollars
Driver
Count
Hierarchy
Key
Corr
Quantity
Corr
Dollars
Corr
Count
1
15
1
$15.31
1
0
0
$0.00
1
2
16
2
$24.42
1
9792
2
$18.18
1
2
43
1
$14.32
1
9792
2
$18.18
1
2
57
2
$18.18
1
6543
4
$51.11
1
2
64
1
$12.37
1
9792
2
$18.18
1
3
15
2
$30.62
1
1124
5
$56.21
1
3
15
2
$30.62
1
6543
2
$24.58
1
3
16
1
$12.21
1
1124
5
$56.21
1
3
16
1
$12.21
1
9792
2
$30.62
1
3
64
1
$12.37
1
1124
5
$56.21
1
3
64
1
$12.37
1
9792
2
$30.62
1
3
78
4
$53.76
1
6543
2
$24.58
1
3
78
4
$53.76
1
9792
2
$30.62
1
3
98
1
$2.45
1
6543
2
$24.58
1
3
98
1
$2.45
1
9792
2
$30.62
1
4
43
3
$42.96
1
1124
2
$15.89
1
4
43
3
$42.96
1
9792
2
$25.96
1
4
57
1
$9.09
1
1124
2
$15.89
1
4
57
1
$9.09
1
6543
3
$42.96
1
4
78
1
$13.44
1
6543
3
$42.96
1
4
78
1
$13.44
1
9792
2
$25.96
1
4
87
1
$16.87
1
1124
2
$15.89
1
4
87
1
$16.87
1
6543
3
$42.96
1
4
98
1
$2.45
1
6543
3
$42.96
1
4
98
1
$2.45
1
9792
2
$25.96
1
the reporting phase would benefit from the use of a physical table, which
would be a datamart.
step 5: load a market Basket BI table using a Driver hierarchy
If a Ma rket Basket Analysis effort can consider the correlations from
objects leading to hierarchical groups, then that same Market Basket
Analysis effort can also consider the correlations from hierarchi-
cal groups leading to objects. Using again the hierarchical groups in
Table 7.6, the SQL in Figure 7.6 extracts data from the Market Basket
