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: 3740
Venue: SIGMOD
Year: 2006
Pagerank: 5.6386942e-05
Overall Rank: 5,177 | 64.03%
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,954	Moment-Based Quantile Sketches for Efficient High Cardinality Aggregation Queries	2018	VLDB	7.8218804e-05
4,645	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.0190618e-05
5,602	Time-Decaying Aggregates in Out-of-order Streams	2008	PODS	5.4153555e-05
9,920	ProvCite: Provenance-based Data Citation	2019	VLDB	4.250874e-05
12,038	How Achaeans Would Construct Columns in Troy	2013	CIDR	4.1905499e-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.0011695087
97	Maintaining Views Incrementally	1993	SIGMOD	0.00050863077
127	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00044607231
218	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00033489004
249	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00030773137
448	The Magic of Duplicates and Aggregates	1990	VLDB	0.00022922417
482	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00022145976
583	Answering Queries with Aggregation Using Views	1996	VLDB	0.00019705383
640	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018780632
728	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017459654
775	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00016775051
937	Queries Independent of Updates	1993	VLDB	0.00015194231
971	Rewriting Aggregate Queries Using Views	1999	PODS	0.00014915911
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014370009
1,155	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00013606507
1,303	Query Optimization by Predicate Move-Around	1994	VLDB	0.00012692678

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,867	Optimization of Queries with User-defined Predicates	1996	VLDB	7.9931252e-05
13,091	Towards the Support of Integrated Views of Multiple Databases: An Aggregate Schema Facility	1978	SIGMOD	4.1905499e-05
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010663123
4,567	User-Defined Table Operators: Enhancing Extensibility for ORDBMS	1999	VLDB	6.0728188e-05
4,930	User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases	2022	VLDB	5.8171482e-05
2,362	Incremental Maintenance for Non-Distributive Aggregate Functions	2002	VLDB	8.9627806e-05
9,765	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	4.2815042e-05
9,293	Using SQL to Build New Aggregates and Extenders for Object-Relational Systems	2000	VLDB	4.3581013e-05
5,509	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB	5.4706803e-05
8,580	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB	4.4876382e-05