Translating and Optimizing SQL Queries Having Aggregates
Summary: Defines precise semantics for SQL with aggregates by translating queries into an extended relational calculus. Proposes a calculus-to-relational-algebra transformation to improve aggregation optimization by treating aggregates as functions over referenced attributes and using selective evaluation to avoid empty/duplicate work. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,581 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00011262795 |
| 12,911 | A Uniform Approach to Processing Temporal Queries | 1992 | VLDB | 4.1905499e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 3 of 3 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0040465394 |
| 4,008 | On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates | 1985 | VLDB | 6.5357979e-05 |
| 5,093 | Range Nesting: A Fast Method To Evaluate Quantified Queries | 1983 | SIGMOD | 5.6972661e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 335 | Optimization of Real Conjunctive Queries | 1993 | PODS | 0.00027012705 |
| 971 | Rewriting Aggregate Queries Using Views | 1999 | PODS | 0.00014915911 |
| 12,543 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD | 4.1905499e-05 |
| 2,105 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5309231e-05 |
| 218 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00033489004 |
| 6,550 | Rule-Based Translation of Relational Queries into Iterative Programs | 1986 | SIGMOD | 5.0113524e-05 |
| 12,126 | Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations | 2012 | SIGMOD | 4.1905499e-05 |
| 4,008 | On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates | 1985 | VLDB | 6.5357979e-05 |
| 3,581 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB | 6.9455822e-05 |
| 1,754 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB | 0.00010663123 |