Query Processing for SQL Updates

Summary: Integrates SQL DML into the query processor, detailing update-specific execution primitives and plan analysis for SQL Server. Analyzes lookup and navigational vs set-oriented approaches, and serial vs random I/O trade-offs, presenting a robust framework that reuses core query techniques. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3573
Venue: SIGMOD
Year: 2004
Pagerank: 4.6510017e-05
Overall Rank: 7,789 | 45.82%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,022	Lazy Maintenance of Materialized Views	2007	VLDB	9.754634e-05
7,786	Relational Support for Flexible Schema Scenarios	2008	VLDB	4.6513838e-05
9,366	In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework	2024	SIGMOD	4.3493859e-05

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	Pagerank
625	Sequence Query Processing	1994	SIGMOD	0.00018980669
6,211	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.1555735e-05
1,582	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00011265079
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010670609
7,282	Update-Pattern-Aware Modeling and Processing of Continuous Queries	2005	SIGMOD	4.776631e-05
12,033	On the Expressive Power of Update Primitives	2013	PODS	4.1945683e-05
5,825	Adaptive Query Processing: Why, How, When, What Next	2006	SIGMOD	5.3126934e-05
3,046	Updating XML	2001	SIGMOD	7.65634e-05
10,049	Approximate Query Processing under Updates	2026	SIGMOD	4.1945683e-05
12,443	Effective and Efficient Update of XML in RDBMS	2007	SIGMOD	4.1945683e-05