Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI)

Summary: Introduces Relative Partial Aggregate Indexes (RPAI) for incrementalizing correlated nested-aggregate queries in streaming, latency-critical settings. Shows asymptotic improvement with up to 1100x speedups vs. prior IVM approaches (e.g., DBToaster). (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h75cb351d3d3d9f81
Venue: SIGMOD
Year: 2022
Pagerank: 5.3142933e-05
Overall Rank: 8,560 | 42.45%
DOI: 10.1145/3514221.3517889

Incoming Non-self Citations Over Time

Authors

1. Supun Abeysinghe (Purdue University)
2. Qiyang He (Purdue University)
3. Tiark Rompf (Purdue University)

BibTeX Citation

@inproceedings{abeysinghe_sigmod22,
        title = {{Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI)}},
        author = {Abeysinghe, Supun and He, Qiyang and Rompf, Tiark},
        series = {{SIGMOD} '22},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3514221.3517889},
        url = {https://dl.acm.org/doi/10.1145/3514221.3517889},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,673	DBSP: Automatic Incremental View Maintenance for Rich Query Languages	2023	VLDB	7.1092596e-05
7,542	Foreign Keys Open the Door for Faster Incremental View Maintenance	2023	SIGMOD	5.4986181e-05

Outgoing Citations (Sorted by Pagerank)

Showing 24 of 24 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
62	Maintaining Views Incrementally	1993	SIGMOD	0.00039045511
218	MillWheel: Fault-Tolerant Stream Processing at Internet Scale	2013	VLDB	0.00024390324
388	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019350381
408	DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views	2012	VLDB	0.00018900199
442	Differential dataflow	2013	CIDR	0.00018210463
552	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001653835
812	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD	0.00013729015
978	Incremental Query Evaluation in a Ring of Databases	2010	PODS	0.00012731074
1,150	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00011809311
1,779	Lazy Maintenance of Materialized Views	2007	VLDB	9.6583009e-05
2,419	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.4923505e-05
3,128	How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates	2016	SIGMOD	7.6151967e-05
4,400	Shared Arrangements: practical inter-query sharing for streaming dataflows	2020	VLDB	6.6151947e-05
5,145	Conjunctive Queries with Inequalities Under Updates	2018	VLDB	6.2566119e-05
6,227	iOLAP: Managing Uncertainty for Efficient Incremental OLAP	2016	SIGMOD	5.8452386e-05
6,386	Maintaining Acyclic Foreign-Key Joins under Updates	2020	SIGMOD	5.8040725e-05
6,599	AStream: Ad-hoc Shared Stream Processing	2019	SIGMOD	5.7404438e-05
6,706	Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing	2021	VLDB	5.7049776e-05
6,796	Intermittent Query Processing	2019	VLDB	5.6803529e-05
7,722	Resource-efficient Shared Query Execution via Exploiting Time Slackness	2021	SIGMOD	5.467573e-05
7,771	DBToaster: Agile Views in a Dynamic Data Management System	2011	CIDR	5.4553987e-05
8,014	AJoin: Ad-hoc Stream Joins at Scale	2020	VLDB	5.4070928e-05
8,131	Thrifty Query Execution via Incrementability	2020	SIGMOD	5.3936608e-05
9,695	Grosbeak: A Data Warehouse Supporting Resource-Aware Incremental Computing	2020	SIGMOD	5.1396321e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	13,017	A Nested Relational Approach to Processing SQL Subqueries	2005	SIGMOD
2	6,219	Incremental View Maintenance For Collection Programming	2016	PODS
3	8,131	Thrifty Query Execution via Incrementability	2020	SIGMOD
4	978	Incremental Query Evaluation in a Ring of Databases	2010	PODS
5	10,544	Approximate Query Processing under Updates	2026	SIGMOD
6	10,885	Storing and Indexing Multiple Tables by Interesting Orderings: For Efficient Joins, Groupings, and Updates in Relational Databases	2026	VLDB
7	5,667	Enabling Incremental Query Re-Optimization	2016	SIGMOD
8	11,765	Asymptotically Better Query Optimization Using Indexed Algebra	2023	VLDB
9	3,873	DBToaster: A SQL Compiler for High-Performance Delta Processing in Main-Memory Databases	2009	VLDB
10	5,269	Efficient Approximation of Optimization Queries Under Parametric Aggregation Constraints	2003	VLDB