Returning Modified Rows - SELECT Statements with Side Effects

Summary: Extends SQL with nested INSERT/UPDATE/DELETE inside SELECT, returning affected rows directly under set semantics. Eliminates follow-up queries and cursors, enabling pipelined multi-table ETL updates with fewer round trips, reduced resource use, and improved TPC-C performance. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hf449e7d3b98580d1
Venue: VLDB
Year: 2004
Pagerank: 4.9793485e-05
Overall Rank: 13,079 | 12.07%
DOI: 10.1016/B978-012088469-8.50086-3

Incoming Non-self Citations Over Time

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

Authors

1. Andreas Behm (IBM)
2. Serge Rielau (IBM)
3. Richard Swagerman (IBM)

BibTeX Citation

@article{behm_vldb04,
        title = {{Returning Modified Rows - SELECT Statements with Side Effects}},
        author = {Behm, Andreas and Rielau, Serge and Swagerman, Richard},
        journal = {PVLDB},
        series = {{VLDB} '04},
        volume = {30},
        pages = {987--998},
        doi = {10.1016/B978-012088469-8.50086-3},
        url = {https://doi.org/10.1016/B978-012088469-8.50086-3},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
936	A Modeling Study of the TPC-C Benchmark	1993	SIGMOD	0.00012983123
3,517	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.2422477e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,085	Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL	2024	CIDR
2	8,143	Query Processing for SQL Updates	2004	SIGMOD
3	9,604	Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2	2007	VLDB
4	9,360	Extending SQL to Return a Subdatabase	2025	SIGMOD
5	3,960	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB
6	13,138	An Efficient Method for Performing Record Deletions and Updates Using Index Scans	2002	VLDB
7	4,659	Automated Statistics Collection in DB2 UDB	2004	VLDB
8	6,685	Query Sampling in DB2 Universal Database	2004	SIGMOD
9	14,460	Implementation of SQL3 Structured Types with Inheritance and Value Substitutability	1999	VLDB
10	6,911	O-O, What Have They Done to DB2?	1999	VLDB