TY  - JOUR
T1  - Transactional Workflow Technique for Distributed Transaction Processing
AU - Ibrahim, Romani Farid 
JO  - International Journal of Soft Computing
VL  - 12
IS  - 5
SP  - 343
EP  - 350
PY  - 2017
DA  - 2001/08/19
SN  - 1816-9503
DO  - ijscomp.2017.343.350
UR  - https://makhillpublications.co/view-article.php?doi=ijscomp.2017.343.350
KW  - Transaction
KW  -concurrency control
KW  -two phase commit protocol
KW  -long-lived transaction
KW  -distributed database
KW  -mobile database
KW  -workflow
KW  -shadow paging
KW  -saga
KW  -caching
KW  -compensation
AB  - 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.
ER  -