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,362 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00011032204 |
| 5,950 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 6.0314633e-05 |
| 10,697 | Query Decorrelation in the Fabric Data Warehouse | 2025 | SIGMOD | 5.093636e-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 |
|---|---|---|---|---|
| 45 | Benchmarking Database Systems: A Systematic Approach | 1983 | VLDB | 0.00045531113 |
| 613 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.00015723523 |
| 745 | Access Paths in the "Abe" Statistical Query Facility | 1982 | SIGMOD | 0.00014403889 |
| 1,099 | Quel As A Data Type | 1984 | SIGMOD | 0.0001217465 |
| 1,887 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 9.5347906e-05 |
| 2,263 | Optimization of Nested Queries in a Distributed Relational Database | 1984 | VLDB | 8.8440084e-05 |
| 2,955 | Query Processing Strategies in the PASCAL/R Relational Database Management System | 1982 | SIGMOD | 7.9213835e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,596 | Adaptive Parallel Aggregation Algorithms | 1995 | SIGMOD |
| 2 | 10,342 | Approximate Query Processing under Updates | 2026 | SIGMOD |
| 3 | 6,072 | Towards an Efficient Evaluation of General Queries: Quantifier and Disjunction Processing Revisited | 1989 | SIGMOD |
| 4 | 12,492 | Equivalence of SQL Queries In Presence of Embedded Dependencies | 2009 | PODS |
| 5 | 2,238 | Deciding Equivalences among Aggregate Queries | 1998 | PODS |
| 6 | 95 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB |
| 7 | 4,530 | Processing Queries with Quantifiers: A Horticultural Approach | 1983 | PODS |
| 8 | 4,574 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB |
| 9 | 1,860 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB |
| 10 | 5,950 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB |