Using tiling to scale parallel data cube construction

Ruoming Jin, Karthik Vaidyanathan, Ge Yang, Gagan Agrawal

Research output: Chapter in Book/Report/Conference proceedingConference contribution

2 Scopus citations


Data cube construction is a commonly used operation in data warehouses. Because of the volume of data that is stored and analyzed in a data warehouse and the amount of computation involved in data cube construction, it is natural to consider parallel machines for this operation. Also, for both sequential and parallel data cube construction, effectively using the main memory is an important challenge. In our prior work, we have developed parallel algorithms for this problem. In this paper, we show how sequential and parallel data cube construction algorithms can be further scaled to handle larger problems, when the memory requirements could be a constraint. This is done by tiling the input and output arrays on each node. We address the challenges in using tiling while still maintaining the other desired properties of a data cube construction algorithm, which are, using minimal parents, and achieving maximal cache and memory reuse. We present a parallel algorithm that combines tiling with interprocessor communication. Our experimental results show the following. First, tiling helps in scaling data cube construction in both sequential and parallel environments. Second, choosing tiling parameters as per our theoretical results does result in better performance.

Original languageEnglish (US)
Title of host publicationProceedings - 2004 International Conference on Parallel Processing, ICPP 2004
EditorsR. Eigenmann
Number of pages8
StatePublished - 2004
Externally publishedYes
EventProceedings - 2004 International Conference on Parallel Processing, ICPP 2004 - Montreal, Que, Canada
Duration: Aug 15 2004Aug 18 2004

Publication series

NameProceedings of the International Conference on Parallel Processing
ISSN (Print)0190-3918


ConferenceProceedings - 2004 International Conference on Parallel Processing, ICPP 2004
CityMontreal, Que

ASJC Scopus subject areas

  • Hardware and Architecture
  • Engineering(all)


Dive into the research topics of 'Using tiling to scale parallel data cube construction'. Together they form a unique fingerprint.

Cite this