Double table switch: an efficient partitioning algorithm for bottom-up computation of data cubes

J You, L Jia, J Hu, Q Huang, J Xi�- …�19-21, 2010, Proceedings, Part II 6, 2010 - Springer
J You, L Jia, J Hu, Q Huang, J Xi
Advanced Data Mining and Applications: 6th International Conference, ADMA 2010�…, 2010Springer
Bottom-up computation of data cubes is an efficient approach which is adopted and
developed by many other cubing algorithms such as H-Cubing, Quotient Cube and Closed
Cube, etc. The main cost of bottom-up computation is recursively sorting and partitioning the
base table in a worse way where large amount of auxiliary spaces are frequently allocated
and released. This paper proposed a new partitioning algorithm, called Double Table Switch
(DTS). It sets up two table spaces in the memory at the beginning, where the partitioned�…
Abstract
Bottom-up computation of data cubes is an efficient approach which is adopted and developed by many other cubing algorithms such as H-Cubing, Quotient Cube and Closed Cube, etc. The main cost of bottom-up computation is recursively sorting and partitioning the base table in a worse way where large amount of auxiliary spaces are frequently allocated and released. This paper proposed a new partitioning algorithm, called Double Table Switch (DTS). It sets up two table spaces in the memory at the beginning, where the partitioned results in one table are copied into another table alternatively during the bottom-up computation. Thus DTS avoids the costly space management and achieves the constant memory usage. Further, we improve the DTS algorithm by adjusting the dimension order, etc. The experimental results demonstrate the efficiency of DTS.
Springer
Showing the best result for this search. See all results