On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates
Summary: Exposes correctness failures in decorrelation/transformation algorithms for nested correlation queries with aggregates, especially over empty sets, and clarifies semantics for a QUEL subset. Shows INGRES dynamic filters can substantially accelerate such queries, while motivating unified operator-tree models. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Werner Kiessling (Technical University of Munich)
BibTeX Citation
@article{kiessling_vldb85,
title = {{On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates}},
author = {Kiessling, Werner},
journal = {PVLDB},
series = {{VLDB} '85},
pages = {241},
year = {1985}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,378 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00010864448 |
| 6,055 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.9018319e-05 |
| 11,131 | Query Decorrelation in the Fabric Data Warehouse | 2025 | SIGMOD | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 7 of 7 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 46 | Benchmarking Database Systems: A Systematic Approach | 1983 | VLDB | 0.00044784799 |
| 628 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.0001544126 |
| 764 | Access Paths in the "Abe" Statistical Query Facility | 1982 | SIGMOD | 0.00014127114 |
| 1,126 | Quel As A Data Type | 1984 | SIGMOD | 0.00011920289 |
| 1,935 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 9.3389342e-05 |
| 2,308 | Optimization of Nested Queries in a Distributed Relational Database | 1984 | VLDB | 8.666147e-05 |
| 3,012 | Query Processing Strategies in the PASCAL/R Relational Database Management System | 1982 | SIGMOD | 7.7547306e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,628 | Adaptive Parallel Aggregation Algorithms | 1995 | SIGMOD |
| 2 | 6,195 | Towards an Efficient Evaluation of General Queries: Quantifier and Disjunction Processing Revisited | 1989 | SIGMOD |
| 3 | 10,544 | Approximate Query Processing under Updates | 2026 | SIGMOD |
| 4 | 12,782 | Equivalence of SQL Queries In Presence of Embedded Dependencies | 2009 | PODS |
| 5 | 2,269 | Deciding Equivalences among Aggregate Queries | 1998 | PODS |
| 6 | 97 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB |
| 7 | 4,627 | Processing Queries with Quantifiers: A Horticultural Approach | 1983 | PODS |
| 8 | 4,653 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB |
| 9 | 1,898 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |
| 10 | 6,055 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB |