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: 3635
Venue: SIGMOD
Year: 2004
Pagerank: 5.5124391e-05
Overall Rank: 7,987 | 45.21%
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,750	Lazy Maintenance of Materialized Views	2007	VLDB	9.8392477e-05
8,109	Relational Support for Flexible Schema Scenarios	2008	VLDB	5.4843869e-05
9,440	In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework	2024	SIGMOD	5.2680376e-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	687	Sequence Query Processing	1994	SIGMOD
2	1,362	Execution Strategies for SQL Subqueries	2007	SIGMOD
3	6,269	From XML view updates to relational view updates: old solutions to a new problem	2004	VLDB
4	1,860	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
5	7,321	Update-Pattern-Aware Modeling and Processing of Continuous Queries	2005	SIGMOD
6	12,231	On the Expressive Power of Update Primitives	2013	PODS
7	6,107	Adaptive Query Processing: Why, How, When, What Next	2006	SIGMOD
8	2,772	Updating XML	2001	SIGMOD
9	10,342	Approximate Query Processing under Updates	2026	SIGMOD
10	12,637	Effective and Efficient Update of XML in RDBMS	2007	SIGMOD