Databases Reference
In-Depth Information
6(/(&7
'5,9(5B2%-(&7B.(<
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,9(5B2%-(&7B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
)5200$5.(7B%$6.(7B%,B7$%/(
*5283%<
,7(06(7B.(<
'5,9(5B2%-(&7B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
*5283%<
'5,9(5B2%-(&7B.(<'5,9(5
fIGure 6.3
Driver Group By.
6(/(&7
'5,9(5B2%-(&7B.(<
&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$%/(
*5283%<
'5,9(5B2%-(&7B.(<
&255B2%-(&7B.(<&255
fIGure 6.4
Correlation Group By.
DAtAmArt ArchItecture
The datamart architecture may seem unusual. If you were expect-
ing an enormous table with every permutation of Market Basket data
conceivable, then the datamart architecture may seem surprising as
well as unusual. However, the datamart architecture using a c lass of
Market Basket Tables and a class of Market Basket BI Tables leverages
the strengths of the RDBMS platforms while mitigating the performance
