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.3947133e-05
Overall Rank: 2,475 | 83.42%
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,253	Distributed Evaluation of Subgraph Queries Using Worst-case Optimal Low-Memory Dataflows	2018	VLDB	0.00011316982
4,357	Algorithmic Aspects of Parallel Query Processing	2018	SIGMOD	6.6290396e-05
4,487	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS	6.5628751e-05
5,610	Cover or Pack: New Upper and Lower Bounds for Massively Parallel Joins	2021	PODS	6.0498245e-05
5,972	Cheetah: Accelerating Database Queries with Switch Pruning	2020	SIGMOD	5.9114227e-05
6,585	Output-Optimal Algorithms for Join-Aggregate Queries	2025	PODS	5.7238683e-05
6,717	Distance-Sensitive Hashing	2018	PODS	5.6843145e-05
6,979	The Complexity of Boolean Conjunctive Queries with Intersection Joins	2022	PODS	5.6129856e-05
7,313	Parallel Algorithms for Sparse Matrix Multiplication and Join-Aggregate Queries	2020	PODS	5.5428538e-05
8,434	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD	5.3165535e-05
8,576	Topology-aware Parallel Data Processing: Models, Algorithms and Systems at Scale	2020	CIDR	5.2968015e-05
9,445	Output-Sensitive Evaluation of Regular Path Queries	2025	PODS	5.1630894e-05
9,535	Set Similarity Search for Skewed Data	2018	PODS	5.151324e-05
11,098	Advances of Query Processing in Vector Databases	2026	VLDB	4.9605343e-05
11,289	Jodes: Efficient Oblivious Join in the Distributed Setting	2025	VLDB	4.9605343e-05
11,538	Topology-aware Parallel Joins	2024	PODS	4.9605343e-05
11,551	Parallel Communication Obliviousness: One Round and Beyond	2024	PODS	4.9605343e-05
11,591	Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality	2024	SIGMOD	4.9605343e-05
11,991	Algorithms for a Topology-aware Massively Parallel Computation Model	2021	PODS	4.9605343e-05
11,992	Two-Attribute Skew Free, Isolated CP Theorem, and Massively Parallel Joins	2021	PODS	4.9605343e-05
12,034	Vertex-centric Parallel Computation of SQL Queries	2021	SIGMOD	4.9605343e-05
12,104	On the I/O Complexity of the k-Nearest Neighbors Problem	2020	PODS	4.9605343e-05
12,243	Distributed Statistical Estimation of Matrix Products with Applications	2018	PODS	4.9605343e-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
982	Parallel Evaluation of Conjunctive Queries	2011	PODS	0.00012687016
1,242	Communication Steps for Parallel Query Processing	2013	PODS	0.00011372366
1,483	Skew in Parallel Query Processing	2014	PODS	0.00010500209
2,052	A Worst-Case Optimal Multi-Round Algorithm for Parallel Computation of Conjunctive Queries	2017	PODS	9.1064522e-05
2,229	The Input/Output Complexity of Triangle Enumeration	2014	PODS	8.7890942e-05
3,761	Parallel Algorithms for Constructing Range and Nearest-Neighbor Searching Data Structures	2016	PODS	7.0186907e-05
4,473	Bounded Conjunctive Queries	2014	VLDB	6.570529e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	14,030	Exploiting Database Similarity Joins for Metric Spaces	2012	VLDB
2	8,434	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD
3	11,547	Optimal (Multiway) Spatial Joins	2024	PODS
4	7,491	Parallel Algorithms for High-dimensional Proximity Joins	1997	VLDB
5	4,487	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS
6	2,151	Optimization of Multi-Way Join Queries for Parallel Execution	1991	VLDB
7	359	Efficient Parallel Set-Similarity Joins Using MapReduce	2010	SIGMOD
8	318	Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems	2018	PODS
9	1,603	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
10	12,432	Let's Rethink Join Optimization in Distributed Systems	2015	CIDR