Databases Reference
In-Depth Information
tABle 7.11
Market Basket Table with Hierarchies
Itemset_key
Object_key
Quantity
Dollars
1
0
0
$0.00
1
9792
1
$15.31
2
6543
4
$51.11
2
9792
2
$18.18
3
1124
5
$56.21
3
6543
2
$24.58
3
9792
2
$30.62
4
1124
2
$15.89
4
6543
3
$42.96
4
9792
2
$25.96
tABle 7.12
Market Basket BI Table with Hierarchies
Driver
Object
Key
Corr
Object
Key
Itemset
Key
Driver
Quantity
Driver
Dollars
Driver
Count
Corr
Quantity
Corr
Dollars
Corr
Count
1
9792
1
$15.31
1
0
0
$0.00
1
2
6543
4
$51.11
1
9792
2
$18.18
1
2
9792
2
$18.18
1
6543
4
$51.11
1
3
1124
5
$56.21
1
6543
2
$24.58
1
3
1124
5
$56.21
1
9792
2
$30.62
1
3
6543
2
$24.58
1
1124
5
$56.21
1
3
6543
2
$24.58
1
9792
2
$30.62
1
3
9792
2
$30.62
1
1124
5
$56.21
1
3
9792
2
$30.62
1
6543
2
$24.58
1
4
1124
2
$15.89
1
6543
3
$42.96
1
4
1124
2
$15.89
1
9792
2
$25.96
1
4
6543
3
$42.96
1
1124
2
$15.89
1
4
6543
3
$42.96
1
9792
2
$25.96
1
4
9792
2
$25.96
1
1124
2
$15.89
1
4
9792
2
$25.96
1
6543
3
$42.96
1
to avoid self-identifying correlations obscured by an object and its hierar-
chical group.
The Market Basket Table, loaded with objects represented by their hier-
archical groups, is shown in Table 7.11. The number of rows decreases as
the objects are abstracted up their hierarchies.
