Translating and Optimizing SQL Queries Having Aggregates
Summary: Defines SQL aggregate semantics via extended relational calculus, correctly handling NULLs and empty inputs. Derives algebraic optimization strategies by treating aggregates as functions over referenced free-variable attributes, avoiding unneeded computation and enabling correct empty-relation handling. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Günter von Bültzingsloewen (Forschungszentrum Informatik; University of Karlsruhe)
BibTeX Citation
@article{bultzingsloewen_vldb87,
title = {{Translating and Optimizing SQL Queries Having Aggregates}},
author = {von Bültzingsloewen, Günter},
journal = {PVLDB},
series = {{VLDB} '87},
year = {1987}
}Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,362 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00011032204 |
| 13,095 | A Uniform Approach to Processing Temporal Queries | 1992 | VLDB | 5.093636e-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.0024089429 |
| 4,310 | On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates | 1985 | VLDB | 6.7677766e-05 |
| 5,352 | Range Nesting: A Fast Method To Evaluate Quantified Queries | 1983 | SIGMOD | 6.2528892e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 554 | Answering Queries with Aggregation Using Views | 1996 | VLDB |
| 2 | 869 | Rewriting Aggregate Queries Using Views | 1999 | PODS |
| 3 | 12,727 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD |
| 4 | 2,238 | Deciding Equivalences among Aggregate Queries | 1998 | PODS |
| 5 | 198 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB |
| 6 | 7,137 | Rule-Based Translation of Relational Queries into Iterative Programs | 1986 | SIGMOD |
| 7 | 12,315 | Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations | 2012 | SIGMOD |
| 8 | 4,310 | On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates | 1985 | VLDB |
| 9 | 4,574 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB |
| 10 | 1,860 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |