Performance Evaluation of Parallel GroupBy-Before-Join Query Processing in High Performance Database Systems

Authors:
David Taniar;J. Wenny Rahayu;Hero Ekonomosa
Affiliations:
-;-;-
Venue:
HPCN Europe 2001 Proceedings of the 9th International Conference on High-Performance Computing and Networking
Year:
2001

Citing 9
Cited 0

Parallel database systems: the future of high performance database systems

Communications of the ACM
Database management systems

Database management systems
On optimizing an SQL-like nested query

ACM Transactions on Database Systems (TODS)
Performing Group-By before Join

Proceedings of the Tenth International Conference on Data Engineering
Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers

VLDB '87 Proceedings of the 13th International Conference on Very Large Data Bases
Translating and Optimizing SQL Queries Having Aggregates

VLDB '87 Proceedings of the 13th International Conference on Very Large Data Bases
Outstanding Challenges in OLAP

ICDE '98 Proceedings of the Fourteenth International Conference on Data Engineering
A Case for Parallelism in Data Warehousing and OLAP

DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
Aggregate-Join Query Processing in Parallel Database Systems

HPC '00 Proceedings of the The Fourth International Conference on High-Performance Computing in the Asia-Pacific Region-Volume 2 - Volume 2

Quantified Score

Hi-index	0.00

Visualization

Abstract

Strategic decision making process uses a lot of GroupBy clauses and join operations queries. As the source of information in this type of application to these queries is commonly very huge, then parallelization of GroupBy-Join queries is unavoidable in order to speed up query processing time. In this paper, we investigate three parallelization techniques for GroupBy-Join queries, particularly the queries where the group-by clause can be performed before the join operation. We subsequently call this query "GroupBy-Before-Join" queries. Performance evaluation of the three parallel processing methods is also carried out and presented here.