并行数据库上的并行CMD-Join算法
作者:
基金项目:

本文研究得到国家自然科学基金、国家863高科技项目基金、国家杰出青年基金和黑龙江省杰出青年基金资助.


Parallel CMD-Join Algorithms on Parallel Databases
  • 摘要
  • | |
  • 访问统计
  • |
  • 参考文献 [1]
  • |
  • 相似文献 [20]
  • |
  • 引证文献
  • | |
  • 文章评论
    摘要:

    并行数据库在多处理机之间的分布方法(简称数据分布方法)对并行数据操作算法的性能影响很大.如果在设计并行数据操作算法时充分利用数据分布方法的特点,可以得到十分有效的并行算法.本文研究如何充分利用数据分布方法的特点,设计并行数据操作算法的问题,提出了基于CMD多维数据分布方法的并行CMD-Join算法.理论分析和实验结果表明,并行CMD-Join算法的效率高于其它并行Join算法.

    Abstract:

    Data declustering methods of parallel databases have significant effect on the performance of the parallel algorithms on the databases. If the characteristics of the declustering methods of the parallel database can be adequately exploited in designing parallel algorithms for implementing the database operations in parallel database systems, high performance parallel algorithms could be resulted. Unfortunately, the advantages of the underlying declustering methods of the parallel databases are rarely considered in existent parallel algorithms on the parallel databases. The focus of this paper is on how to utilize the advantages of the underlying declustering methods of the databases in designing parallel join algorithms. A set of parallel join algorithms based on the CMD declustering method are proposed. Theoretical and experimental results show that the proposed algorithms are more efficient than other parallel join algorithms.

    参考文献
    1  李建中.并行数据库的查询并行化技术与物理设计方法.软件学报,1994,5(10):1~10 (Li Jian-zhong. Parallelization techniques for query processing and data declustering methods. Journal of Softwate, 1994,5(10):1~10) 2  李建中.并行数据操作算法和查询优化技术.软件学报,1994,5(10):11~23 (Li Jian-zhong. Parallel data operation algorithms and query optimization techniques. Journal of Software, 1994,5(10):11~23) 3  BoralH et al. Join on a cube: analysis, simulation and implementation. In: Kitsuregawa M, Tanaka H eds. Database Machines and Knowledge Base Machines. Boston: Kluwer, 1988. 61~74 4  Schneider D A, DeWitt D J. A performance evaluation of parallel in algorithms in a shared-nothing multiprocessor environment. In: Maier D ed. Proceedings of the ACM SIGMOD'89, USA, 1989. Baltimore: ACM Press, 1989. 110~121 5  Kitsuregawa M, Tanaka H, Motooka T. Application of hash to data base machine and its architecture. New Generation Computing, 1983,1(1):25~39 6  Omiecinski E R, Lin E T. Hash-based and index-based join algorithms for cube and ring connected multicomputers. IEEE Transactions on Knowledge and Data Engineering, 1989,1(3):329~343 7  Kitsuregawa M, Nakayama M, Takagi M. The effect of bucket size tuning in the dynamic hybrid GRACE hash join method. In: Proceedings of the International Conference on Very Large Data Bases'89. San Mateo: Morgan Kaufmann Publishers, Inc., 1989. 257~266 8  Kitsuregawa M, Ogawa Y. Bucket spreading parallel hash: a new bobust, parallel hash join method for data skew in the super database computer (SDC). In: Proceedings of the International Conference on Very Large Data Bases'90. Palo Alto: Morgan Kaufmann Publishers, Inc., 1990. 210~221 9  Hua K A, Lee C. Handling data skew in multiprocessor database computer systems using partition tuning. In: Proceedings of the of the International Conference on Very Large Data Bases'91, Barcelona, 1991. San mateo: Morgan Kaufmann publishers, Inc., 1991. 525~536 10  Li Jian-zhong, Jaideep Srivastava, Doron Rotem. CMD: a multidimensional declustering method for parallel database systems. In: Proceedings of the 18th International Conference on Very Large Data Bases Conference. Canada, 1992 11  Li Jian-zhong. Range query procession in multi-disk systems. Journal of Computer Science and Technology, 1992,7(4):316~327. 12  Stonebraker M. The case for shared nothing. Database Engineering, 1986,9(1):17~24
    网友评论
    网友评论
    分享到微博
    发 布
引用本文

李建中,都 薇.并行数据库上的并行CMD-Join算法.软件学报,1998,9(4):256-262

复制
分享
文章指标
  • 点击次数:3817
  • 下载次数: 4486
  • HTML阅读次数: 0
  • 引用次数: 0
历史
  • 收稿日期:1997-04-14
  • 最后修改日期:1997-07-25
文章二维码
您是第19945670位访问者
版权所有:中国科学院软件研究所 京ICP备05046678号-3
地址:北京市海淀区中关村南四街4号,邮政编码:100190
电话:010-62562563 传真:010-62562533 Email:jos@iscas.ac.cn
技术支持:北京勤云科技发展有限公司

京公网安备 11040202500063号