Version Locking Mechanism in Database
Journal Title: International Journal of Innovative Research in Computer Science and Technology - Year 2020, Vol 8, Issue 3
Abstract
The distributed database provides a resource sharing environment, where multiple transactions at different sites coexist in order to access the resources. In this paper we investigate multi version locking protocol in distributed environment. Multi-version database has the potential to significantly increase the amount of concurrency in transaction processing as they can avoid read-write conflict by completing the read requests with older versions of data while the write operation is in progress. These algorithms are particularly effective for long queries, which otherwise cannot finish due to the high probability of conflict with other transactions. We have given an improvement on the algorithm proposed by Jie shao. We have not imposed any restriction on the involvement of all the existing sites to obtain a global version which thereby reduces the burden on each individual site. Our scheme involves the collection of local transaction identifier only from the participating site whether it can be one or many. We have proposed our new algorithm to obtain a correct version for a particular data item during read and write operation.
Authors and Affiliations
Swati
Keywords
Related Articles
- EP ID EP747803
- DOI 10.21276/ijircst.2020.8.3.8
- Views 34
- Downloads 0
A Review Paper on Digital Advertising
Despite the constantly increasing spending on digital advertising, the efficiency of the ecosystem's operating is becoming more apparent. This is because just a tiny portion of the money spent by businesses on different...
A Design of Hybrid Energy Storage System for Electric Vehicles
Recently, Electronic Vehicles (EVs) have been attracted substantial responsiveness and so did the advance in battery equipment. Although the battery technology has been significantly advanced, the available batteries do...
Smart Helmet Implementation using GSM Module
India is the second most populous country in the world, and it has a lot of young people. These days, young people like riding bikes, but because it's cool, they don't wear helmets. Because of these things, there are mor...
Stabilization of Black Cotton Soil Using Red Mud and Hydrated Lime
This research paper is an effort to use those materials which are disposed as wastes for stabilizing the soil and making the process cost effective. In this research work, two waste materials such as Red Mud and Hydrated...
Design and Comparative Study of Overhead Tank Subjected to Seismic Forces in Different Zones
Overhead tank are generally classified as Ordinary Moment Resisting Frame (OMRF) and Special Moment Resisting Frame (SMRF) supported response reduction factor. Generally, the Overhead tank consists of structural members...