DBJ: a dynamic balancing hash join algorithm in multiprocessor database systems
Zhao, X. and Johnson, Roger and Martin, N.J. (1994) DBJ: a dynamic balancing hash join algorithm in multiprocessor database systems. Information Systems 19 (1), pp. 89-100. ISSN 0306-4379.
Abstract
In this paper, a new hash join algorithm, the Dynamic Balancing Hash Join (DBJ), is proposed to handle the problem of skewed data in the join operation in multiprocessor database systems. The objective of this new algorithm is to avoid the high cost of preprocessing inherent in existing algorithms. The methods used include detecting the unbalanced output during the data partition process and overlapping the balancing process with the data partition process. The new algorithm only redistributes a small portion of the partitioned data and, thereby achieves a balanced output with little extra cost. Further, it balances the output dynamically and needs no knowledge of the input distribution. This is achieved without any need for a co-ordinating processor moreover. This algorithm has been fully implemented in a multiprocessor database system and a performance analysis is presented. The result shows that the new algorithm performs better than existing balancing hash join algorithms for a wide degree of skew.
Metadata
| Item Type: | Article |
|---|---|
| School: | Birkbeck Faculties and Schools > Faculty of Science > School of Computing and Mathematical Sciences |
| Depositing User: | Sarah Hall |
| Date Deposited: | 20 Apr 2021 19:35 |
| Last Modified: | 09 Aug 2023 12:50 |
| URI: | https://eprints.bbk.ac.uk/id/eprint/43950 |
Statistics
Additional statistics are available via IRStats2.
Archive Staff Only (login required)
 |
Edit/View Item |