Maintaining Acyclic Foreign-Key Joins under Updates

Summary: Introduces enclosureness λ to quantify update difficulty for acyclic foreign-key joins; amortized O(λ) maintenance for updates. Lower bound Ω(λ^{1-ε}) shows near-optimal; supports all 22 TPC-H queries in ~O(λ); Flink system with gains. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5800
Venue: SIGMOD
Year: 2020
Pagerank: 4.9534535e-05
Overall Rank: 6,699 | 53.45%
DOI: 10.1145/3318464.3380586

Incoming Non-self Citations Over Time

Authors

1. Qichen Wang
2. Ke Yi

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,947	DBSP: Automatic Incremental View Maintenance for Rich Query Languages	2023	VLDB	5.2577662e-05
5,973	Change Propagation Without Joins	2023	VLDB	5.2459364e-05
7,699	Resource-efficient Shared Query Execution via Exploiting Time Slackness	2021	SIGMOD	4.6696504e-05
8,182	Foreign Keys Open the Door for Faster Incremental View Maintenance	2023	SIGMOD	4.5616384e-05
8,428	Insert-Only versus Insert-Delete in Dynamic Query Evaluation	2024	PODS	4.5095504e-05
8,610	Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI)	2022	SIGMOD	4.480988e-05
8,964	Reservoir Sampling over Joins	2024	SIGMOD	4.4163852e-05
9,706	Towards Update-Dependent Analysis of Query Maintenance	2025	PODS	4.2951473e-05
9,803	Cquirrel: Continuous Query Processing over Acyclic Relational Schemas	2021	VLDB	4.2777144e-05
10,049	Approximate Query Processing under Updates	2026	SIGMOD	4.1905499e-05
10,478	AJOSC: Adaptive Join Order Selection for Continuous Queries	2025	SIGMOD	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
97	Maintaining Views Incrementally	1993	SIGMOD	0.00050863077
212	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00033997204
585	DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views	2012	VLDB	0.00019682634
770	Answering Conjunctive Queries under Updates	2017	PODS	0.0001686092
775	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00016775051
1,054	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD	0.00014397587
1,097	Trill: A High-Performance Incremental Query Processor for Diverse Analytics	2015	VLDB	0.00014083973
1,231	Incremental Query Evaluation in a Ring of Databases	2010	PODS	0.00013141213
1,411	Communication Steps for Parallel Query Processing	2013	PODS	0.00012118832
3,703	How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates	2016	SIGMOD	6.8249334e-05
3,785	Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries	2020	PODS	6.7658346e-05
4,200	Incremental View Maintenance with Triple Lock Factorization Benefits	2018	SIGMOD	6.3618329e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
8,163	Computing Complex Temporal Join Queries Efficiently	2022	SIGMOD	4.5685178e-05
2,281	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB	9.122455e-05
11,013	Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates	2024	VLDB	4.1905499e-05
4,709	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS	5.9744219e-05
212	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00033997204
10,049	Approximate Query Processing under Updates	2026	SIGMOD	4.1905499e-05
8,972	Output-sensitive Conjunctive Query Evaluation	2024	PODS	4.4150824e-05
4,430	Towards a Worst-Case I/O-Optimal Algorithm for Acyclic Joins	2016	PODS	6.1879319e-05
3,519	Scalable Computation of Acyclic Joins (Extended Abstract)	2006	PODS	7.0181381e-05
9,706	Towards Update-Dependent Analysis of Query Maintenance	2025	PODS	4.2951473e-05