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

Summary: Presents Commit_LSN, a lightweight LSN-based commit inference that reduces locking. Uses oldest active tx's first log to infer commit via page_LSN < Commit-LSN, enabling finer locking and higher concurrency; supports systems with or without page-LSNs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 7961
Venue: VLDB
Year: 1990
Pagerank: 5.6631051e-05
Overall Rank: 5,148 | 64.19%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. C. Mohan

Incoming Citations (Sorted by Pagerank)

Showing 16 of 16 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
174	ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes	1990	VLDB	0.00038347904
462	Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS	1991	VLDB	0.00022481092
875	Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates	1992	SIGMOD	0.00015719411
1,088	ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging	1992	SIGMOD	0.00014161003
2,378	Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions	1992	SIGMOD	8.9397925e-05
2,516	Concurrency and Recovery in Generalized Search Trees	1997	SIGMOD	8.6106981e-05
3,132	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.4984862e-05
3,523	ARIES/CSA: A Method for Database Recovery in Client-Server Architectures	1994	SIGMOD	7.0092495e-05
4,009	IBM's Relational DBMS Products: Features and Technologies	1993	SIGMOD	6.5358063e-05
5,011	A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure	1993	VLDB	5.7602438e-05
7,901	Locking Protocols for Materialized Aggregate Join Views	2003	VLDB	4.6219365e-05
8,264	Using Versions in Update Transactions: Application to Integrity Checking	1997	VLDB	4.5464184e-05
9,270	Repeating History Beyond ARIES	1999	VLDB	4.3653385e-05
12,574	Transaction support for indexed summary views	2004	SIGMOD	4.1945683e-05
12,655	An Efficient Method for Performing Record Deletions and Updates Using Index Scans	2002	VLDB	4.1945683e-05
12,703	Evolution of Groupware for Business Applications: A Database Perspective on Lotus Domino/Notes	2000	VLDB	4.1945683e-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
174	ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes	1990	VLDB	0.00038347904
3,326	LOG Write-Ahead Protocols and IMS/VS Logging	1983	PODS	7.2209504e-05
4,271	ARIES/NT: A Recovery Method Based on Write-Ahead Logging for Nested Transactions	1989	VLDB	6.3065527e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
12,887	An Approach to Eliminate Transaction Blocking in Locking Protocols	1992	PODS	4.1945683e-05
7,040	Contention-Aware Lock Scheduling for Transactional Databases	2018	VLDB	4.854418e-05
14,249	Safety Of Non-Well-Locked Transaction Systems	1986	PODS	-
13,052	An Experimental Comparison of Locking Policies in a Testbed Database System	1983	SIGMOD	4.1945683e-05
1,739	Precision Locks	1981	SIGMOD	0.00010719584
12,744	Low-Cost Compensation-Based Query Processing	1998	VLDB	4.1945683e-05
4,923	Using Delayed Commitment in Locking Protocols for Real-Time Databases	1992	SIGMOD	5.8232144e-05
4,519	Controlled Lock Violation	2013	SIGMOD	6.1176534e-05
6,341	An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems	2002	VLDB	5.1037155e-05
5,011	A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure	1993	VLDB	5.7602438e-05