BIROn - Birkbeck Institutional Research Online

    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.

    Full text not available from this repository.


    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.


    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


    Activity Overview
    6 month trend
    6 month trend

    Additional statistics are available via IRStats2.

    Archive Staff Only (login required)

    Edit/View Item Edit/View Item