Databases Reference
In-Depth Information
Chicago
New York
Toronto
Vancouver
854
882
89
623
1087
968
38
872
818
746
43
591
Q1
605
825
14
400
Q2
680
952
31
512
Q3
812
1023
30
501
Q4
927
1038
38
580
computer
security
home
entertainment
phone
item
(types)
Figure 4.3
A 3-D data cube representation of the data in Table 4.3, according to
time
,
item
, and
location
.
The measure displayed is
dollars sold
(in thousands).
supplier
=
“SUP1”
supplier
=
“SUP2”
supplier
=
“SUP3”
Chicago
New York
Toronto
Vancouver
Q1
Q2
Q3
Q4
605 825
14
400
computer
security
computer
security
computer
security
home
entertainment
phone
home
entertainment
phone
home
entertainment
phone
item
(types)
item
(types)
item
(types)
Figure 4.4
A 4-D data cube representation of sales data, according to
time
,
item
,
location
, and
supplier
.
The measure displayed is
dollars sold
(in thousands). For improved readability, only some of
the cube values are shown.
and
location
, summarized for all suppliers. The 0-D cuboid, which holds the highest level
of summarization, is called the
apex cuboid
. In our example, this is the total sales, or
dollars sold
, summarized over all four dimensions. The apex cuboid is typically denoted
by
all
.
