Speculation-based protocols for improving the performance of read-only transactions
by T. Ragunathan, P. Krishna Reddy
International Journal of Computational Science and Engineering (IJCSE), Vol. 5, No. 3/4, 2010

Abstract: A read-only transaction (ROT) does not modify any data. The main issues regarding processing of ROTs are correctness, data currency and performance. Even though the popular two-phase locking (2PL) protocol processes the ROTs correctly with no correctness related issues, its performance deteriorates as data contention increases. Snapshot isolation (SI)-based protocols have been proposed in the literature to improve the performance. However, the SI-based protocols compromise both correctness and data currency aspects. In the literature, speculative locking (SL) approach has been proposed to improve the transaction performance in online transaction processing environments. In this paper, we have proposed efficient speculation-based protocols to improve the performance of ROTs by exploiting features specific to ROT environment. The performance results show that the proposed protocols improve the performance of ROTs over 2PL and SI-based protocols with manageable extra processing resources. Further, the proposed protocols process transactions without any correctness and data currency related issues.

Online publication date: Fri, 24-Dec-2010

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Computational Science and Engineering (IJCSE):
Login with your Inderscience username and password:

Username:        Password:          Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com