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: h56877f01372e3eda
Venue: SIGMOD
Year: 2004
Pagerank: 4.9793485e-05
Overall Rank: 13,060 | 12.20%
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
398	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019152162
1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012269068
1,714	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	9.80996e-05
1,874	Efficient Computation of Iceberg Cubes with Complex Measures	2001	SIGMOD	9.4579757e-05

Semantically Similar Papers

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