Online ISSN- 2457-0818

Vol 1, No 1 (2016)

Enhancing Efficiency of Long Running Transactions

Authors: Anna Dominic, Jubna T, Neenu Baby, Surekha Mariam Varghese

Abstract: Long running transactions always take long time to finish, which needs the resources - often the database - to be locked for a long time. This would bring down the performance of the transaction processing system. The normal solution is compensating transaction, which creates a relative transaction with the opposite effect. The sub-transactions are allowed to commit independently without waiting for other subtransactions. If the transaction fails, the corresponding compensating transaction will be executed so that the effect brought by the original transaction can be cancelled. However, compensating transaction model has several drawbacks. This paper proposes a novel pipeline based processing model of long transaction mainly aimed at the serially executed long transaction whose subtransactions cannot be executed concurrently since it require the result of other subtransactions. This model parallelizes the transaction processing resulting in better system performance. Our experiments show that the pipeline based processing model of serial long transaction has notable improvement when executing the long transaction.

Full Issue

View or download the full issue PDF

Table of Contents