A survey of Commit Protocols in Distributed Real Time database systems

International Journal of Computer Trends and Technology (IJCTT)          
© 2016 by IJCTT Journal
Volume-31 Number-2
Year of Publication : 2016
Authors : Fadia A. Elbagir, Ahmed Khalid, Khalid Khanfar
DOI :  10.14445/22312803/IJCTT-V31P111


Fadia A. Elbagir, Ahmed Khalid, Khalid Khanfar "A survey of Commit Protocols in Distributed Real Time database systems". International Journal of Computer Trends and Technology (IJCTT) V31(2):61-66, January 2016. ISSN:2231-2803. www.ijcttjournal.org. Published by Seventh Sense Research Group.

Abstract -
The commit processing in a Distributed Real Time Database (DRTDBS) can significantly increase execution time of a transaction. Therefore, designing a good commit protocol is important for the DRTDBS; the main challenge is the adaptation of standard commit protocol into the real time database system and so, decreasing the number of missed transaction in the systems. In these papers we review the basic commit protocols and the other protocols depend on it, for enhancing the transaction performance in DRTDBS. We propose a new commit protocol for reducing the number of transaction that missing their deadline.

[1] Ahmad Waqas et al., "Transaction Management Techniques And Practices In Current Cloud Computing Environments : A Survey", International Journal of Database Management Systems ( IJDMS ) Vol.7, No.1, February 2015
[2] Anup A. Dange, Prof. Neha Khatri-Valmik ," Analysis of Scheduling Nested Transactions in Distributed Real-Time Environment", International Journal of Engineering Research and General Science Volume 2, Issue 6, October-November, 2014 ISSN 2091-2730.
[3] Bandaru Vishnu Roopini ,"Transaction Management Policy in Distributed Real Time System", International Journal of Soft Computing and Engineering (IJSCE) ISSN: 2231-2307, Volume-3, Issue-2, May 2013
[4] Butler Lampson and David Lomet ," A New Presumed Commit Optimization for Two Phase Commit", Proceedings of the 10th VLDB Conference, Dublin, Ireland, 1998
[5] C Pang, K Lam ," On Using Similarity for Resolving Conflicts at Commit in Mixed Distributed Real-time Databases", Proceedings of the 5th International Conference on Real-Time Computing Systems and Applications, 1998.
[6] C. MOHAN et al, "Transaction Management in the R* Distributed Database Management System", ACM Transactions on Database Systems, Vol. 11, No. 4, December 1986, Pages 373-396.
[7] Giuseppe Congiu et al., "One Phase Commit: A Low Overhead Atomic Commitment Protocol for Scalable Metadata Services", 2012 IEEE International Conference on Cluster Computing Workshops, 978-0-7695-4844-9/12 $26.00 © 2012 IEEE DOI 10.1109/ClusterW.2012.16- 9
[8] Gunjan Verma et al ,"Transaction Processing and Management in Distributed Database Systems", IJCST Vol. 2, Issue 3, September 2011 ISSN : 2229-4333(Print) | ISSN : 0976-8491(Online)
[9] Himanshu Dubey et al, "Enhancer- A Time Commit Protocol", International Journal of Advanced Research in Computer Engineering & Technology (IJARCET) Volume 1, Issue 10, December 2012
[10] Inseon Lee & Heon Y. Yeom,"A Single Phase Distributed Commit Protocol for Main Memory Database Systems", International, IPDPS 2002, - ieeexplore.ieee.org –
[11] Inseon Lee et al ," A New Approach for Distributed Main Memory Database Systems: Causal Commit Protocol", LEE Inseon, P Taesoon - IEICE Transactions on Information, 2004 - search.ieice.org.-
[12] J.R. Haritsa et al. The PROMPT Real Time Commit Protocol", IEEE Transactions On Parallel And Distributed Systems, Vol. Xx, No. Y, Month 1999
[13] Lam et al, "Resolving executing-committing conflicts in distributed real-time database systems". J. Comput. 42(8), 674–692 (1999), In: Proceedings of the Third IEEE International Conference on Engineering of Complex Computer Systems, Como, Italy, 8–12 September 1997, pp. 49–58 (1997)
[14] LI Taoshen, SONG Qingzhen, "On the Open One-Phase Atomic Commit Protocol", computer Science Applications and Education Vol.3 No.2 November 2013, 2159-8223 /© 2013 ISAEP.
[15] M.S.Khatib & Dr. Mohammad Atique , "An Analysis of Transaction Management in Distributed Real Time Databases: An Overview", (IJITR) International Journal Of Innovative Technology And Research ,Volume No.2, Issue No. 3, April – May 2014, 985 – 990
[16] Maha Abdallah et al, "One Phase Commit Does it makes sense? ,This work has been partially funded by the CEC under the OpenDREAMS Esprit project n°20843, All Rights Reserved © 2012 IJARCET
[17] Mandeep Kaur & Harpreet Kaur, "Concurrency Control in Distributed Database System", International Journal of Advanced Research in Computer Science and Software Engineering ISSN: 2277 128X, Volume 3, Issue 7, July 2013
[18] Nadia Noual et. al ., "Protocols for committing Mobile Transactions", The International Arab Journal of Information Technology, vol.3 ,No 2, April 2006
[19] Nitesh Kumar et al., "Enhanced c One Phase Commit Protocol in Transaction Management", International Journal of Soft Computing and Engineering (IJSCE) ISSN: 2231-2307, Volume-3, Issue-4, September 2013
[20] Peter M. Spiro et al., "Designing an Optimized Transaction Commit Protocol", Digital Technical Journal Vol. 3 No. 1 Winter 1991
[21] Poonam Singh et al, "An Extended Three Phase Commit Protocol for Concurrency Control in Distributed Systems", International Journal of Computer Applications (0975 – 8887) Volume 21– No.10, May 2011
[22] Q. Biao et al., "A commit Strategy for Distributed Real Time transaction, J. computer. Sci. & Technol., Vol 18, No 5, pp.626- 631, Sept.2003
[23] QIN Biao, LIU Yun-sheng, "Distributed Real-Time Transaction Commit Processing", 1000-9825/2002/13(08)1395-07 ©2002 Journal of Software, Vol.13, No.8
[24] R .Gupta et al., Commit processing in distributed real time database systems . In Proc. the 17th IEEE Real- Time Systems Syrup., Oct. 1996, pp.220-22929.
[25] R .Gupta et al.(1997) ,More optimistic about real-time distributed commit processing. In Proc. the 18th IEEE Real-Time Systems Symp., Oct. 1997, pp.123-133.
[26] R .Gupta et al. , Revisiting Commit processing in distributed database systems , ACM SIGMOD Record, 1997 - dl.acm.org
[27] R. Haritsa & k. Ramamrithamt, Adding PEP to Real-Time Distributed Commit Processing , 0-7695-0900-2/00 $10.00 0 2000 IEEE
[28] R. Haritsa et al., The PROMPT Real-Time Commit Protocol , IEEE Transactions On Parallel And Distributed Systems, VOL. 11, NO. 2, FEBRUARY 2000
[29] Rabin Kumar Singh et al., FIVE: A Real-Time Commit Protocol , International Journal of Computer Applications (0975 – 8887) Volume 13– No.5, January 2011
[30] S. Agrawal et al., SPEEDITY-A Real Time Commit Protocol , ©2010 International Journal of Computer Applications (0975 – 8887) Volume 1 – No. 3.
[31] Saud A. Aldarmi, Real-Time Database Systems: Concepts and Design Department of Computer Science the University of York. 1998)
[32] Shetan Ram Choudhary et al, Performance Evaluation of Real Time Database Systems in Distributed Environment , Int.J. Computer Technology & Applications, Vol4 (5), 785-792. ISSN:2229-6093- (Sept-Oct 2013),
[33] Shetan Ram Choudhary&, Dr. C.K. Jha, Performance Transaction‘s Assessment Of Real Time Database System In Distributed Environment , International Journal of Engineering Trends and Technology (IJCTT) – Volume 4 Issue 9- Sep 2013 - 33
[34] Shishir Kumar&Sonali Barvey, Non-Blocking Commit Protocol , IJCSNS International Journal of Computer Science and Network Security, VOL.9 No.8, August 2009. – 33
[35] Tanuja Shukla & Radha Krishna Rambola, Perfect Commit Protocol for Distributed Database System: Analysis Review , International Journal of Advanced Research in Computer Science and Software Engineering, Volume 5, Issue 11, November 2015, ISSN: 2277 128X.- 34
[36] Teresa K. Abuya et al., A Clustering Algorithm in Two-Phase Commit Protocol for Optimizing Distributed Transaction Failure , International Journal of Computer Science and Mobile Computing IJCSMC, Vol.4 Issue.3, March- 2015, pg. 97-106, ISSN 2320– 088X. –
[37] Teresa K. Abuya et al, An Improved Failure Recovery Algorithm In Two-Phase Commit Protocol For Transaction Atomicity , Journal of Global Research in Computer Science Journal of Global Research in Computer Science Research Paper, volume 5, No. 12, December 2014
[38] Udai Shanker et al, ACTIVE-A Real Time Commit Protocol , Wireless Sensor Network, 2, 254-263 doi:10.4236/wsn.2010.23035 Published Online March 2010 (http://www.scirp.org/journal/wsn 2010
[39] Udai Shanker et al. SWIFT—A new real time commit protocol , Distrib Parallel Databases (2006) 20:29–56 DOI 10.1007/s10619-006-8594-8
[40] Udai Shanker et al., Distributed real time database systems: background and literature review , Distrib Parallel Databases (2008) 23: 127–149 , DOI 10.1007/s10619-008-7024-5
[41] V. Manikandan et al., An Efficient Non-Blocking Two Phase Commit Protocol for Distributed Transactions , International Journal of Modern Engineering Research (IJMER) www.ijmer.com Vol.2, Issue.3, May-June 2012 pp-788-791 ISSN: 2249-6645
[42] Xiai YAN1,et al , An Improved Two-phase Commit Protocol Adapted to the Distributed Real-time Transactions , Hunan Police Academy, China(1), Hunan University, China(2), (Electrical Review), ISSN 0033-2097, R. 88 NR 5b/2012
[43] Yongik Yoon et al., Real- time Commit protocol For Distributed Real-Time Database Systems , 0-8186-7614-0/9$65 .00 0 1996 IEEE
[44] Yousef J. AlHoumaily & Panos K. Chrysanthis, 12PC: The One/Two Phase Atomic Commit Protocol , SAC‘04, March 1417, 2004, Nicosia, Cyprus. Copyright 2004 ACM 1581138121/ 03/04 ...¥ 5.00
[45] Yousef J. Al-Houmaily et al., Enhancing the performance of presumed commit protocol . In: Proceedings of the ACM Symposium on Applied Computing, San Jose, CA, USA, 28 February–1 March 1997
[46] Yumnam Somananda et al., Management of missed transactions in a distributed system through Simulation , 978-1- 4244-5540-9/10/$26.00 ©2010 IEEE

DRTDBS, Commit protocols, Commit processing, 2PC protocol, 3PC protocol, Missed Transaction, Abort Transaction.