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: hc5617f8b9ec7fef5
Venue: SIGMOD
Year: 2004
Pagerank: 5.3912745e-05
Overall Rank: 8,143 | 45.26%
DOI: 10.1145/1007568.1007665

Incoming Non-self Citations Over Time

Authors

1. César A. Galindo-Legaria (Microsoft)
2. Stefano Stefani (Microsoft)
3. Florian Waas (Microsoft)

BibTeX Citation

@inproceedings{galindolegaria_sigmod04,
        title = {{Query Processing for SQL Updates}},
        author = {Galindo-Legaria, César A. and Stefani, Stefano and Waas, Florian},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007665},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007665},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,779	Lazy Maintenance of Materialized Views	2007	VLDB	9.6583009e-05
8,289	Relational Support for Flexible Schema Scenarios	2008	VLDB	5.3614788e-05
9,148	In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework	2024	SIGMOD	5.2189946e-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
1	706	Sequence Query Processing	1994	SIGMOD
2	6,391	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB
3	1,378	Execution Strategies for SQL Subqueries	2007	SIGMOD
4	1,898	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
5	7,462	Update-Pattern-Aware Modeling and Processing of Continuous Queries	2005	SIGMOD
6	12,522	On the Expressive Power of Update Primitives	2013	PODS
7	6,198	Adaptive Query Processing: Why, How, When, What Next	2006	SIGMOD
8	2,833	Updating XML	2001	SIGMOD
9	10,544	Approximate Query Processing under Updates	2026	SIGMOD
10	12,927	Effective and Efficient Update of XML in RDBMS	2007	SIGMOD