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: 4632
Venue: SIGMOD
Year: 2012
Pagerank: 5.093636e-05
Overall Rank: 12,315 | 15.51%
DOI: 10.1145/2213836.2213919

Incoming Non-self Citations Over Time

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

Authors

1. Carlos Ordonez (University of Houston)
2. Javier García-García (National Autonomous University of Mexico; National Polytechnic Institute)
3. Zhibo Chen (University of Houston)

BibTeX Citation

@inproceedings{ordonez_sigmod12,
        title = {{Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations}},
        author = {Ordonez, Carlos and García-García, Javier and Chen, Zhibo},
        series = {{SIGMOD} '12},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2213836.2213919},
        url = {https://dl.acm.org/doi/10.1145/2213836.2213919},
        year = {2012}
}

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,691	PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS	2004	VLDB	9.9999141e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,774	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD
2	7,272	SQL Query Optimization: Reordering for a General Class of Queries	1996	SIGMOD
3	198	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB
4	543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD
5	700	Explaining differences in multidimensional aggregates	1999	VLDB
6	4,574	Translating Aggregate Queries into Iterative Programs	1986	VLDB
7	1,596	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD
8	1,860	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
9	12,770	Vertical and Horizontal Percentage Aggregations	2004	SIGMOD
10	5,950	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB