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: 3739
Venue: SIGMOD
Year: 2006
Pagerank: 5.6439407e-05
Overall Rank: 5,176 | 64.00%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Sara Cohen

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,953	Moment-Based Quantile Sketches for Efficient High Cardinality Aggregation Queries	2018	VLDB	7.8267643e-05
4,648	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.0247446e-05
5,594	Time-Decaying Aggregates in Out-of-order Streams	2008	PODS	5.4192122e-05
9,921	ProvCite: Provenance-based Data Citation	2019	VLDB	4.2549509e-05
12,030	How Achaeans Would Construct Columns in Troy	2013	CIDR	4.1945683e-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.0011708144
95	Maintaining Views Incrementally	1993	SIGMOD	0.00050896659
127	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00044642203
218	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00033503922
248	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00030785339
445	The Magic of Duplicates and Aggregates	1990	VLDB	0.0002294367
481	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00022167223
584	Answering Queries with Aggregation Using Views	1996	VLDB	0.0001971526
639	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018791492
731	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017468889
779	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00016786961
938	Queries Independent of Updates	1993	VLDB	0.00015197786
971	Rewriting Aggregate Queries Using Views	1999	PODS	0.00014925576
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014382575
1,155	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00013616518
1,302	Query Optimization by Predicate Move-Around	1994	VLDB	0.00012705525

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,860	Optimization of Queries with User-defined Predicates	1996	VLDB	7.9934503e-05
13,078	Towards the Support of Integrated Views of Multiple Databases: An Aggregate Schema Facility	1978	SIGMOD	4.1945683e-05
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010670609
4,569	User-Defined Table Operators: Enhancing Extensibility for ORDBMS	1999	VLDB	6.0782978e-05
4,924	User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases	2022	VLDB	5.822682e-05
2,361	Incremental Maintenance for Non-Distributive Aggregate Functions	2002	VLDB	8.9601322e-05
9,763	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	4.2856106e-05
9,288	Using SQL to Build New Aggregates and Extenders for Object-Relational Systems	2000	VLDB	4.3622826e-05
5,498	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB	5.4750555e-05
8,583	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB	4.4919445e-05