Returning Modified Rows – SELECT Statements with Side Effects
Summary: Nested DML in SELECT returns modified rows in a single unit of work, enabling fetch of affected rows without extra queries. Pipelined changes across tables, no procedural code, reduce I/O, CPU, and deadlocks; ETL gains and better performance on TPC-C. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Andreas Behm
- 2. Serge Rielau
- 3. Richard Swagerman
Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 810 | A Modeling Study of the TPC-C Benchmark | 1993 | SIGMOD | 0.00016389243 |
| 3,140 | Integrating Triggers and Declarative Constraints in SQL Database Systems | 1996 | VLDB | 7.4912441e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,374 | 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 | 5.0874998e-05 |
| 7,788 | Query Processing for SQL Updates | 2004 | SIGMOD | 4.6465948e-05 |
| 9,279 | Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2 | 2007 | VLDB | 4.3607717e-05 |
| 9,034 | Extending SQL to Return a Subdatabase | 2025 | SIGMOD | 4.3997447e-05 |
| 3,101 | On Efficiently Implementing SchemaSQL on a SQL Database System | 1999 | VLDB | 7.5611936e-05 |
| 12,664 | An Efficient Method for Performing Record Deletions and Updates Using Index Scans | 2002 | VLDB | 4.1905499e-05 |
| 5,019 | Automated Statistics Collection in DB2 UDB | 2004 | VLDB | 5.7492033e-05 |
| 6,543 | Query Sampling in DB2 Universal Database | 2004 | SIGMOD | 5.0139217e-05 |
| 13,962 | Implementation of SQL3 Structured Types with Inheritance and Value Substitutability | 1999 | VLDB | - |
| 6,199 | O-O, What Have They Done to DB2? | 1999 | VLDB | 5.1564406e-05 |