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.2956973e-05
Overall Rank: 5,028 | 66.30%
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,675	Moment-Based Quantile Sketches for Efficient High Cardinality Aggregation Queries	2018	VLDB	8.1273838e-05
4,078	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.8028789e-05
5,932	Time-Decaying Aggregates in Out-of-order Streams	2008	PODS	5.9261324e-05
9,827	ProvCite: Provenance-based Data Citation	2019	VLDB	5.108228e-05
12,567	How Achaeans Would Construct Columns in Troy	2013	CIDR	4.9605343e-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.00070860346
62	Maintaining Views Incrementally	1993	SIGMOD	0.00038944207
117	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00031526277
204	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.0002516936
213	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00024695393
388	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.0001928135
533	The Magic of Duplicates and Aggregates	1990	VLDB	0.00016794756
554	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00016487919
556	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00016470022
567	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016228477
746	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.0001426147
878	Queries Independent of Updates	1993	VLDB	0.0001326705
882	Rewriting Aggregate Queries Using Views	1999	PODS	0.00013239752
940	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00012941424
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012224962
1,122	Query Optimization by Predicate Move-Around	1994	VLDB	0.00011915958

Semantically Similar Papers

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