Lightning Fast and Space Efficient Inequality Joins
Summary: Introduces fast inequality join algorithms using sorted arrays, permutation encodings of cross-array positions, and space-efficient bit-arrays with Bloom-filter-like indices. Centralized PostgreSQL and distributed Spark SQL implementations outperform traditional methods, showing scalable, orders-of-magnitude speedups. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Zuhair Khayyat (King Abdullah University of Science and Technology; Qatar Computing Research Institute)
- 2. William Lucia (Qatar Computing Research Institute)
- 3. Meghna Singh (Qatar Computing Research Institute)
- 4. Mourad Ouzzani (Qatar Computing Research Institute)
- 5. Paolo Papotti (Qatar Computing Research Institute)
- 6. Jorge-Arnulfo Quiané-Ruiz (Qatar Computing Research Institute)
- 7. Nan Tang (Qatar Computing Research Institute)
- 8. Panos Kalnis (King Abdullah University of Science and Technology)
BibTeX Citation
@article{khayyat_vldb15,
title = {{Lightning Fast and Space Efficient Inequality Joins}},
author = {Khayyat, Zuhair and Lucia, William and Singh, Meghna and Ouzzani, Mourad and Papotti, Paolo and Quiané-Ruiz, Jorge-Arnulfo and Tang, Nan and Kalnis, Panos},
journal = {PVLDB},
series = {{VLDB} '15},
volume = {8},
number = {13},
pages = {2074--2085},
doi = {10.14778/2831360.2831362},
url = {https://doi.org/10.14778/2831360.2831362},
year = {2015}
}Incoming Citations (Sorted by Pagerank)
Showing 14 of 14 citing papers.
Previous
Page 1 / 1
Next
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.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 13,541 | Errata for “Lightning Fast and Space Efficient Inequality Joins” (PVLDB 8(13): 2074-2085) | 2017 | VLDB |
| 2 | 9,333 | Efficiently Joining Large Relations on Multi-GPU Systems | 2025 | VLDB |
| 3 | 5,364 | Fast Join Project Query Evaluation using Matrix Multiplication | 2020 | SIGMOD |
| 4 | 3,617 | Scalable Computation of Acyclic Joins (Extended Abstract) | 2006 | PODS |
| 5 | 5,467 | On Producing Join Results Early | 2003 | PODS |
| 6 | 1,740 | Adopting Worst-Case Optimal Joins in Relational Database Systems | 2020 | VLDB |
| 7 | 3,134 | Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment | 2021 | VLDB |
| 8 | 7,207 | A Scalable and Generic Approach to Range Joins | 2022 | VLDB |
| 9 | 11,556 | Scaling Equi-Joins | 2022 | SIGMOD |
| 10 | 12,090 | Let's Rethink Join Optimization in Distributed Systems | 2015 | CIDR |