首页    期刊浏览 2024年10月06日 星期日
登录注册

文章基本信息

  • 标题:A New Approach for Database Fragmentation and Allocation to Improve the Distributed Database Management System Performance
  • 本地全文:下载
  • 作者:Rizik M. H. Al-Sayyed 1 , Fawaz A. Al Zaghoul 1 , Dima Suleiman 1 , Mariam Itriq 1 , Ismail Hababeh
  • 期刊名称:Journal of Software Engineering and Applications
  • 印刷版ISSN:1945-3116
  • 电子版ISSN:1945-3124
  • 出版年度:2014
  • 卷号:07
  • 期号:11
  • 页码:891-905
  • DOI:10.4236/jsea.2014.711080
  • 语种:English
  • 出版社:Scientific Research Publishing
  • 摘要:The efficiency and performance of Distributed Database Management Systems (DDBMS) is mainly measured by its proper design and by network communication cost between sites. Fragmentation and distribution of data are the major design issues of the DDBMS. In this paper, we propose new approach that integrates both fragmentation and data allocation in one strategy based on high performance clustering technique and transaction processing cost functions. This new approach achieves efficiently and effectively the objectives of data fragmentation, data allocation and network sites clustering. The approach splits the data relations into pair-wise disjoint fragments and determine whether each fragment has to be allocated or not in the network sites, where allocation benefit outweighs the cost depending on high performance clustering technique. To show the performance of the proposed approach, we performed experimental studies on real database application at different networks connectivity. The obtained results proved to achieve minimum total data transaction costs between different sites, reduced the amount of redundant data to be accessed between these sites and improved the overall DDBMS performance.
  • 关键词:Distributed Database Management System; Fragmentation; Allocation; Clustering; Network Sites
国家哲学社会科学文献中心版权所有