On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates
Summary: Survey of transformation techniques for nested SQL-like queries with aggregates, exposing correctness gaps on empty sets and the lack of a universal, efficient method. Reexamines QUEL semantics for a subset; Ingres benchmarks show gains with dynamic filters and argue for a unified operator-tree model to fuse correlation with aggregates. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,582 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00011265079 |
| 5,498 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.4750555e-05 |
| 10,412 | Query Decorrelation in the Fabric Data Warehouse | 2025 | SIGMOD | 4.1945683e-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 |
|---|---|---|---|---|
| 10 | Benchmarking Database Systems: A Systematic Approach | 1983 | VLDB | 0.0012103754 |
| 479 | Access Paths in the "Abe" Statistical Query Facility | 1982 | SIGMOD | 0.00022217448 |
| 528 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.0002084153 |
| 579 | Quel As A Data Type | 1984 | SIGMOD | 0.00019808249 |
| 1,451 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 0.00011922302 |
| 2,705 | Query Processing Strategies in the PASCAL/R Relational Database Management System | 1982 | SIGMOD | 8.2681571e-05 |
| 2,775 | Optimization of Nested Queries in a Distributed Relational Database | 1984 | VLDB | 8.1334572e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,674 | Adaptive Parallel Aggregation Algorithms | 1995 | SIGMOD | 0.0001094787 |
| 6,090 | Towards an Efficient Evaluation of General Queries: Quantifier and Disjunction Processing Revisited | 1989 | SIGMOD | 5.2148332e-05 |
| 10,049 | Approximate Query Processing under Updates | 2026 | SIGMOD | 4.1945683e-05 |
| 12,297 | Equivalence of SQL Queries In Presence of Embedded Dependencies | 2009 | PODS | 4.1945683e-05 |
| 2,103 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5385023e-05 |
| 100 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049624696 |
| 4,352 | Processing Queries with Quantifiers: A Horticultural Approach | 1983 | PODS | 6.2638329e-05 |
| 3,577 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB | 6.9504079e-05 |
| 1,754 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB | 0.00010670609 |
| 5,498 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.4750555e-05 |