TITLE:
A New Approach for Database Fragmentation and Allocation to Improve the Distributed Database Management System Performance
AUTHORS:
Rizik M. H. Al-Sayyed, Fawaz A. Al Zaghoul, Dima Suleiman, Mariam Itriq, Ismail Hababeh
KEYWORDS:
Distributed Database Management System, Fragmentation, Allocation, Clustering, Network Sites
JOURNAL NAME:
Journal of Software Engineering and Applications,
Vol.7 No.11,
October
20,
2014
ABSTRACT: 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.