International Journal of Soft Computing

Year: 2017
Volume: 12
Issue: 5
Page No. 343 - 350

Transactional Workflow Technique for Distributed Transaction Processing

Authors : Romani Farid Ibrahim

Abstract: Two Phase Commit Protocol (2PC) is an atomic and synchronous protocol and it is the common protocol uses to coordinate the commitment of transactions in distributed database systems. Most current database systems use page, level and locks technique to lock data items while transactions processing, other transactions can’t access all records in the page while the update of a record in that page. If locks are released quickly from data items, other transactions can access these records. In this study, we propose a modification to the standard two phase commit protocol to release data items locks quickly after the preparation phase. Participants doesn’t locks data items until the end of the transaction. We propose a two Phase Commit Protocol with Incomplete state (2PC-I) which avoids the system blocking problem and ensures semantic ACID properties. We propose a transactional workflow technique as an optimistic concurrency control technique that uses (2PC-I) and actionability rules to handle the disconnection in transactions processing and increase the success rate of transactions. We implemented a simulation prototype for the 2PC-I protocol and transactional workflow technique to test the applicability of the 2PC-I protocol and measure the success rate of transactions.

How to cite this article:

Romani Farid Ibrahim , 2017. Transactional Workflow Technique for Distributed Transaction Processing. International Journal of Soft Computing, 12: 343-350.

Design and power by Medwell Web Development Team. © Medwell Publishing 2024 All Rights Reserved