跳至主要内容

A New Approach for Database Fragmentation and Allocation to Improve the Distributed Database Management System Performance

Read full paper at:
http://www.scirp.org/journal/PaperInformation.aspx?PaperID=50619#.VEclwlfHRK0

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.
Cite this paper
Al-Sayyed, R. , Al Zaghoul, F. , Suleiman, D. , Itriq, M. and Hababeh, I. (2014) A New Approach for Database Fragmentation and Allocation to Improve the Distributed Database Management System Performance. Journal of Software Engineering and Applications, 7, 891-905. doi: 10.4236/jsea.2014.711080. 
 

[1] Ozsu, M.T. and Valduriez, P. (2011) Principles of Distributed Database Systems. Springer, Berlin.
[2] Huang, Y.F. and Chen, J.H. (2001) Fragment Allocation in Distributed Database Design. Journal of Information Science and Engineering, 17, 491-506.
[3] Gupta, S. and Panda, S. (2012) Vertical Fragmentation, Allocation and Re-Fragmentation in Distributed Object Relational Database Systems-(Update Queries Included). International Journal of Engineering Research and Development, 4, 45-52.
[4] Khan, S.I. and Hoque, A.S.M.L. (2010) A New Technique for Database Fragmentation in Distributed Systems. International Journal of Computer Applications, 5, 20-24. http://dx.doi.org/10.5120/940-1318
[5] Hababeh, I. (2012) Improving Network Systems Performance by Clustering Distributed Database Sites. The Journal of Supercomputing, 59, 249-267. http://dx.doi.org/10.1007/s11227-010-0436-9
[6] Suganya, A. and Kalaiselvi, R. (2013) Efficient Fragmentation and Allocation in Distributed Database. International Journal of Engineering Research & Technology (IJERT), 2, 1-7.
[7] Jagannatha, S., Geetha, D.E., Kumar, T.S. and Kanth, K.R. (2013) Load Balancing in Distributed Database System Using Resource Allocation Approach. International Journal of Advanced Research in Computer and Communication Engineering, 2, 2529-2535.
[8] Abdalla, H.I. (2012) A New Data Re-Allocation Model for Distributed Database Systems. International Journal of Database Theory and Application, 5, 45-60.
[9] Grebla, H., Moldovan, G., Darabant, S.A. and Campan, A. (2004) Data Allocation in Distributed Database Systems Performed by Mobile Intelligent Agents. Proceedings of the International Conference on Theory and Applications of Mathematics and Informatics-ICTAMI, Greece, 164-173.
[10] Singh, A., Kahlon, K.S. and Virk, R.S. (2014) Nonreplicated Static Data Allocation in Distributed Databases Using Biogeography-Based Optimization. Chinese Journal of Engineering, 1-9.                   eww141022lx
[11] OPNET Technologies, Inc. (2014) OPNET IT Guru Academic Edition 9.1.
http://www.opnet.com/university_program/itguru_academic_edition
标签：

评论

发表评论

此博客中的热门博文

Does Immigration Promote the Investment of the Monopolistic Firm?

In the present paper, we examine the effect of increasing uncertainty of immigrants’ growth on the optimal timing of investment of a firm that has a monopolistic power over the labor market. It is revealed that when the uncertainty of immigrants’ growth is more than a threshold level, increasing uncertainty of immigrants’ growth accelerates the optimal timing of firms’ investment and enhances the economic growth, even if the uncertainty of immigrants’ growth is formulated by the geometric Brownian motion, which is in sharp contrast to the standard result that an increase in the uncertainty postpones the optimal timing. With an increase in the immigrants over the past ten years, workforces in the host countries have been growing significantly to the extent that the immigrants represent 70% of the increase in the workforce in Europe, and 47% in the United States as OECD indicates. In the present paper, we attempted to investigate the effect of increased uncertainty caused by the growi...
发表评论
阅读全文

Education Policy Implementation: A Mechanism for Enhancing Primary Education Development in Zanzibar

Education is one of the fundamental rights of individuals; therefore, the government of a country needs to develop and strengthen educational policy and quality as well as to ensure that everyone has equal access to basic education. The improvement of access and quality of education in the world is becoming as an essential factor in development, whereas the basic education (primary school), is acknowledged as a foundation of the higher educational development for every country. To fulfill this goal, governments introduce several policies and procedures; however, it requires some reforms and participation from the politician, policymakers, and other stakeholders to re-examine educational policy so that it can lead to multiplication and betterment of the reforms. Educational reforms actually focus on accountability. A positive educational development and reform is very challenging and needs more effort and strategy on how to use and utilize the resources effectively as such it can achie...
发表评论
阅读全文

Electron Spin and Proton Spin in the Hydrogen and Hydrogen-Like Atomic Systems

Read full paper at: http://www.scirp.org/journal/PaperInformation.aspx?PaperID=52202#.VIj7tMnQrzE Author(s) Stanisław Olszewski * Affiliation(s) Institute of Physical Chemistry, Polish Academy of Sciences, Warsaw, Poland . ABSTRACT The mechanical angular momentum and magnetic moment of the electron and proton spin have been calculated semiclassically with the aid of the uncertainty principle for energy and time. The spin effects of both kinds of the elementary particles can be expressed in terms of similar formulae. The quantization of the spin motion has been done on the basis of the old quantum theory. It gives a quantum number n = 1/2 as the index of the spin state acceptable for both the electron and proton ...
发表评论
阅读全文