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.00010859556 |
| 6,057 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.8990559e-05 |
| 11,140 | Query Decorrelation in the Fabric Data Warehouse | 2025 | SIGMOD | 4.9769913e-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.00044767144 |
| 628 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.00015434033 |
| 764 | Access Paths in the "Abe" Statistical Query Facility | 1982 | SIGMOD | 0.00014120837 |
| 1,126 | Quel As A Data Type | 1984 | SIGMOD | 0.00011914952 |
| 1,936 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 9.334734e-05 |
| 2,311 | Optimization of Nested Queries in a Distributed Relational Database | 1984 | VLDB | 8.6623569e-05 |
| 3,013 | Query Processing Strategies in the PASCAL/R Relational Database Management System | 1982 | SIGMOD | 7.7511669e-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,198 | Towards an Efficient Evaluation of General Queries: Quantifier and Disjunction Processing Revisited | 1989 | SIGMOD |
| 3 | 10,555 | Approximate Query Processing under Updates | 2026 | SIGMOD |
| 4 | 12,788 | Equivalence of SQL Queries In Presence of Embedded Dependencies | 2009 | PODS |
| 5 | 2,271 | 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,628 | Processing Queries with Quantifiers: A Horticultural Approach | 1983 | PODS |
| 8 | 4,654 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB |
| 9 | 1,899 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |
| 10 | 6,057 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB |