Parallel algorithms for computing temporal aggregates

Jose Alvin G. Gendrano, Bruce C. Huang, Jim M. Rodrigue, Bongki Moon, Richard T. Snodgrass

Research output: Contribution to conferencePaper

19 Scopus citations

Abstract

The ability to model the temporal dimension is essential to many applications. Furthermore, the rate of increase in database size and response time requirements has outpaced advancements in processor and mass storage technology, leading to the need for parallel temporal database management systems. In this paper, we introduce a variety of parallel temporal aggregation algorithms for a shared-nothing architecture based on the sequential Aggregation Tree algorithm. Via an empirical study, we found that the number of processing nodes, the partitioning of the data, the placement of results, and the degree of data reduction effected by the aggregation impacted the performance of the algorithms. For distributed results placement, we discovered that Time Division Merge was the obvious choice. For centralized results and high data reduction, Pairwise Merge was preferred regardless of the number of processing nodes, but for low data reduction, it only performed well up to 32 nodes. This led us to a centralized variant of Time Division Merge which was best for larger configurations having low data reduction.

Original languageEnglish (US)
Pages418-427
Number of pages10
StatePublished - Jan 1 1999
EventProceedings of the 1999 15th International Conference on Data Engineering, ICDE-99 - Sydney, NSW, AUS
Duration: Mar 23 1999Mar 26 1999

Other

OtherProceedings of the 1999 15th International Conference on Data Engineering, ICDE-99
CitySydney, NSW, AUS
Period3/23/993/26/99

    Fingerprint

ASJC Scopus subject areas

  • Software
  • Signal Processing
  • Information Systems

Cite this

Gendrano, J. A. G., Huang, B. C., Rodrigue, J. M., Moon, B., & Snodgrass, R. T. (1999). Parallel algorithms for computing temporal aggregates. 418-427. Paper presented at Proceedings of the 1999 15th International Conference on Data Engineering, ICDE-99, Sydney, NSW, AUS, .