The Generalized Pre-Grouping Transformation: Aggregate-Query Optimization in the Presence of Dependencies
Summary: Generalized Pre-Grouping: algebraic framework and conditions for early-aggregation of facts under dependencies, without hierarchical surrogates. Surrogate-Join: novel transformation that alters join predicates via dependencies, extending clustering-based access beyond existing semantic transformations. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Aris Tsois
- 2. Timos Sellis
Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,809 | Supporting Ad-hoc Ranking Aggregates | 2006 | SIGMOD | 6.7413981e-05 |
| 5,087 | Accelerating Queries with Group-By and Join by Groupjoin | 2011 | VLDB | 5.7032118e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 11 of 11 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 51 | Including Group-By in Query Optimization | 1994 | VLDB | 0.00067060283 |
| 102 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049592627 |
| 218 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00033489004 |
| 249 | Eager Aggregation and Lazy Aggregation | 1995 | VLDB | 0.00030773137 |
| 335 | Optimization of Real Conjunctive Queries | 1993 | PODS | 0.00027012705 |
| 448 | The Magic of Duplicates and Aggregates | 1990 | VLDB | 0.00022922417 |
| 835 | An Extended Relational Algebra with Control Over Duplicate Elimination | 1982 | PODS | 0.00016081611 |
| 2,394 | Algebraic Properties of Bag Data Types | 1991 | VLDB | 8.8911581e-05 |
| 4,118 | A System for Semantic Query Optimization | 1987 | SIGMOD | 6.4313372e-05 |
| 4,403 | Implementation of Two Semantic Query Optimization Techniques in DB2 Universal Database | 1999 | VLDB | 6.2054188e-05 |
| 7,042 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 4.8483133e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 8,676 | A Practical Approach to Groupjoin and Nested Aggregates | 2021 | VLDB | 4.4652082e-05 |
| 5,509 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.4706803e-05 |
| 249 | Eager Aggregation and Lazy Aggregation | 1995 | VLDB | 0.00030773137 |
| 1,952 | Groupwise Processing of Relational Queries | 1997 | VLDB | 9.9806285e-05 |
| 12,126 | Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations | 2012 | SIGMOD | 4.1905499e-05 |
| 8,844 | Faster Plan Generation through Consideration of Functional Dependencies and Keys | 2016 | VLDB | 4.4334103e-05 |
| 51 | Including Group-By in Query Optimization | 1994 | VLDB | 0.00067060283 |
| 7,042 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 4.8483133e-05 |
| 4,796 | Extending Practical Pre-Aggregation in On-Line Analytical Processing | 1999 | VLDB | 5.9104535e-05 |
| 11,094 | Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle | 2024 | VLDB | 4.1905499e-05 |