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 1
- Downloads 0
Cloud Storage Architecture: Issues, Challenges and Opportunities
With the advent of new emerging technologies like fog computing, internet of things, blockchain, artificial intelligence etc, information and communication technology is revolutionising our homes, education, health and i...
Natural Language Processing: An Approach to Aid Emergency Services in COVID-19 Pandemic
In the recent years, Natural Language Processing (NLP) has been widely adopted in numerous applications to organize and structure knowledge to accomplish tasks like translation, summarization, named entity recognition, r...
A Study on Digital Mode Classes During COVID -19 and Its Level of Satisfaction On Online Education Among School Students in Delhi NCR
Around the world, online learning as well as classes are becoming a bigger part of the educational system. COVID-19 has caused a tremendous upheaval in the educational system, not only in India but globally. Virtual clas...
Ethylene Glycol: Kinetics of the Formation from Methanol–Formaldehyde Solutions
The mechanism and kinetics are developed for the initiated nonbranched-chain formation of ethylene glycol in methanol–formaldehyde solutions at formaldehyde concentrations of 0.1–3.1 mol dm–3 and temperatures of 373–473...
Study of Thermal and Optical Sensitivity of Higher Thermo luminescence Glow Peaks in Synthetic Quartz Material
In the present scenario, 600 oC and 1000 oC annealed synthetic quartz material were irradiated by beta doses. The thermoluminescence glow curves are recorded for treated sample under influence of optical bleaching temper...