Parallelizing Intra-Window Join on Multicores: An Experimental Study
Shuhao Zhang, Yancan Mao, Jiong He, Philipp M. Grulich, Steffen Zeuch, Bingsheng He, Richard T. B. Ma, Volker Markl
Abstract
The intra-window join (IaWJ), i.e., joining two input streams over a single window, is a core operation in modern stream processing applications. This paper presents the first comprehensive study on parallelizing the IaWJ on modern multicore architectures. In particular, we classify IaWJ algorithms into lazy and eager execution approaches. For each approach, there are further design aspects to consider, including different join methods and partitioning schemes, leading to a large design space. Our results show that none of the algorithms always performs the best, and the choice of the most performant algorithm depends on: (i) workload characteristics, (ii) application requirements, and (iii) hardware architectures. Based on the evaluation results, we propose a decision tree that can guide the selection of an appropriate algorithm.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Cited by top-tier papers6
- What Is the Price for Joining Securely? Benchmarking Equi-Joins in Trusted Execution EnvironmentsKajetan Jeremi Maliszewski, Jorge-Arnulfo Quiané-Ruiz, Jonas Traub, Volker MarklVLDB 2022 · 13 citations
- Parallelizing Stream Compression for IoT Applications on Asymmetric MulticoresXianzhi Zeng, Shuhao ZhangICDE 2023 · 10 citations
- Cracking-Like Join for Trusted Execution EnvironmentsKajetan Jeremi Maliszewski, Jorge-Arnulfo Quiané-Ruiz, Volker MarklVLDB 2023 · 4 citations
- PECJ: Stream Window Join on Disorder Data Streams with Proactive Error CompensationXianzhi Zeng, Shuhao Zhang, Hongbin Zhong, Hao Zhang et al.SIGMOD 2024 · 1 citation
- Enabling Adaptive Sampling for Intra-Window Join: Simultaneously Optimizing Quantity and QualityXilin Tang, Feng Zhang, Shuhao Zhang, Yani Liu et al.SIGMOD 2025 · 1 citation
Builds on3
- Pump Up the Volume: Processing Large Data on GPUs with Fast InterconnectsClemens Lutz, Sebastian Breß, Steffen Zeuch, Tilmann Rabl et al.SIGMOD 2020 · 99 citations
- LightSaber: Efficient Window Aggregation on Multi-core ProcessorsGeorgios Theodorakis, Alexandros Koliousis, Peter R. Pietzuch, Holger PirkSIGMOD 2020 · 36 citations
- Parallel Index-based Stream Join on a Multicore CPUAmirhesam Shahvarani, Hans-Arno JacobsenSIGMOD 2020 · 20 citations
Related papers
- Unraveling the Impact of Window Semantics: Optimizing Join Order for Efficient Stream ProcessingAriane Ziehn, Jan Szlang, Steffen Zeuch, Volker MarklVLDB 2025 · 2 citations
- AJoin: Ad-hoc Stream Joins at ScaleJeyhun Karimov, Tilmann Rabl, Volker MarklVLDB 2020 · 14 citations
- SASPAR: Shared Adaptive Stream PartitioningJeyhun Karimov, Hans-Arno JacobsenICDE 2023 · 3 citations
- Efficient Incremental Computation of Aggregations over Sliding WindowsChao Zhang, Reza Akbarinia, Farouk ToumaniKDD 2021 · 11 citations
- Correlation Joins over Time Series Data Streams Utilizing Complementary Dimension Reduction and TransformationAmirReza Alizade Nikoo, Michael H. Böhlen, Sven HelmerSIGMOD 2024 · 2 citations
