Page 233 -
P. 233

HAN
                               12-ch05-187-242-9780123814791

          196   Chapter 5 Data Cube Technology              2011/6/1  3:19 Page 196  #10



                                                                                     A-B Plane

                                                                                     *
                                                                                     *  *  *  *
                                                                           61 62  63
                                                                                     *  *  *  *
                                                                                  64
                                                                    45 46 47         *  *  *  *
                                                                                  60
                                                                            48
                                       B-C Plane                            44    56
                                                            29 30 31
                                                                    32            52
                                                                            40
                                                                                  c 3
                                                                    28
                                                                            36
                                                                    24      c 2
                          *    *
                              *             b 13  14  15 16  12     20
                                            3
                            *                                            C
                          *    *
                              *             b 2  9 10  11   8       c 1
                            *            B
                          *    *
                              *             b 1  5  6  7    4
                            *
                          *
                                            b 0  1  2  3    c 0         A-C Plane

                                              a 0  a 1  a 2  a 3
                                                  A

                                                        *
                                                      *  *  *  *
                                                    *  *  *  *
                                                  *  *  *  *



               Figure 5.3 A 3-D array for the dimensions A, B, and C, organized into 64 chunks. Each chunk is small
                         enough to fit into the memory available for cube computation. The ∗’s indicate the chunks
                         from 1 to 13 that have been aggregated so far in the process.

                         the dimensions A, B, and C is 40, 400, and 4000, respectively. Thus, the size of the array
                         for each dimension, A, B, and C, is also 40, 400, and 4000, respectively. The size of each
                         partition in A, B, and C is therefore 10, 100, and 1000, respectively. Full materialization
                         of the corresponding data cube involves the computation of all the cuboids defining this
                         cube. The resulting full cube consists of the following cuboids:
   228   229   230   231   232   233   234   235   236   237   238