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,582 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00011265079 |
| 12,901 | A Uniform Approach to Processing Temporal Queries | 1992 | VLDB | 4.1945683e-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.0040449103 |
| 4,006 | On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates | 1985 | VLDB | 6.5410994e-05 |
| 5,093 | Range Nesting: A Fast Method To Evaluate Quantified Queries | 1983 | SIGMOD | 5.7026228e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 584 | Answering Queries with Aggregation Using Views | 1996 | VLDB | 0.0001971526 |
| 971 | Rewriting Aggregate Queries Using Views | 1999 | PODS | 0.00014925576 |
| 12,534 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD | 4.1945683e-05 |
| 2,103 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5385023e-05 |
| 218 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00033503922 |
| 6,554 | Rule-Based Translation of Relational Queries into Iterative Programs | 1986 | SIGMOD | 5.0155947e-05 |
| 12,118 | Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations | 2012 | SIGMOD | 4.1945683e-05 |
| 4,006 | On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates | 1985 | VLDB | 6.5410994e-05 |
| 3,577 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB | 6.9504079e-05 |
| 1,754 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB | 0.00010670609 |