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.

    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: School of Business, Economics & Informatics > Computer Science and Information Systems
    Depositing User: Sarah Hall
    Date Deposited: 20 Apr 2021 19:35
    Last Modified: 20 Apr 2021 19:35
    URI: https://eprints.bbk.ac.uk/id/eprint/43950

    Statistics

    Downloads
    Activity Overview
    0Downloads
    33Hits

    Additional statistics are available via IRStats2.

    Archive Staff Only (login required)

    Edit/View Item Edit/View Item