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 |
|---|---|---|---|---|
| 812 | A Modeling Study of the TPC-C Benchmark | 1993 | SIGMOD | 0.00016408423 |
| 3,132 | Integrating Triggers and Declarative Constraints in SQL Database Systems | 1996 | VLDB | 7.4984862e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,375 | 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.0923872e-05 |
| 7,789 | Query Processing for SQL Updates | 2004 | SIGMOD | 4.6510017e-05 |
| 9,275 | Efficient Bulk Deletes for Multi Dimensional Clustered Tables in DB2 | 2007 | VLDB | 4.3645459e-05 |
| 9,031 | Extending SQL to Return a Subdatabase | 2025 | SIGMOD | 4.4039656e-05 |
| 3,096 | On Efficiently Implementing SchemaSQL on a SQL Database System | 1999 | VLDB | 7.5678495e-05 |
| 12,655 | An Efficient Method for Performing Record Deletions and Updates Using Index Scans | 2002 | VLDB | 4.1945683e-05 |
| 5,025 | Automated Statistics Collection in DB2 UDB | 2004 | VLDB | 5.7533741e-05 |
| 6,548 | Query Sampling in DB2 Universal Database | 2004 | SIGMOD | 5.0181595e-05 |
| 13,948 | Implementation of SQL3 Structured Types with Inheritance and Value Substitutability | 1999 | VLDB | - |
| 6,197 | O-O, What Have They Done to DB2? | 1999 | VLDB | 5.1614115e-05 |