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: 6013
Venue: SIGMOD
Year: 2020
Pagerank: 6.9695338e-05
Overall Rank: 3,992 | 72.62%
DOI: 10.1145/3318464.3389736

Incoming Non-self Citations Over Time

Authors

1. Surabhi Gupta (Microsoft)
2. Sanket Purandare (Harvard University)
3. Karthik Ramachandra (Microsoft)

BibTeX Citation

@inproceedings{gupta_sigmod20,
        title = {{Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates}},
        author = {Gupta, Surabhi and Purandare, Sanket and Ramachandra, Karthik},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3389736},
        url = {https://dl.acm.org/doi/10.1145/3318464.3389736},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,892	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.5277793e-05
3,257	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD	7.590651e-05
5,301	Babelfish: Efficient Execution of Polyglot Queries	2022	VLDB	6.2750553e-05
6,015	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	6.008272e-05
6,071	Fine-Grained Lineage for Safer Notebook Interactions	2021	VLDB	5.9873765e-05
6,314	YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases	2022	VLDB	5.9157364e-05
6,475	WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications	2024	SIGMOD	5.8687157e-05
8,096	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB	5.4875738e-05
8,465	Predicate Pushdown for Data Science Pipelines	2023	SIGMOD	5.4194578e-05
9,415	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.2742285e-05
9,456	QURE: AI-Assisted and Automatically Verified UDF Inlining	2025	SIGMOD	5.2643416e-05
10,040	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	5.1723558e-05
10,690	Dynamic Pruning for Recursive Joins	2025	SIGMOD	5.093636e-05

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
206	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00025092273
543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001682612
894	Froid: Optimization of Imperative Programs in a Relational Database	2018	VLDB	0.00013367658
1,261	Rewriting Procedures for Batched Bindings	2008	VLDB	0.0001143305
2,505	A Transformation-Based Approach to Optimizing Loops in Database Programming Languages	1992	SIGMOD	8.4960641e-05
2,684	Compiling PL/SQL Away	2020	CIDR	8.25952e-05
2,939	Extracting Equivalent SQL from Imperative Code in Database Applications	2016	SIGMOD	7.9395908e-05
2,941	Automatic Partitioning of Database Applications	2012	VLDB	7.937125e-05
4,599	Automatically Leveraging MapReduce Frameworks for Data-Intensive Applications	2018	SIGMOD	6.6122875e-05
4,896	User-Defined Aggregate Functions: Bridging Theory and Practice	2006	SIGMOD	6.4548696e-05
5,991	Iterative Query Processing based on Unified Optimization Techniques	2019	SIGMOD	6.0171458e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,917	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB
2	4,310	On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates	1985	VLDB
3	13,939	Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences	2003	VLDB
4	9,720	Avoiding Materialisation for Guarded Aggregate Queries	2025	VLDB
5	1,596	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD
6	5,950	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB
7	5,991	Iterative Query Processing based on Unified Optimization Techniques	2019	SIGMOD
8	8,096	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB
9	12,315	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD
10	4,574	Translating Aggregate Queries into Iterative Programs	1986	VLDB