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.1169073e-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.00023915456
951	Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates	1992	SIGMOD	0.00012887578
1,343	PolarDB Serverless: A Cloud Native Database for Disaggregated Data Centers	2021	SIGMOD	0.00010959797
1,754	On-Line Warehouse View Maintenance	1997	SIGMOD	9.7204307e-05
2,829	DB4ML – An In-Memory Database Kernel with Machine Learning Support	2020	SIGMOD	7.9592539e-05
3,635	Multiversion Query Locking	1992	VLDB	7.1451702e-05
4,282	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB	6.6865871e-05
4,763	Accelerating Analytical Processing in MVCC using Fine-Granular High-Frequency Virtual Snapshotting	2018	SIGMOD	6.4272062e-05
4,843	Analysis of Dynamic Load Balancing Strategies for Parallel Shared Nothing Database Systems	1993	VLDB	6.3824897e-05
5,921	Logical and Physical Versioning in Main Memory Databases	1997	VLDB	5.9454117e-05
6,726	Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems	2022	VLDB	5.6953141e-05
8,745	Using Versions in Update Transactions: Application to Integrity Checking	1997	VLDB	5.287666e-05
9,072	Repeating History Beyond ARIES	1999	VLDB	5.2261389e-05
10,773	Swan: Hybrid MVCC Management for Efficient Transaction Processing in LSM-Tree-Based Key-Value Stores	2026	VLDB	4.9769913e-05
13,204	Exploiting Versions for Handling Updates in Broadcast Disks	1999	VLDB	4.9769913e-05
13,233	Low-Cost Compensation-Based Query Processing	1998	VLDB	4.9769913e-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.00024269058
415	Distributed Database Concurrency Controls Using Before-Values	1981	SIGMOD	0.00018658205
662	The Implementation of An Integrated Concurrency Control and Recovery Scheme	1982	SIGMOD	0.00015001272
983	ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging	1992	SIGMOD	0.00012701317
2,081	Modular Synchronization in Multiversion Databases: Version Control and Concurrency Control	1989	SIGMOD	9.0739159e-05
5,242	Commit LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems	1990	VLDB	6.2140724e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,052	Semantics Based Transaction Management Techniques for Replicated Data	1988	SIGMOD
2	5,921	Logical and Physical Versioning in Main Memory Databases	1997	VLDB
3	7,687	Consistency of Versions in Object-Oriented Databases	1990	VLDB
4	170	High-Performance Concurrency Control Mechanisms for Main-Memory Databases	2012	VLDB
5	10,140	Robustness against Read Committed for Transaction Templates	2021	VLDB
6	6,726	Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems	2022	VLDB
7	7,215	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,282	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB