Developed S2PL in Transaction Concurrency with Emphasis on Deletion of Convoy Phenomenon and Improvement of Starvation of Transactions

The investigation on the concurrency control has led to develop more algorithms for concurrency control. Most of these algorithms are based on three basic mechanisms like locking, timestamp and optimistic concurrency control. The key issue of this paper is the method of strict two phase locking and the aim is to improve this method. The S2PL method under particular circumstances has reached a deadlock and it leads to problems such as convoy phenomenon. The proposed method and the results obtained from the implementation of transaction show that this method not only resolves the convoy phenomena, it also increases the efficiency of process in transaction and paves the way for starvation issue of transaction to win the required resources