Database Paper Browser

Back to papers

Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates

Summary: Aggify automatically generates custom aggregates that semantically match cursor loops and rewrites queries to use them. This enables pipelined in-DBMS computation and leverages aggregates to reduce materialization and improve plans, with empirical gains. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
5952
Venue
SIGMOD
Year
2020
Pagerank
6.0190618e-05
Overall Rank
4,645 | 67.72%
DOI
10.1145/3318464.3389736

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank Citing Paper Year Venue Pagerank
2,242 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.2124242e-05
3,649 One WITH RECURSIVE is Worth Many GOTOs 2021 SIGMOD 6.8764882e-05
5,741 Babelfish: Efficient Execution of Polyglot Queries 2022 VLDB 5.3450701e-05
6,374 Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL 2024 CIDR 5.0874998e-05
6,405 Fine-Grained Lineage for Safer Notebook Interactions 2021 VLDB 5.0707934e-05
6,694 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 4.9552327e-05
6,703 YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases 2022 VLDB 4.9514593e-05
8,580 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 4.4876382e-05
8,625 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 4.4784651e-05
9,348 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 4.3504473e-05
9,764 QURE: AI-Assisted and Automatically Verified UDF Inlining 2025 SIGMOD 4.2815042e-05
9,883 SQL Engines Excel at the Execution of Imperative Programs 2024 VLDB 4.2594931e-05
10,415 Dynamic Pruning for Recursive Joins 2025 SIGMOD 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

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

Rank Cited Paper Year Venue Pagerank
249 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00030773137
640 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.00018780632
1,107 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.0001397627
1,457 Rewriting Procedures for Batched Bindings 2008 VLDB 0.00011891025
2,637 A Transformation-Based Approach to Optimizing Loops in Database Programming Languages 1992 SIGMOD 8.399844e-05
3,085 Compiling PL/SQL Away 2020 CIDR 7.5960713e-05
3,298 Extracting Equivalent SQL from Imperative Code in Database Applications 2016 SIGMOD 7.2527707e-05
3,312 Automatic Partitioning of Database Applications 2012 VLDB 7.2356116e-05
4,676 Automatically Leveraging MapReduce Frameworks for Data-Intensive Applications 2018 SIGMOD 5.9992323e-05
5,177 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6386942e-05
6,245 Iterative Query Processing based on Unified Optimization Techniques 2019 SIGMOD 5.1341887e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
9,765 The UDFBench Benchmark for General-purpose UDF Queries 2025 VLDB 4.2815042e-05
4,008 On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates 1985 VLDB 6.5357979e-05
13,752 Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences 2003 VLDB -
10,560 Avoiding Materialisation for Guarded Aggregate Queries 2025 VLDB 4.1905499e-05
1,675 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.00010937908
5,509 Translating and Optimizing SQL Queries Having Aggregates 1987 VLDB 5.4706803e-05
6,245 Iterative Query Processing based on Unified Optimization Techniques 2019 SIGMOD 5.1341887e-05
8,580 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 4.4876382e-05
12,126 Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations 2012 SIGMOD 4.1905499e-05
3,581 Translating Aggregate Queries into Iterative Programs 1986 VLDB 6.9455822e-05