文章基本信息

标题：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