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,581 | Execution Strategies for SQL Subqueries | 2007 | SIGMOD | 0.00011262795 |
| 5,509 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.4706803e-05 |
| 10,423 | Query Decorrelation in the Fabric Data Warehouse | 2025 | SIGMOD | 4.1905499e-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.0012093675 |
| 462 | Access Paths in the "Abe" Statistical Query Facility | 1982 | SIGMOD | 0.00022568219 |
| 529 | Database Relations with Null Values (Extended Abstract) | 1982 | PODS | 0.00020825533 |
| 580 | Quel As A Data Type | 1984 | SIGMOD | 0.00019775101 |
| 1,455 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 0.00011912375 |
| 2,709 | Query Processing Strategies in the PASCAL/R Relational Database Management System | 1982 | SIGMOD | 8.2607995e-05 |
| 2,784 | Optimization of Nested Queries in a Distributed Relational Database | 1984 | VLDB | 8.1263312e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,675 | Adaptive Parallel Aggregation Algorithms | 1995 | SIGMOD | 0.00010937908 |
| 10,049 | Approximate Query Processing under Updates | 2026 | SIGMOD | 4.1905499e-05 |
| 6,094 | Towards an Efficient Evaluation of General Queries: Quantifier and Disjunction Processing Revisited | 1989 | SIGMOD | 5.2099705e-05 |
| 12,305 | Equivalence of SQL Queries In Presence of Embedded Dependencies | 2009 | PODS | 4.1905499e-05 |
| 2,105 | Deciding Equivalences among Aggregate Queries | 1998 | PODS | 9.5309231e-05 |
| 102 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049592627 |
| 4,349 | Processing Queries with Quantifiers: A Horticultural Approach | 1983 | PODS | 6.2577871e-05 |
| 3,581 | Translating Aggregate Queries into Iterative Programs | 1986 | VLDB | 6.9455822e-05 |
| 1,754 | Querying Multiple Features of Groups in Relational Databases | 1996 | VLDB | 0.00010663123 |
| 5,509 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.4706803e-05 |