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,378 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00010864448 |
| 13,385 | A Uniform Approach to Processing Temporal Queries | 1992 | VLDB | 4.9793485e-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.0023947656 |
| 4,390 | On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates | 1985 | VLDB | 6.6221941e-05 |
| 5,479 | Range Nesting: A Fast Method To Evaluate Quantified Queries | 1983 | SIGMOD | 6.1132235e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 310 | Optimization of Real Conjunctive Queries | 1993 | PODS |
| 2 | 880 | Rewriting Aggregate Queries Using Views | 1999 | PODS |
| 3 | 13,017 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD |
| 4 | 2,269 | Deciding Equivalences among Aggregate Queries | 1998 | PODS |
| 5 | 202 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB |
| 6 | 7,261 | Rule-Based Translation of Relational Queries into Iterative Programs | 1986 | SIGMOD |
| 7 | 12,606 | Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations | 2012 | SIGMOD |
| 8 | 4,390 | On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates | 1985 | VLDB |
| 9 | 4,653 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB |
| 10 | 1,898 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |