Databases Reference
In-Depth Information
6(/(&7
'5,9(5+,(5$5&+<B.(<
&255&255B2%-(&7B.(<
'5,9(5'5,9(5B48$17,7<B680
'5,9(5'5,9(5B'2//$56B680
'5,9(5'5,9(5B&2817B680
&255&255B48$17,7<B680
&255&255B'2//$56B680
&255&255B&2817B680
&255&255B48$17,7<B680'5,9(5'5,9(5B48$17,7<B680$648$17,7<B5$7,2
&255&255B'2//$56B680'5,9(5'5,9(5B'2//$56B680$6'2//$56B5$7,2
&255&255B&2817B680'5,9(5'5,9(5B&2817B680$6&2817B5$7,2
)520
6(/(&7
+,(5$5&+<B.(<
680'5,9(5B48$17,7<$6'5,9(5B48$17,7<B680
680'5,9(5B'2//$56$6'5,9(5B'2//$56B680
680'5,9(5B&2817$6'5,9(5B&2817B680
)5206(/(&7
,7(06(7B.(<
+,(5$5&+<B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
)5200$5.(7B%$6.(7B%,B7$%/(B'5,9(5B+,(5$5&+<
*5283%<
,7(06(7B.(<
+,(5$5&+<B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
*5283%<
+,(5$5&+<B.(<'5,9(5
,11(5-2,1
6(/(&7
+,(5$5&+<B.(<
&255B2%-(&7B.(<
680&255B48$17,7<$6&255B48$17,7<B680
680&255B'2//$56$6&255B'2//$56B680
680&255B&2817$6&255B&2817B680
)5200$5.(7B%$6.(7B%,B7$%/(B'5,9(5B+,(5$5&+<
*5283%<
+,(5$5&+<B.(<
&255B2%-(&7B.(<&255
21'5,9(5+,(5$5&+<B.(< &255+,(5$5&+<B.(<
25'(5%<
'5,9(5+,(5$5&+<B.(<
&255&255B2%-(&7B.(<
fIGure 7.7
Market Basket Analysis BI View with driver hierarchy.
The Market Basket Analysis BI View shown in Figure 7.7 is very similar
to that in Figure 7.3 and Figure 7.5. The difference is that the Driver Object
in Figure 7.7 has the name Hierarchy_Key, not DRIVER_OBJECT_KEY.
Again, this reflects the need to organize the tables in a Ma rket Basket
Analysis application, by using column names that reflect the nature of the
