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,807 | Supporting Ad-hoc Ranking Aggregates | 2006 | SIGMOD | 6.747576e-05 |
| 5,087 | Accelerating Queries with Group-By and Join by Groupjoin | 2011 | VLDB | 5.7075009e-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.00067123727 |
| 100 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049624696 |
| 218 | Aggregate-Query Processing in Data Warehousing Environments | 1995 | VLDB | 0.00033503922 |
| 248 | Eager Aggregation and Lazy Aggregation | 1995 | VLDB | 0.00030785339 |
| 335 | Optimization of Real Conjunctive Queries | 1993 | PODS | 0.00027036073 |
| 445 | The Magic of Duplicates and Aggregates | 1990 | VLDB | 0.0002294367 |
| 837 | An Extended Relational Algebra with Control Over Duplicate Elimination | 1982 | PODS | 0.00016097758 |
| 2,395 | Algebraic Properties of Bag Data Types | 1991 | VLDB | 8.8998019e-05 |
| 4,119 | A System for Semantic Query Optimization | 1987 | SIGMOD | 6.4365852e-05 |
| 4,408 | Implementation of Two Semantic Query Optimization Techniques in DB2 Universal Database | 1999 | VLDB | 6.2109612e-05 |
| 7,045 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 4.8528709e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 8,680 | A Practical Approach to Groupjoin and Nested Aggregates | 2021 | VLDB | 4.4694927e-05 |
| 5,498 | Translating and Optimizing SQL Queries Having Aggregates | 1987 | VLDB | 5.4750555e-05 |
| 248 | Eager Aggregation and Lazy Aggregation | 1995 | VLDB | 0.00030785339 |
| 1,948 | Groupwise Processing of Relational Queries | 1997 | VLDB | 9.989482e-05 |
| 12,118 | Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations | 2012 | SIGMOD | 4.1945683e-05 |
| 8,844 | Faster Plan Generation through Consideration of Functional Dependencies and Keys | 2016 | VLDB | 4.437664e-05 |
| 51 | Including Group-By in Query Optimization | 1994 | VLDB | 0.00067123727 |
| 7,045 | Processing Star Queries on Hierarchically-Clustered Fact Tables | 2002 | VLDB | 4.8528709e-05 |
| 4,796 | Extending Practical Pre-Aggregation in On-Line Analytical Processing | 1999 | VLDB | 5.9152598e-05 |
| 11,091 | Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle | 2024 | VLDB | 4.1945683e-05 |