Thrifty Query Execution via Incrementability

Summary: Proposes incrementability, a metric to gauge cost-effective incremental view maintenance for queries amid streaming data. Introduces InQP with decomposed control and a cost-model; Spark prototype shows reduced resource use with latency comparable to IVM. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 6033
Venue: SIGMOD
Year: 2020
Pagerank: 5.5169373e-05
Overall Rank: 7,967 | 45.34%
DOI: 10.1145/3318464.3389756

Incoming Non-self Citations Over Time

Authors

1. Dixin Tang (University of Chicago)
2. Zechao Shang (University of Chicago)
3. Aaron J. Elmore (University of Chicago)
4. Sanjay Krishnan (University of Chicago)
5. Michael J. Franklin (University of Chicago)

BibTeX Citation

@inproceedings{tang_sigmod20,
        title = {{Thrifty Query Execution via Incrementability}},
        author = {Tang, Dixin and Shang, Zechao and Elmore, Aaron J. and Krishnan, Sanjay and Franklin, Michael J.},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3389756},
        url = {https://dl.acm.org/doi/10.1145/3318464.3389756},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,579	Resource-efficient Shared Query Execution via Exploiting Time Slackness	2021	SIGMOD	5.592546e-05
8,571	Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI)	2022	SIGMOD	5.4102496e-05
8,904	A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory	2023	VLDB	5.3483178e-05
9,175	CrocodileDB in Action: Resource-Efficient Query Execution by Exploiting Time Slackness	2020	VLDB	5.3087332e-05
9,975	Transactional Panorama: A Conceptual Framework for User Perception in Analytical Visual Interfaces	2023	VLDB	5.1845938e-05
10,842	Agamotto: Scheduling of Deadline-Oriented Incremental Query Execution under Uncertain Resource Price	2025	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 32 of 32 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0024089429
9	Online Aggregation	1997	SIGMOD	0.00077458002
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
25	NiagaraCQ: A Scalable Continuous Query System for Internet Databases	2000	SIGMOD	0.00054667018
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00047309646
61	Maintaining Views Incrementally	1993	SIGMOD	0.00039026867
100	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034385207
111	TelegraphCQ: Continuous Dataflow Processing for an Uncertain World	2003	CIDR	0.00032990214
154	Neo: A Learned Query Optimizer	2019	VLDB	0.00028726181
375	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019681204
396	R* Optimizer Validation and Performance Evaluation for Local Queries	1986	SIGMOD	0.00019287574
438	DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views	2012	VLDB	0.00018471721
694	Cardinality Estimation Done Right: Index-Based Join Sampling	2017	CIDR	0.00014911698
710	Trill: A High-Performance Incremental Query Processor for Diverse Analytics	2015	VLDB	0.00014715033
816	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD	0.00013827772
1,016	Rate-Based Query Optimization for Streaming Information Sources	2002	SIGMOD	0.00012645699
1,027	Chain: Operator Scheduling for Memory Minimization in Data Stream Systems	2003	SIGMOD	0.00012563656
1,093	Maximizing the Output Rate of Multi-Way Join Queries over Streaming Information Sources	2003	VLDB	0.00012218435
1,133	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00012039326
1,218	P-Store: An Elastic Database System with Predictive Provisioning	2018	SIGMOD	0.00011621066
1,499	Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities	2019	SIGMOD	0.00010564536
1,750	Lazy Maintenance of Materialized Views	2007	VLDB	9.8392477e-05
2,157	A Black-Box Approach to Query Cardinality Estimation	2007	CIDR	9.0625592e-05
2,447	Operator Scheduling in a Data Stream Manager	2003	VLDB	8.5728111e-05
2,771	Supporting Multiple View Maintenance Policies	1997	SIGMOD	8.1455861e-05
3,087	How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates	2016	SIGMOD	7.7702906e-05
4,596	Static Optimization of Conjunctive Queries with Sliding Windows Over Infinite Streams	2004	SIGMOD	6.6133976e-05
5,137	Exact Cardinality Query Optimization with Bounded Execution Cost	2019	SIGMOD	6.3507372e-05
5,911	RPJ: Producing Fast Join Results on Streams through Rate-based Optimization	2005	SIGMOD	6.0443263e-05
6,122	iOLAP: Managing Uncertainty for Efficient Incremental OLAP	2016	SIGMOD	5.9687498e-05
6,819	Estimating the Impact of Unknown Unknowns on Aggregate Query Results	2016	SIGMOD	5.7635226e-05
7,200	Intermittent Query Processing	2019	VLDB	5.6756294e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	11,200	High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance	2024	SIGMOD
2	7,579	Resource-efficient Shared Query Execution via Exploiting Time Slackness	2021	SIGMOD
3	7,366	Non-Invasive Progressive Optimization for In-Memory Databases	2016	VLDB
4	6,193	Incremental View Maintenance For Collection Programming	2016	PODS
5	10,342	Approximate Query Processing under Updates	2026	SIGMOD
6	4,250	Generalized Scale Independence Through Incremental Precomputation	2013	SIGMOD
7	9,175	CrocodileDB in Action: Resource-Efficient Query Execution by Exploiting Time Slackness	2020	VLDB
8	4,880	An Incremental Anytime Algorithm for Multi-Objective Query Optimization	2015	SIGMOD
9	5,552	Enabling Incremental Query Re-Optimization	2016	SIGMOD
10	7,200	Intermittent Query Processing	2019	VLDB