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: 1721
Venue: PODS
Year: 2017
Pagerank: 8.5487602e-05
Overall Rank: 2,462 | 83.11%
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 22 of 22 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,246	Distributed Evaluation of Subgraph Queries Using Worst-case Optimal Low-Memory Dataflows	2018	VLDB	0.00011504088
4,244	Algorithmic Aspects of Parallel Query Processing	2018	SIGMOD	6.8062787e-05
4,371	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS	6.738679e-05
5,463	Cover or Pack: New Upper and Lower Bounds for Massively Parallel Joins	2021	PODS	6.2086169e-05
5,871	Cheetah: Accelerating Database Queries with Switch Pruning	2020	SIGMOD	6.0604381e-05
6,444	Output-Optimal Algorithms for Join-Aggregate Queries	2025	PODS	5.8774519e-05
6,583	Distance-Sensitive Hashing	2018	PODS	5.8359922e-05
7,143	Parallel Algorithms for Sparse Matrix Multiplication and Join-Aggregate Queries	2020	PODS	5.6915726e-05
7,451	The Complexity of Boolean Conjunctive Queries with Intersection Joins	2022	PODS	5.6135032e-05
8,394	Topology-aware Parallel Data Processing: Models, Algorithms and Systems at Scale	2020	CIDR	5.4349805e-05
9,052	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD	5.3251649e-05
9,235	Output-Sensitive Evaluation of Regular Path Queries	2025	PODS	5.3016261e-05
9,317	Set Similarity Search for Skewed Data	2018	PODS	5.289545e-05
10,816	Jodes: Efficient Oblivious Join in the Distributed Setting	2025	VLDB	5.093636e-05
11,132	Topology-aware Parallel Joins	2024	PODS	5.093636e-05
11,145	Parallel Communication Obliviousness: One Round and Beyond	2024	PODS	5.093636e-05
11,194	Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and Quality	2024	SIGMOD	5.093636e-05
11,634	Algorithms for a Topology-aware Massively Parallel Computation Model	2021	PODS	5.093636e-05
11,635	Two-Attribute Skew Free, Isolated CP Theorem, and Massively Parallel Joins	2021	PODS	5.093636e-05
11,677	Vertex-centric Parallel Computation of SQL Queries	2021	SIGMOD	5.093636e-05
11,751	On the I/O Complexity of the k-Nearest Neighbors Problem	2020	PODS	5.093636e-05
11,894	Distributed Statistical Estimation of Matrix Products with Applications	2018	PODS	5.093636e-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
954	Parallel Evaluation of Conjunctive Queries	2011	PODS	0.00012997301
1,207	Communication Steps for Parallel Query Processing	2013	PODS	0.00011663155
1,448	Skew in Parallel Query Processing	2014	PODS	0.00010758872
1,998	A Worst-Case Optimal Multi-Round Algorithm for Parallel Computation of Conjunctive Queries	2017	PODS	9.3363505e-05
2,183	The Input/Output Complexity of Triangle Enumeration	2014	PODS	9.0066814e-05
3,685	Parallel Algorithms for Constructing Range and Nearest-Neighbor Searching Data Structures	2016	PODS	7.2030591e-05
4,393	Bounded Conjunctive Queries	2014	VLDB	6.7280426e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	13,672	Exploiting Database Similarity Joins for Metric Spaces	2012	VLDB
2	9,052	Fast Approximate Similarity Join in Vector Databases	2025	SIGMOD
3	11,141	Optimal (Multiway) Spatial Joins	2024	PODS
4	7,326	Parallel Algorithms for High-dimensional Proximity Joins	1997	VLDB
5	4,371	Instance and Output Optimal Parallel Algorithms for Acyclic Joins	2019	PODS
6	2,104	Optimization of Multi-Way Join Queries for Parallel Execution	1991	VLDB
7	356	Efficient Parallel Set-Similarity Joins Using MapReduce	2010	SIGMOD
8	1,740	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
9	321	Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems	2018	PODS
10	12,090	Let's Rethink Join Optimization in Distributed Systems	2015	CIDR