Databases Reference
In-Depth Information
tABle 7.9
Market Basket BI Table with Driver Hierarchy
Itemset
Key
Hierarchy
Key
Driver
Quantity
Driver
Dollars
Driver
Count
Corr
Objectkey
Corr
Quantity
Corr
Dollars
Corr
Count
1
9792
1
$15.31
1
0
0
$0.00
1
2
6543
4
$51.11
1
57
2
$18.18
1
2
9792
2
$18.18
1
16
2
$24.42
1
2
9792
2
$18.18
1
43
1
$14.32
1
2
9792
2
$18.18
1
64
1
$12.37
1
3
1124
5
$56.21
1
15
2
$30.62
1
3
1124
5
$56.21
1
16
1
$12.21
1
3
1124
5
$56.21
1
64
1
$12.37
1
3
6543
2
$24.58
1
15
2
$30.62
1
3
6543
2
$24.58
1
78
4
$53.76
1
3
6543
2
$24.58
1
98
1
$2.45
1
3
9792
2
$30.62
1
16
1
$12.21
1
3
9792
2
$30.62
1
64
1
$12.37
1
3
9792
2
$30.62
1
78
4
$53.76
1
3
9792
2
$30.62
1
98
1
$2.45
1
4
1124
2
$15.89
1
43
3
$42.96
1
4
1124
2
$15.89
1
57
1
$9.09
1
4
1124
2
$15.89
1
87
1
$16.87
1
4
6543
3
$42.96
1
57
1
$9.09
1
4
6543
3
$42.96
1
78
1
$13.44
1
4
6543
3
$42.96
1
87
1
$16.87
1
4
6543
3
$42.96
1
98
1
$2.45
1
4
9792
2
$25.96
1
43
3
$42.96
1
4
9792
2
$25.96
1
78
1
$13.44
1
4
9792
2
$25.96
1
98
1
$2.45
1
Object to the hierarchy as a separate alias. The use of a separate alias
for the hierarchy join causes the RDBMS platform to handle the two
joins and join table independently of each other, even though they are
the same tables.
The third primary function of the SQL in Figure 7.6 is that it excludes
those rows that join to the same hierarchical group for both the Driver
Object and the Correlation Object. This has the effect of preventing a hier-
archical group from correlating to its own objects, which is conceptually
the same as preventing an object from correlating with itself. The output
of this is shown in Table 7.9.
