Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries
Fuente:
arXiv
Saved in:
| Main Authors: | , , , |
|---|---|
| Format: | Preprint |
| Published: |
2023
|
| Subjects: | |
| Online Access: | |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1866918222963408896 |
|---|---|
| author | Yang, Yifei Zhao, Hangdong Yu, Xiangyao Koutris, Paraschos |
| author_facet | Yang, Yifei Zhao, Hangdong Yu, Xiangyao Koutris, Paraschos |
| contents | This paper presents predicate transfer, a novel method that optimizes join performance by pre-filtering tables to reduce the join input sizes. Predicate transfer generalizes Bloom join, which conducts pre-filtering within a single join operation, to multi-table joins such that the filtering benefits can be significantly increased. Predicate transfer is inspired by the seminal theoretical results by Yannakakis, which uses semi-joins to pre-filter acyclic queries. Predicate transfer generalizes the theoretical results to any join graphs and use Bloom filters to replace semi-joins leading to significant speedup. Evaluation shows predicate transfer can outperform Bloom join by 3.1x on average on TPC-H benchmark. |
| format | Preprint |
| id |
arxiv_https___arxiv_org_abs_2307_15255 |
| institution | arXiv |
| publishDate | 2023 |
| record_format | arxiv |
| spellingShingle | Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries Yang, Yifei Zhao, Hangdong Yu, Xiangyao Koutris, Paraschos Databases This paper presents predicate transfer, a novel method that optimizes join performance by pre-filtering tables to reduce the join input sizes. Predicate transfer generalizes Bloom join, which conducts pre-filtering within a single join operation, to multi-table joins such that the filtering benefits can be significantly increased. Predicate transfer is inspired by the seminal theoretical results by Yannakakis, which uses semi-joins to pre-filter acyclic queries. Predicate transfer generalizes the theoretical results to any join graphs and use Bloom filters to replace semi-joins leading to significant speedup. Evaluation shows predicate transfer can outperform Bloom join by 3.1x on average on TPC-H benchmark. |
| title | Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries |
| topic | Databases |
| url | https://arxiv.org/abs/2307.15255 |