Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions

Summary: Proposes transient versioning enabling read-only access to run without locks, returning slightly stale yet consistent versions with indexed access. Configurable version retention, partial rollbacks, per-record versioning, distributed commit support. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h2c5ab0067ba7710b
Venue: SIGMOD
Year: 1992
Pagerank: 9.1199209e-05
Overall Rank: 2,052 | 86.21%
DOI: 10.1145/130283.130306

Incoming Non-self Citations Over Time

Authors

1. C. Mohan (IBM)
2. Hamid Pirahesh (IBM)
3. Raymond Lorie (IBM)

BibTeX Citation

@inproceedings{mohan_sigmod92,
        title = {{Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions}},
        author = {Mohan, C. and Pirahesh, Hamid and Lorie, Raymond},
        series = {{SIGMOD} '92},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/130283.130306},
        url = {https://dl.acm.org/doi/10.1145/130283.130306},
        year = {1992}
}

Incoming Citations (Sorted by Pagerank)

Showing 16 of 16 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
228	Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems	2015	SIGMOD	0.00023920439
951	Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates	1992	SIGMOD	0.00012893557
1,343	PolarDB Serverless: A Cloud Native Database for Disaggregated Data Centers	2021	SIGMOD	0.00010963588
1,753	On-Line Warehouse View Maintenance	1997	SIGMOD	9.7248839e-05
2,830	DB4ML – An In-Memory Database Kernel with Machine Learning Support	2020	SIGMOD	7.9619979e-05
3,635	Multiversion Query Locking	1992	VLDB	7.1481477e-05
4,284	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB	6.688627e-05
4,761	Accelerating Analytical Processing in MVCC using Fine-Granular High-Frequency Virtual Snapshotting	2018	SIGMOD	6.4302502e-05
4,841	Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems	1993	VLDB	6.3854243e-05
5,919	Logical and Physical Versioning in Main Memory Databases	1997	VLDB	5.9478104e-05
6,959	Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems	2022	VLDB	5.633832e-05
8,737	Using Versions in Update Transactions: Application to Integrity Checking	1997	VLDB	5.2901534e-05
9,532	Repeating History Beyond ARIES	1999	VLDB	5.1644268e-05
10,763	Swan: Hybrid MVCC Management for Efficient Transaction Processing in LSM-Tree-Based Key-Value Stores	2026	VLDB	4.9793485e-05
13,198	Exploiting Versions for Handling Updates in Broadcast Disks	1999	VLDB	4.9793485e-05
13,227	Low-Cost Compensation-Based Query Processing	1998	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
221	ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes	1990	VLDB	0.00024274803
414	Distributed Database Concurrency Controls Using Before-Values	1981	SIGMOD	0.00018666132
660	The Implementation of An Integrated Concurrency Control and Recovery Scheme	1982	SIGMOD	0.00015008043
983	ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging	1992	SIGMOD	0.00012706526
2,078	Modular Synchronization in Multiversion Databases: Version Control and Concurrency Control	1989	SIGMOD	9.0776707e-05
5,237	Commit LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems	1990	VLDB	6.2170143e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,050	Semantics Based Transaction Management Techniques for Replicated Data	1988	SIGMOD
2	5,919	Logical and Physical Versioning in Main Memory Databases	1997	VLDB
3	7,681	Consistency of Versions in Object-Oriented Databases	1990	VLDB
4	170	High-Performance Concurrency Control Mechanisms for Main-Memory Databases	2012	VLDB
5	10,136	Robustness against Read Committed for Transaction Templates	2021	VLDB
6	6,959	Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems	2022	VLDB
7	7,213	Using Multiversion Data for Non-interfering Execution of Write-only Transactions	1991	SIGMOD
8	228	Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems	2015	SIGMOD
9	2,781	On-the-Fly, Incremental, Consistent Reading of Entire Databases	1985	VLDB
10	4,284	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB