Vertical and Horizontal Percentage Aggregations

Summary: Introduces vertical and horizontal percentage aggregations to fix SQL percentage limitations. Vertical outputs one row per percentage; horizontal packs 100% per row; framework enables efficient percentage queries and OLAP-like performance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3639
Venue: SIGMOD
Year: 2004
Pagerank: 5.093636e-05
Overall Rank: 12,770 | 12.39%
DOI: 10.1145/1007568.1007670

Incoming Non-self Citations Over Time

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

Authors

1. Carlos Ordonez (NCR Corporation; Teradata)

BibTeX Citation

@inproceedings{ordonez_sigmod04,
        title = {{Vertical and Horizontal Percentage Aggregations}},
        author = {Ordonez, Carlos},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007670},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007670},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
391	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019370653
1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012516197
1,687	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00010005718
1,825	Efficient Computation of Iceberg Cubes with Complex Measures	2001	SIGMOD	9.6726613e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	207	On the Computation of Multidimensional Aggregates	1996	VLDB
2	4,723	Aggregation Algorithms for Very Large Compressed Data Warehouses	1999	VLDB
3	5,136	Extending Practical Pre-Aggregation in On-Line Analytical Processing	1999	VLDB
4	1,860	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
5	7,774	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD
6	3,673	Efficient Processing of Window Functions in Analytical SQL Queries	2015	VLDB
7	8,685	Efficient Evaluation of Arbitrarily-Framed Holistic SQL Aggregates and Window Functions	2022	SIGMOD
8	5,950	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB
9	1,596	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD
10	12,315	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD