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 45
- Downloads 0
Securing and Secrete Image Sharing Using Visual Cryptography Scheme
To verify identity of person his /her physical or behavioural characteristics can be use,this strategy is called as Biometrics. Preservation of privacy of digital biometric data such as iris,face images etc. which stored...
VANET-OLSR Cooperative Cross-Layer Detection for Black hole Attacks
In this study, we address the issue of detecting hot spot problem targeting Multi Point Relays (MPRs) using Vehicular Ad hoc channels Reactive Routing protocol (VANET-OLSR). To identify network-related threats, a watchdo...
An Analysis of Economic Challenges of Fuel Cell Commercialization
Financial development should depend on more harmless to the ecosystem and proficient creation processes as asset shortage, outrageous environmental change, and contamination levels rise. As a result of their high effecti...
A Novel Solution to the Synchronization Problem of CAN
One of the main problems in synchronous digital system design is synchronization of different clocks in the system. Obviously, this problem is always present in CAN bus related equipment. The problem is more acute in CAN...
Computer Vision for Color Detection
Humans see the world in colors. When it comes to the aspect of just looking, all it does is please the eyes but when it comes to questioning its make, it becomes a challenge. It is much easier to be served the values wit...