Output-optimal Parallel Algorithms for Similarity Joins

Summary: Refines Beame et al.'s 2-relation output-optimal parallel join to true optimality and develops output-optimal parallel algorithms for a broad class of similarity joins (ℓ1, ℓ2, ℓ∞), including LSH-based methods. Proves a lower bound ruling out output-optimal algorithms for joins with >2 relations. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: h332d61ddca1c94d3
Venue: PODS
Year: 2017
Pagerank: 8.4221003e-05
Overall Rank: 2,464 | 83.45%
DOI: 10.1145/3034786.3056110

Incoming Non-self Citations Over Time

Authors

1. Xiao Hu (Hong Kong University of Science and Technology)
2. Yufei Tao (University of Queensland)
3. Ke Yi (Hong Kong University of Science and Technology)

BibTeX Citation

@inproceedings{hu_pods17,
        address = {New York, NY, USA},
        series = {{PODS} '17},
        title = {{Output-optimal Parallel Algorithms for Similarity Joins}},
        url = {https://dl.acm.org/doi/10.1145/3034786.3056110},
        doi = {10.1145/3034786.3056110},
        booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
        publisher = {Association for Computing Machinery},
        author = {Hu, Xiao and Tao, Yufei and Yi, Ke},
        year = {2017}
}

Incoming Citations (Sorted by Pagerank)

Showing 23 of 23 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,252	Distributed Evaluation of Subgraph Queries Using Worst-case Optimal Low-Memory Dataflows	2018	VLDB	0.00011334813
4,337	Algorithmic Aspects of Parallel Query Processing	2018	SIGMOD	6.6510297e-05
4,466	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS	6.584648e-05
5,596	Cover or Pack: New Upper and Lower Bounds for Massively Parallel Joins	2021	PODS	6.0698953e-05
5,959	Cheetah: Accelerating Database Queries with Switch Pruning	2020	SIGMOD	5.9310224e-05
6,576	Output-Optimal Algorithms for Join-Aggregate Queries	2025	PODS	5.7428578e-05
6,708	Distance-Sensitive Hashing	2018	PODS	5.7027685e-05
6,958	The Complexity of Boolean Conjunctive Queries with Intersection Joins	2022	PODS	5.6316072e-05
7,295	Parallel Algorithms for Sparse Matrix Multiplication and Join-Aggregate Queries	2020	PODS	5.5612427e-05
8,416	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD	5.3341916e-05
8,557	Topology-aware Parallel Data Processing: Models, Algorithms and Systems at Scale	2020	CIDR	5.314366e-05
9,420	Output-Sensitive Evaluation of Regular Path Queries	2025	PODS	5.1802184e-05
9,506	Set Similarity Search for Skewed Data	2018	PODS	5.168414e-05
11,037	Advances of Query Processing in Vector Databases	2026	VLDB	4.9769913e-05
11,233	Jodes: Efficient Oblivious Join in the Distributed Setting	2025	VLDB	4.9769913e-05
11,486	Topology-aware Parallel Joins	2024	PODS	4.9769913e-05
11,499	Parallel Communication Obliviousness: One Round and Beyond	2024	PODS	4.9769913e-05
11,542	Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality	2024	SIGMOD	4.9769913e-05
11,947	Algorithms for a Topology-aware Massively Parallel Computation Model	2021	PODS	4.9769913e-05
11,948	Two-Attribute Skew Free, Isolated CP Theorem, and Massively Parallel Joins	2021	PODS	4.9769913e-05
11,990	Vertex-centric Parallel Computation of SQL Queries	2021	SIGMOD	4.9769913e-05
12,060	On the I/O Complexity of the k-Nearest Neighbors Problem	2020	PODS	4.9769913e-05
12,200	Distributed Statistical Estimation of Matrix Products with Applications	2018	PODS	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
978	Parallel Evaluation of Conjunctive Queries	2011	PODS	0.00012725823
1,233	Communication Steps for Parallel Query Processing	2013	PODS	0.00011404978
1,482	Skew in Parallel Query Processing	2014	PODS	0.00010534147
2,045	A Worst-Case Optimal Multi-Round Algorithm for Parallel Computation of Conjunctive Queries	2017	PODS	9.1363731e-05
2,216	The Input/Output Complexity of Triangle Enumeration	2014	PODS	8.8152513e-05
3,757	Parallel Algorithms for Constructing Range and Nearest-Neighbor Searching Data Structures	2016	PODS	7.0419501e-05
4,452	Bounded Conjunctive Queries	2014	VLDB	6.5918046e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	11,347	Extensible and Robust Evaluation of Similarity Queries	2025	VLDB
2	8,416	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD
3	11,495	Optimal (Multiway) Spatial Joins	2024	PODS
4	7,472	Parallel Algorithms for High-dimensional Proximity Joins	1997	VLDB
5	4,466	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS
6	2,138	Optimization of Multi-Way Join Queries for Parallel Execution	1991	VLDB
7	360	Efficient Parallel Set-Similarity Joins Using MapReduce	2010	SIGMOD
8	315	Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems	2018	PODS
9	1,596	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
10	12,389	Let's Rethink Join Optimization in Distributed Systems	2015	CIDR