Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations

Summary: Introduces horizontal aggregations, a minimal SQL extension for transposed aggregation output, blurring row–column semantics. Prototype optimizer handles nested queries with filtering, joins, and vertical/horizontal aggregations, revealing OLAP challenges. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4570
Venue: SIGMOD
Year: 2012
Pagerank: 4.1945683e-05
Overall Rank: 12,118 | 15.70%
DOI: -

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 1 of 1 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
1,203	PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS	2004	VLDB	0.00013320373

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
8,051	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD	4.5969549e-05
8,784	SQL Query Optimization: Reordering for a General Class of Queries	1996	SIGMOD	4.4527694e-05
218	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00033503922
639	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018791492
767	Explaining differences in multidimensional aggregates	1999	VLDB	0.00016981309
3,577	Translating Aggregate Queries into Iterative Programs	1986	VLDB	6.9504079e-05
1,674	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD	0.0001094787
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010670609
12,577	Vertical and Horizontal Percentage Aggregations	2004	SIGMOD	4.1945683e-05
5,498	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB	5.4750555e-05