Commit LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems

Summary: Introduces Commit_LSN, using the oldest active updater’s first-log LSN to infer commitment for pages with lower page_LSNs, replacing many locks/latches. Enables cheaper fine-grained locking, higher concurrency, and broad adoption via extensions to partial/non-page-logging systems. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hdc41c4de125f62ce
Venue: VLDB
Year: 1990
Pagerank: 6.2170143e-05
Overall Rank: 5,237 | 64.80%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. C. Mohan (IBM)

BibTeX Citation

@article{mohan_vldb90,
        title = {{Commit LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems}},
        author = {Mohan, C.},
        journal = {PVLDB},
        series = {{VLDB} '90},
        pages = {406},
        year = {1990}
}

Incoming Citations (Sorted by Pagerank)

Showing 16 of 16 citing papers.

Rank	Citing 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
581	Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS	1991	VLDB	0.00015984359
951	Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates	1992	SIGMOD	0.00012893557
983	ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging	1992	SIGMOD	0.00012706526
2,052	Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions	1992	SIGMOD	9.1199209e-05
2,263	Concurrency and Recovery in Generalized Search Trees	1997	SIGMOD	8.7304715e-05
3,517	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.2422477e-05
3,868	ARIES/CSA: A Method for Database Recovery in Client-Server Architectures	1994	SIGMOD	6.9570919e-05
4,377	IBM's Relational DBMS Products: Features and Technologies	1993	SIGMOD	6.6282737e-05
5,503	A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure	1993	VLDB	6.1023203e-05
8,134	Locking Protocols for Materialized Aggregate Join Views	2003	VLDB	5.3930626e-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
13,057	Transaction support for indexed summary views	2004	SIGMOD	4.9793485e-05
13,138	An Efficient Method for Performing Record Deletions and Updates Using Index Scans	2002	VLDB	4.9793485e-05
13,186	Evolution of Groupware for Business Applications: A Database Perspective on Lotus Domino/Notes	2000	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 3 of 3 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
4,967	ARIES/NT: A Recovery Method Based on Write-Ahead Logging for Nested Transactions	1989	VLDB	6.3352338e-05
5,243	LOG Write-Ahead Protocols and IMS/VS Logging	1983	PODS	6.2141493e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	13,371	An Approach to Eliminate Transaction Blocking in Locking Protocols	1992	PODS
2	6,479	Contention-Aware Lock Scheduling for Transactional Databases	2018	VLDB
3	14,761	Safety Of Non-Well-Locked Transaction Systems	1986	PODS
4	13,541	An Experimental Comparison of Locking Policies in a Testbed Database System	1983	SIGMOD
5	2,200	Precision Locks	1981	SIGMOD
6	13,227	Low-Cost Compensation-Based Query Processing	1998	VLDB
7	5,416	Using Delayed Commitment in Locking Protocols for Real-Time Databases	1992	SIGMOD
8	3,932	Controlled Lock Violation	2013	SIGMOD
9	6,870	An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems	2002	VLDB
10	5,503	A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure	1993	VLDB