Efficient Join Synopsis Maintenance for Data Warehouse

Summary: Efficiently maintain a uniform random join synopsis for dynamic data warehouses with SJoin. A weighted join graph index enables fast synopsis updates under continuous inflows; experiments on TPC-DS and simulated road-sensor data show gains vs baselines. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: he6e875b3557a452b
Venue: SIGMOD
Year: 2020
Pagerank: 6.4898745e-05
Overall Rank: 4,642 | 68.80%
DOI: 10.1145/3318464.3389717

Incoming Non-self Citations Over Time

Authors

1. Zhuoyue Zhao (University of Utah)
2. Feifei Li (University of Utah)
3. Yuxi Liu (Shanghai Jiao Tong University; University of Utah)

BibTeX Citation

@inproceedings{zhao_sigmod20,
        title = {{Efficient Join Synopsis Maintenance for Data Warehouse}},
        author = {Zhao, Zhuoyue and Li, Feifei and Liu, Yuxi},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3389717},
        url = {https://dl.acm.org/doi/10.1145/3318464.3389717},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
982	Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation	2022	VLDB	0.00012714044
3,210	Efficiently Approximating Selectivity Functions using Low Overhead Regression Models	2020	VLDB	7.5363533e-05
3,494	On Join Sampling and the Hardness of Combinatorial Output-Sensitive Join Algorithms	2023	PODS	7.2582926e-05
7,467	Reservoir Sampling over Joins	2024	SIGMOD	5.5198675e-05
7,513	Computing A Well-Representative Summary of Conjunctive Query Results	2024	PODS	5.5049463e-05
8,894	QPJVis Demo: Quality-boost Progressive Join Query Processing System	2024	VLDB	5.2559789e-05
10,169	Transactional Panorama: A Conceptual Framework for User Perception in Analytical Visual Interfaces	2023	VLDB	5.0682654e-05
11,536	Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality	2024	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
57	On Random Sampling over Joins	1999	SIGMOD	0.00040108301
135	Ripple Joins for Online Aggregation	1999	SIGMOD	0.00029866033
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029627449
519	Random Sampling for Histogram Construction: How much is enough?	1998	SIGMOD	0.00016942879
594	Linear Road: A Stream Data Management Benchmark	2004	VLDB	0.00015823573
596	Wander Join: Online Aggregation via Random Walks	2016	SIGMOD	0.00015785583
795	Random Sampling over Joins Revisited	2018	SIGMOD	0.00013938779
840	Quickr: Lazily Approximating Complex AdHoc Queries in BigData Clusters	2016	SIGMOD	0.0001354605
842	Processing Complex Aggregate Queries over Data Streams	2002	SIGMOD	0.00013540697
1,108	Maximizing the Output Rate of Multi-Way Join Queries over Streaming Information Sources	2003	VLDB	0.00011991195
1,319	Augmented Sketch: Faster and More Accurate Stream Processing	2016	SIGMOD	0.00011045888
1,431	Approximate Join Processing Over Data Streams	2003	SIGMOD	0.00010681774
1,796	Dynamic Pipeline Scheduling for Improving Interactive Query Performance	2001	VLDB	9.6193021e-05
3,727	Memory-Limited Execution of Windowed Stream Joins	2004	VLDB	7.0696489e-05
5,877	BlinkML: Efficient Maximum Likelihood Estimation with Probabilistic Guarantees	2019	SIGMOD	5.9627218e-05
6,030	RPJ: Producing Fast Join Results on Streams through Rate-based Optimization	2005	SIGMOD	5.9105381e-05
7,136	On Joining and Caching Stochastic Streams	2005	SIGMOD	5.6014758e-05
7,462	Update-Pattern-Aware Modeling and Processing of Continuous Queries	2005	SIGMOD	5.521211e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,596	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
2	8,279	Subset Sampling over Joins	2026	PODS
3	7,609	Computing Complex Temporal Join Queries Efficiently	2022	SIGMOD
4	6,690	Diag-Join: An Opportunistic Join Algorithm for 1:N Relationships	1998	VLDB
5	3,494	On Join Sampling and the Hardness of Combinatorial Output-Sensitive Join Algorithms	2023	PODS
6	7,493	Synopses for Query Optimization: A Space-Complexity Perspective	2004	PODS
7	8,408	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD
8	1,034	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB
9	7,467	Reservoir Sampling over Joins	2024	SIGMOD
10	138	Join Synopses for Approximate Query Answering	1999	SIGMOD