Two Phase Commit Protocol (2PC) is an atomic and synchronous protocol and it is the commonprotocol uses to coordinate the commitment of transactions in distributed database systems. Most currentdatabase systems use page, level and locks technique to lock data items while transactions processing, othertransactions can?t access all records in the page while the update of a record in that page. If locks are releasedquickly from data items, other transactions can access these records. In this study, we propose a modificationto 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 Protocolwith 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 successrate of transactions. We implemented a simulation prototype for the 2PC-I protocol and transactional workflowtechnique to test the applicability of the 2PC-I protocol and measure the success rate of transactions.
展开▼