User-Defined Aggregate Functions: Bridging Theory and Practice

Summary: Bridges theory and practice for UDAs in relational DBs. Examines mismatch between UDA creation and the data required by optimization, rewriting, and view maintenance; proposes a coherent framework to treat UDAs as first-class citizens. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: ha630898f2b04e829
Venue: SIGMOD
Year: 2006
Pagerank: 6.311544e-05
Overall Rank: 5,016 | 66.29%
DOI: 10.1145/1142473.1142480

Incoming Non-self Citations Over Time

Authors

1. Sara Cohen (Technion)

BibTeX Citation

@inproceedings{cohen_sigmod06,
        title = {{User-Defined Aggregate Functions: Bridging Theory and Practice}},
        author = {Cohen, Sara},
        series = {{SIGMOD} '06},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1142473.1142480},
        url = {https://dl.acm.org/doi/10.1145/1142473.1142480},
        year = {2006}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,799	Moment-Based Quantile Sketches for Efficient High Cardinality Aggregation Queries	2018	VLDB	7.9895512e-05
4,062	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.8215782e-05
5,920	Time-Decaying Aggregates in Out-of-order Streams	2008	PODS	5.9454871e-05
9,793	ProvCite: Provenance-based Data Citation	2019	VLDB	5.1251743e-05
12,524	How Achaeans Would Construct Columns in Troy	2013	CIDR	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 16 of 16 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.00071056708
62	Maintaining Views Incrementally	1993	SIGMOD	0.00039040346
117	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00031616101
202	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.0002523837
213	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00024753576
388	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019342096
531	The Magic of Duplicates and Aggregates	1990	VLDB	0.00016845756
552	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00016530708
553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00016518678
567	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016264813
745	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.0001430357
875	Queries Independent of Updates	1993	VLDB	0.0001331025
880	Rewriting Aggregate Queries Using Views	1999	PODS	0.00013274554
936	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00012983552
1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012263425
1,119	Query Optimization by Predicate Move-Around	1994	VLDB	0.00011946162

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,516	Optimization of Queries with User-defined Predicates	1996	VLDB
2	13,575	Towards the Support of Integrated Views of Multiple Databases: An Aggregate Schema Facility	1978	SIGMOD
3	4,728	User-Defined Table Operators: Enhancing Extensibility for ORDBMS	1999	VLDB
4	1,899	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
5	3,645	User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases	2022	VLDB
6	2,083	Incremental Maintenance for Non-Distributive Aggregate Functions	2002	VLDB
7	9,700	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB
8	9,704	Using SQL to Build New Aggregates and Extenders for Object-Relational Systems	2000	VLDB
9	6,057	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB
10	7,988	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB