• Article
  • | |
  • Metrics
  • |
  • Reference [1]
  • |
  • Related [20]
  • | | |
  • Comments
    Abstract:

    In this paper, a new hash join algorithm-DHJ(the dynamic hash join) is proposed to resolve the problem of skewed data in the join operation in parallel database.The objective of the algorithm is to avoid the high cost of processing inherent in some early work. Additional buckets are used in the algorithm to balance output during the data partition. Then they are mapped to different processors before the completion of the join operation. The performance analysis of the algorithm is provided in this paper.

    Reference
    1 Kitsuregawa M,Tanaka H,Motooka T.Application of hash tO data base machine and its architecture.New Gener- ation Computing, 1983,1(1). 2 Kitsuregawa M,Ogawa.Bucket spreading parallel hash:a new robust.Parallel Hash Join Method for Data Skew in the Super Database Computer(SDC).In:Proc.of 16th VLDB Conference,Brisbane,Australia,1990.210 ~221. 3 Wolf J L,Dias D M,Yu P S et al.An effective algorithm for parallelizing hash join in the presence of data skew. IBM T.J.Watson.Research Center Tech Report RC 1990. 4 Zhao X,Johnson R G.DBJ—a dynamic balancing hash join algorithm in multiprocessor database systems.LNCS 779.Advances in Database Technology-EDBT'94, 1994.301~308.
    Cited by
    Comments
    Comments
    分享到微博
    Submit
Get Citation

洪晓光,王新军,董继润.一种避免数据偏斜的动态Hash连接方法.软件学报,1997,8(8):610-614

Copy
Share
Article Metrics
  • Abstract:4267
  • PDF: 5006
  • HTML: 0
  • Cited by: 0
History
  • Revised:October 16,1996
You are the first2045181Visitors
Copyright: Institute of Software, Chinese Academy of Sciences Beijing ICP No. 05046678-4
Address:4# South Fourth Street, Zhong Guan Cun, Beijing 100190,Postal Code:100190
Phone:010-62562563 Fax:010-62562533 Email:jos@iscas.ac.cn
Technical Support:Beijing Qinyun Technology Development Co., Ltd.

Beijing Public Network Security No. 11040202500063