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: 4571
Venue: SIGMOD
Year: 2012
Pagerank: 4.1905499e-05
Overall Rank: 12,126 | 15.73%
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,205	PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS	2004	VLDB	0.00013309393

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
8,053	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD	4.5925468e-05
8,778	SQL Query Optimization: Reordering for a General Class of Queries	1996	SIGMOD	4.4486677e-05
218	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00033489004
640	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018780632
762	Explaining differences in multidimensional aggregates	1999	VLDB	0.00016984985
3,581	Translating Aggregate Queries into Iterative Programs	1986	VLDB	6.9455822e-05
1,675	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD	0.00010937908
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010663123
12,586	Vertical and Horizontal Percentage Aggregations	2004	SIGMOD	4.1905499e-05
5,509	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB	5.4706803e-05