Storage Optimization in Distributed Environments using Optimistic Concurrency Control

Vipul Kumar Bondugula

doi:10.71097/IJSAT.v15.i2.4755

Storage Optimization in Distributed Environments using Optimistic Concurrency Control

Author(s)	Vipul Kumar Bondugula
Country	India
Abstract	Multi-Version Concurrency Control (MVCC) is a database management technique that enables concurrent access to a database while maintaining consistency and isolation between transactions. By maintaining multiple versions of records, MVCC allows readers to access older versions of data while writers update the current version, ensuring that each transaction gets a consistent snapshot of the data without being blocked by others. This reduces the need for locks, allowing higher concurrency and better performance, especially in read-heavy environments. Each transaction is assigned a timestamp to determine which version of the data it can access, and older versions are eventually cleaned up through garbage collection. While MVCC provides high throughput and scalability, it introduces storage overhead due to the need to store multiple versions and can become complex as the number of versions grows. Additionally, MVCC can face issues like phantom reads and write skew, especially in transactions with complex interactions. Despite these challenges, MVCC is widely used in distributed and relational database systems, such as PostgreSQL and MySQL, to provide efficient concurrency control and ensure consistency without the need for heavy locking mechanisms. MVCC is particularly effective in environments where read and write operations are frequent, as it minimizes contention between transactions. By enabling transactions to work with a snapshot of the data, it avoids conflicts that would otherwise arise from simultaneous read and write operations. However, one downside is that the system must manage and track the various versions of each record, which can result in additional overhead for both storage and garbage collection. In some systems, when the number of versions becomes large, it may impact the system’s overall performance. It is especially beneficial in systems where many transactions read the same data concurrently while only a few perform updates. As database systems continue to evolve, improvements in MVCC implementations, such as optimized garbage collection, are helping to mitigate its limitations and enhance scalability. In conclusion, MVCC strikes a balance between concurrency and consistency, making it an ideal choice for certain high-performance, multi-user applications. This Paper addresses the storage overhead of MVCC with optimistic concurrency control.
Published In	Volume 15, Issue 2, April-June 2024
Published On	2024-06-06
DOI	https://doi.org/10.71097/IJSAT.v15.i2.4755
Short DOI	https://doi.org/g9hnpz

View / Download PDF File

doi

CrossRef DOI is assigned to each research paper published in our journal.

IJSAT DOI prefix is
10.71097/IJSAT

Downloads

Research Paper Format Copyright Permission Form and Undertaking Form Cover Page Vol 15 Isu 4 Cover Page Vol 15 Isu 3 Cover Page Vol 15 Isu 2

All research papers published on this website are licensed under Creative Commons Attribution-ShareAlike 4.0 International License, and all rights belong to their respective authors/researchers.

CC-BY-SA

About IJSAT Fees & Payment Current Issue Publication Archive	Submit Research Paper Track Submission Status Publication Guidelines Publication Ethics Peer Review & Plagiarism	Join as a Reviewer Editors & Reviewers Reviewer Referral Program Get Reviewer Membership Certi.	Website/Journal Policies Usage Policy Content Policies Privacy Policy

Contact Us	Message on WhatsApp	+91-9687-182-185	editor@ijsat.org

International Journal on Science and Technology

A Widely Indexed Open Access Peer Reviewed Multidisciplinary Bi-monthly Scholarly International Journal

Storage Optimization in Distributed Environments using Optimistic Concurrency Control

Share this