DBScholar

Back to papers

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
3801
Venue
SIGMOD
Year
2006
Pagerank
6.4548696e-05
Overall Rank
4,896 | 66.42%
DOI
10.1145/1142473.1142480

Incoming Non-self Citations Over Time

Authors

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,747 Moment-Based Quantile Sketches for Efficient High Cardinality Aggregation Queries 2018 VLDB 8.1711208e-05
3,992 Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates 2020 SIGMOD 6.9695338e-05
5,802 Time-Decaying Aggregates in Out-of-order Streams 2008 PODS 6.0843083e-05
10,077 ProvCite: Provenance-based Data Citation 2019 VLDB 5.1603976e-05
12,227 How Achaeans Would Construct Columns in Troy 2013 CIDR 5.093636e-05
Previous Page 1 / 1 Next

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.00071822821
61 Maintaining Views Incrementally 1993 SIGMOD 0.00039026867
117 Querying Heterogeneous Information Sources Using Source Descriptions 1996 VLDB 0.00032192665
198 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00025618616
206 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00025092273
375 Incremental Maintenance of Views with Duplicates 1995 SIGMOD 0.00019681204
527 The Magic of Duplicates and Aggregates 1990 VLDB 0.00017108864
543 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.0001682612
554 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016580778
559 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016528822
736 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00014508563
853 Queries Independent of Updates 1993 VLDB 0.00013587101
869 Rewriting Aggregate Queries Using Views 1999 PODS 0.00013503594
913 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00013253821
1,034 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012516197
1,124 Query Optimization by Predicate Move-Around 1994 VLDB 0.00012087356
Previous Page 1 / 1 Next

Semantically Similar Papers

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