Aggregate-join query processing in parallel database systems

D. Taniar, Y. Jiang, K. H. Liu, C. H.C. Leung

Research output: Chapter in Book/Report/Conference proceedingConference PaperResearchpeer-review

9 Citations (Scopus)

Abstract

Queries containing aggregate functions often combine multiple tables through join operations. We call these queries "aggregate-join" queries. In parallel processing of such queries, it must be decided which attribute to be used as a partitioning attribute, particularly join attribute or group-by attribute. Based on the partitioning attribute, we discuss three parallel aggregate-join query processing methods, namely: Join Partition Method (JPM), Aggregate Partition Method (APM), and Hybrid Partition Method (HPM). The JPM and APM models use the join attribute, and the group-by attribute, respectively, as the partitioning attribute. The HPM model combines the other two methods using a logically hybrid architecture.

Original languageEnglish
Title of host publicationProceedings - 4th International Conference/Exhibition on High Performance Computing in the Asia-Pacific Region, HPC-Asia 2000
PublisherIEEE, Institute of Electrical and Electronics Engineers
Pages824-829
Number of pages6
ISBN (Electronic)0769505902, 9780769505909
DOIs
Publication statusPublished - 2000
Externally publishedYes
Event4th International Conference/Exhibition on High Performance Computing in the Asia-Pacific Region, HPC-Asia 2000 - Beijing, China
Duration: 14 May 200017 May 2000

Conference

Conference4th International Conference/Exhibition on High Performance Computing in the Asia-Pacific Region, HPC-Asia 2000
CountryChina
CityBeijing
Period14/05/0017/05/00

Cite this

Taniar, D., Jiang, Y., Liu, K. H., & Leung, C. H. C. (2000). Aggregate-join query processing in parallel database systems. In Proceedings - 4th International Conference/Exhibition on High Performance Computing in the Asia-Pacific Region, HPC-Asia 2000 (pp. 824-829). [843554] IEEE, Institute of Electrical and Electronics Engineers. https://doi.org/10.1109/HPC.2000.843554