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: 3574
Venue: SIGMOD
Year: 2004
Pagerank: 4.6465948e-05
Overall Rank: 7,788 | 45.88%
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,026	Lazy Maintenance of Materialized Views	2007	VLDB	9.7466372e-05
7,786	Relational Support for Flexible Schema Scenarios	2008	VLDB	4.6469243e-05
9,375	In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework	2024	SIGMOD	4.3452177e-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
626	Sequence Query Processing	1994	SIGMOD	0.00018961452
1,581	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00011262795
6,210	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB	5.1506157e-05
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010663123
7,280	Update-Pattern-Aware Modeling and Processing of Continuous Queries	2005	SIGMOD	4.7718173e-05
12,041	On the Expressive Power of Update Primitives	2013	PODS	4.1905499e-05
5,833	Adaptive Query Processing: Why, How, When, What Next	2006	SIGMOD	5.3083853e-05
3,051	Updating XML	2001	SIGMOD	7.6489131e-05
10,049	Approximate Query Processing under Updates	2026	SIGMOD	4.1905499e-05
12,452	Effective and Efficient Update of XML in RDBMS	2007	SIGMOD	4.1905499e-05