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
5951
Venue
SIGMOD
Year
2020
Pagerank
6.0247446e-05
Overall Rank
4,648 | 67.67%
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,237 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.2212748e-05
3,648 One WITH RECURSIVE is Worth Many GOTOs 2021 SIGMOD 6.8831123e-05
5,731 Babelfish: Efficient Execution of Polyglot Queries 2022 VLDB 5.3502065e-05
6,375 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.0923872e-05
6,409 Fine-Grained Lineage for Safer Notebook Interactions 2021 VLDB 5.0756653e-05
6,692 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 4.9599916e-05
6,701 YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases 2022 VLDB 4.9561066e-05
8,583 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 4.4919445e-05
8,645 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 4.4772518e-05
9,343 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 4.3546206e-05
9,762 QURE: AI-Assisted and Automatically Verified UDF Inlining 2025 SIGMOD 4.2856106e-05
9,884 SQL Engines Excel at the Execution of Imperative Programs 2024 VLDB 4.2635782e-05
10,404 Dynamic Pruning for Recursive Joins 2025 SIGMOD 4.1945683e-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
248 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00030785339
639 Orthogonal Optimization of Subqueries and Aggregation 2001 SIGMOD 0.00018791492
1,108 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.00013984276
1,456 Rewriting Procedures for Batched Bindings 2008 VLDB 0.00011899772
2,632 A Transformation-Based Approach to Optimizing Loops in Database Programming Languages 1992 SIGMOD 8.4074026e-05
3,080 Compiling PL/SQL Away 2020 CIDR 7.603389e-05
3,296 Extracting Equivalent SQL from Imperative Code in Database Applications 2016 SIGMOD 7.2596583e-05
3,308 Automatic Partitioning of Database Applications 2012 VLDB 7.2422925e-05
4,677 Automatically Leveraging MapReduce Frameworks for Data-Intensive Applications 2018 SIGMOD 6.0047822e-05
5,176 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6439407e-05
6,245 Iterative Query Processing based on Unified Optimization Techniques 2019 SIGMOD 5.1391202e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
9,763 The UDFBench Benchmark for General-purpose UDF Queries 2025 VLDB 4.2856106e-05
4,006 On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates 1985 VLDB 6.5410994e-05
13,738 Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences 2003 VLDB -
10,551 Avoiding Materialisation for Guarded Aggregate Queries 2025 VLDB 4.1945683e-05
1,674 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.0001094787
5,498 Translating and Optimizing SQL Queries Having Aggregates 1987 VLDB 5.4750555e-05
6,245 Iterative Query Processing based on Unified Optimization Techniques 2019 SIGMOD 5.1391202e-05
8,583 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 4.4919445e-05
12,118 Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations 2012 SIGMOD 4.1945683e-05
3,577 Translating Aggregate Queries into Iterative Programs 1986 VLDB 6.9504079e-05