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: 5799
Venue: SIGMOD
Year: 2020
Pagerank: 4.9582125e-05
Overall Rank: 6,695 | 53.43%
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,944	DBSP: Automatic Incremental View Maintenance for Rich Query Languages	2023	VLDB	5.2628186e-05
5,967	Change Propagation Without Joins	2023	VLDB	5.250976e-05
7,701	Resource-efficient Shared Query Execution via Exploiting Time Slackness	2021	SIGMOD	4.6741329e-05
8,181	Foreign Keys Open the Door for Faster Incremental View Maintenance	2023	SIGMOD	4.5660166e-05
8,437	Insert-Only versus Insert-Delete in Dynamic Query Evaluation	2024	PODS	4.5138778e-05
8,611	Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI)	2022	SIGMOD	4.4852886e-05
8,959	Reservoir Sampling over Joins	2024	SIGMOD	4.4206222e-05
9,707	Towards Update-Dependent Analysis of Query Maintenance	2025	PODS	4.299267e-05
9,800	Cquirrel: Continuous Query Processing over Acyclic Relational Schemas	2021	VLDB	4.2818172e-05
10,049	Approximate Query Processing under Updates	2026	SIGMOD	4.1945683e-05
10,468	AJOSC: Adaptive Join Order Selection for Continuous Queries	2025	SIGMOD	4.1945683e-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
95	Maintaining Views Incrementally	1993	SIGMOD	0.00050896659
211	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00033981214
586	DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views	2012	VLDB	0.00019685374
772	Answering Conjunctive Queries under Updates	2017	PODS	0.00016876498
779	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00016786961
1,056	The Dynamic Yannakakis Algorithm: Compact and Efficient Query Processing Under Updates	2017	SIGMOD	0.0001441128
1,098	Trill: A High-Performance Incremental Query Processor for Diverse Analytics	2015	VLDB	0.00014114442
1,238	Incremental Query Evaluation in a Ring of Databases	2010	PODS	0.00013114581
1,411	Communication Steps for Parallel Query Processing	2013	PODS	0.0001212565
3,704	How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates	2016	SIGMOD	6.827494e-05
3,781	Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries	2020	PODS	6.7723513e-05
4,197	Incremental View Maintenance with Triple Lock Factorization Benefits	2018	SIGMOD	6.367895e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
8,159	Computing Complex Temporal Join Queries Efficiently	2022	SIGMOD	4.5729025e-05
2,275	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB	9.1262202e-05
4,708	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS	5.980172e-05
11,010	Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates	2024	VLDB	4.1945683e-05
211	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00033981214
10,049	Approximate Query Processing under Updates	2026	SIGMOD	4.1945683e-05
8,966	Output-sensitive Conjunctive Query Evaluation	2024	PODS	4.4193184e-05
4,432	Towards a Worst-Case I/O-Optimal Algorithm for Acyclic Joins	2016	PODS	6.1938383e-05
3,515	Scalable Computation of Acyclic Joins (Extended Abstract)	2006	PODS	7.0220813e-05
9,707	Towards Update-Dependent Analysis of Query Maintenance	2025	PODS	4.299267e-05