The New Locking, Logging, And Recovery Architecture of Microsoft SQL Server 7.0

Summary: SQL Server 7.0’s storage engine was rearchitected for row-level locking across update primitives, logging, recovery, and access methods. Its distinctive contribution is an incremental, continuously operational transformation, balancing engineering pragmatics against academic redesign. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 8760
Venue: VLDB
Year: 1999
Pagerank: -
Overall Rank: 14,147 | 2.94%
DOI: -

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. David Campbell (Microsoft)

BibTeX Citation

@article{campbell_vldb99,
        title = {{The New Locking, Logging, And Recovery Architecture of Microsoft SQL Server 7.0}},
        author = {Campbell, David},
        journal = {PVLDB},
        series = {{VLDB} '99},
        pages = {249},
        year = {1999}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,282	Improving OLTP Scalability using Speculative Lock Inheritance	2009	VLDB
2	2,309	A Scalable Lock Manager for Multicores	2013	SIGMOD
3	6,751	An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems	2002	VLDB
4	3,840	Fine-Grained Sharing in a Page Server OODBMS	1994	SIGMOD
5	2,924	Constant Time Recovery in Azure SQL Database	2019	VLDB
6	4,218	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB
7	4,763	Rethinking Logging, Checkpoints, and Recovery for High-Performance Storage Engines	2020	SIGMOD
8	1,420	Lightweight Locking for Main Memory Database Systems	2013	VLDB
9	2,614	Locking Key Ranges with Unbundled Transaction Services	2009	VLDB
10	11,821	Concurrent Updates to Pages with Fixed-Size Rows Using Lock-Free Algorithms	2020	VLDB