![Open Access](https://i-scholar.in/lib/pkp/templates/images/icons/fulltextgreen.png)
![Restricted Access](https://i-scholar.in/lib/pkp/templates/images/icons/fulltextred.png)
![Open Access](https://i-scholar.in/lib/pkp/templates/images/icons/fulltextgreen.png)
![Open Access](https://i-scholar.in/lib/pkp/templates/images/icons/fulltext_open_medium.gif)
![Restricted Access](https://i-scholar.in/lib/pkp/templates/images/icons/fulltextred.png)
![Restricted Access](https://i-scholar.in/lib/pkp/templates/images/icons/fulltext_restricted_medium.gif)
An Empirical Study on Extension of Three Phase Commit Protocol for Concurrency Control in Distributed System
Subscribe/Renew Journal
In distributed system two phase commit protocol and three phase commit protocol are used for concurrency control. But both protocol has disadvantage of blocking and global abortion (of transaction) respectivily. In my research paper, I have designed an algorithm for successfully submition of transaction even if any site (primary or secondary site) has voted to abort. For this I have used a table TIT (Transaction Information Table) which has three fields namely-1) Transaction Id 2) Site Id 3) Value and three messages for communication purpose between sites. I have also used a local clock which run at regular interval for checking the value of database object (describe in detail in further part of paper). For any transaction if any site votes to abort so it's save TIT's value="Inconsistent" with respect to that site and transaction on other sites commit suceessfully. So there is inconsistency that has arisen. To remove this inconsistency I have introduced the concept of local clock which runs at each site. This clock runs at regular intervals and checks for the database objects for which the TIT's value="Inconsistent". Then it issues a transaction to remove this inconsistency. Recovery transaction will be originated by coordinator through message passing. After receiving the message inconsistent site will update its database by fetching the transaction related information from either their nearest site or the coordinator.
Keywords
Concurrency Control, Two-phase Commit Protocol, Three Phase Commit Protocol, Primary Sites, Secondary Sites
Subscription
Login to verify subscription
User
Font Size
Information
- Tanenbaum, A. S. (2006). Distributed Systems: Principles and Paradigms (2nd Ed.).
- Silberchatz, A., Korth, H. F. & Sudarshan, S. (1983). Datbase System Concepts-Fundamentals of Database (4thEd.). Tata McGraw Hills.
- http://en.wikipedia.org/wiki/Threephase_commit_protocol
- Power Point presentation of IIT Kharagpur. Retrieved from http://www.facweb.iitkgp.ernet.in/~pallab/dist_sys/Lec-11-CommitProtocols.pdf
![](https://i-scholar.in/public/site/images/abstractview.png)
Abstract Views: 509
![](https://i-scholar.in/public/site/images/pdfview.png)
PDF Views: 6