Hamlet Temp Title

1
(No Transcript)
2
Figure 19.1The Fact Table for the Supermarket
Application.
3
Figure 19.2Three-dimensional cube for the
super-market application.
4
Figure 19.3Dimension tables for the supermarket
application.
5
Figure 19.4Star schema for the supermarket
example.
6
Figure 19.5Constellation schema for the expanded
supermarket example.
7
Figure 19.6Query result that aggregates
Sales_Amt on the time dimension.
8
Figure 19.7Query result that drills down on
regions.
9
Figure 19.8Query result that presents total
product sales for each quarter.
10
Figure 19.9Time hierarchy as a lattice.
11
Figure 19.10Query result for the sales
application in the form of a spreadsheet
12
Figure 19.11Result set returned with the CUBE
operator.
13
Figure 19.12Result set returned with the ROLLUP
operator.
14
Figure 19.13ATuples added to the fact table by
the CUBE operator.
15
Figure 19.13B (continued)Tuples added to the
fact table by the CUBE operator (continued).
16
Figure 19.13C (continued)Tuples added to the
fact table by the CUBE operator (continued).
17
Figure 19.15Loading data into an OLAP database.