An Alternative Model to Overcoming Two Phase Commit Blocking Problem
In distributed transactions, the atomicity requirement of the atomic commitment protocol should be preserved. The two phased commit protocol algorithm is widely used to ensure that transactions in distributed environment are atomic. However, a main drawback was attributed to the algorithm, which is a blocking problem. The system will get in stuck when participating sites or the coordinator itself crashes. To address this problem a number of algorithms related to 2PC protocol were proposed such as back up coordinator and a technique whereby the algorithm passes through 3PC during failure. However, both algorithms face limitations such as multiple site and backup coordinator failures. Therefore, we proposed an alternative model to overcoming the blocking problem in combined form. The algorithm was simulated using Britonix transaction manager (BTM) using Eclipse IDE and MYSQL. In this paper, we assessed the performance of the alternative model and found that this algorithm handled site and coordinator failures in distributed transactions using hybridization (combination of two algorithms) with minimal communication messages.
. H. Garcia-Molina, J. D. Ullman, and J. Widom, Database systems: the complete book. Upper Saddle River, New Jersey Pearson Prentice, 2008. pp. 1020-1021.
. S. K. Rahimi and F. S. Haug, Distributed Database Management Systems: A Practical Approach. John Wiley & Sons, 2010. pp.185.
. L. Lou, F. Tang, I. You, M. Guo, Y. Shen, and L. Li, “An Effective Deadlock Prevention Mechanism for Distributed Transaction Management,” 2011 Fifth International Conference on Innovative Mobile and Internet Services in Ubiquitous Computing, 2011.
S. Tanenbaum and M. van. Steen, Distributed Systems: Principles and paradigms, Second edition. Upper Saddle River, New Jersey: Pearson Prentice Hall, 2007. pp 355-363.
. Lannhult, & B. Lindblom, “Review of Non-Blocking Two-Phase Commit Protocols. Master Program in Computer System Engineering”, Emausgatan C, 29. Available: http:// http://www.idt.mdh.se/kurser/ct3340/ht09/ADMINISTRATION/IRCSE09-submissions. [Mar 5, 2016].
M. Atif, “Analysis and verification of Two-Phase Commit & Three-Phase Commit Protocols,” in proc. DOI: 10.1109/ICET.2009.5353152. Dec 2009, pp. 326-331. Available: http://ieee.exolpre.org [12 march, 2016].
P. Singh, P. Yadav, A. Shukla, and S. Lohia, “An Extended Three Phase Commit Protocol for Concurrency Control in Distributed Systems,” International Journal of Computer Applications, vol. 21, no. 10, pp. 35–39, 2011. Available: http://www.ijcaonline.org/archives/volume21/number10/2596-3608 [Jan 15, 2016]
V. Manikandan, R. Ravichandran, R. Suresh, & F. S. Francis,. “An Efficient Non-Blocking Two Phase Commit Protocol for Distributed Transactions”. International Journal of Modern Engineering Research, Vol.2, Issue.3, pp. 788-791 may 2012. Available: http://www.ijmer.com. [Feb 25, 2016].
N. Kumar, L. Sahoo, and A. Kumar, “Design and implementation of Three Phase Commit Protocol (3PC) algorithm,” 2014 International Conference on Reliability Optimization and Information Technology (ICROIT), pp. 116–120, 2014.
T. K. Abuya, R. M. Rimiru, & W. K. Cheruiyot, “AN IMPROVED FAILURE RECOVERY ALGORITHM IN TWO-PHASE COMMIT PROTOCOL FOR TRANSACTION ATOMICITY”. Journal of Global Research in Computer Science, vol.5, Issue.12, pp 01-11, Dec 2014. Available: http://www.jgrcs.com. [Feb 20, 2016].
T. K. Abuya, R. M. Rimiru, & W. K. Cheruiyot, “A Clustering Algorithm in Two-Phase Commit Protocol for Optimizing Distributed Transaction Failure”. International Journal of Computer Science and Mobile Computing, vol.4, Issue.3, pp 97-106, Mar 2015. Available: http://www.ijcsmc.com [Mar 20, 2016].
Authors who submit papers with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
- By submitting the processing fee, it is understood that the author has agreed to our terms and conditions which may change from time to time without any notice.
- It should be clear for authors that the Editor In Chief is responsible for the final decision about the submitted papers; have the right to accept\reject any paper. The Editor In Chief will choose any option from the following to review the submitted papers:A. send the paper to two reviewers, if the results were negative by one reviewer and positive by the other one; then the editor may send the paper for third reviewer or he take immediately the final decision by accepting\rejecting the paper. The Editor In Chief will ask the selected reviewers to present the results within 7 working days, if they were unable to complete the review within the agreed period then the editor have the right to resend the papers for new reviewers using the same procedure. If the Editor In Chief was not able to find suitable reviewers for certain papers then he have the right to reject the paper.
- Author will take the responsibility what so ever if any copyright infringement or any other violation of any law is done by publishing the research work by the author
- Before publishing, author must check whether this journal is accepted by his employer, or any authority he intends to submit his research work. we will not be responsible in this matter.
- If at any time, due to any legal reason, if the journal stops accepting manuscripts or could not publish already accepted manuscripts, we will have the right to cancel all or any one of the manuscripts without any compensation or returning back any kind of processing cost.
- The cost covered in the publication fees is only for online publication of a single manuscript.