Parallel Index-based Stream Join on a Multicore CPU

Summary: Partitioned in-memory merge tree for indexing highly dynamic streaming windows, with a low-cost concurrency control for high-rate updates. A parallel index-based stream join exploits multicore CPUs; octa-core experiments report up to 5.5x throughput over a single-threaded approach. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h7ad891e0eaf859c0
Venue: SIGMOD
Year: 2020
Pagerank: 5.8567401e-05
Overall Rank: 6,139 | 58.86%
DOI: 10.1145/3318464.3380576

Incoming Non-self Citations Over Time

Authors

1. Amirhesam Shahvarani (Technical University of Munich)
2. Hans-Arno Jacobsen (Technical University of Munich)

BibTeX Citation

@inproceedings{shahvarani_sigmod20,
        title = {{Parallel Index-based Stream Join on a Multicore CPU}},
        author = {Shahvarani, Amirhesam and Jacobsen, Hans-Arno},
        series = {{SIGMOD} '20},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3318464.3380576},
        url = {https://dl.acm.org/doi/10.1145/3318464.3380576},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,985	Parallelizing Intra-Window Join on Multicores: An Experimental Study	2021	SIGMOD	5.3960833e-05
9,991	HoneyComb: A Parallel Worst-Case Optimal Join on Multicores	2025	SIGMOD	5.0845476e-05
10,222	SWIX: A Memory-efficient Sliding Window Learned Index	2024	SIGMOD	5.0460607e-05
10,362	Distributed Stream KNN Join	2021	SIGMOD	5.014328e-05
11,340	Unraveling the Impact of Window Semantics: Optimizing Join Order for Efficient Stream Processing	2025	VLDB	4.9605343e-05
11,563	PECJ: Stream Window Join on Disorder Data Streams with Proactive Error Compensation	2024	SIGMOD	4.9605343e-05
11,580	Low-Latency Adaptive Distributed Stream Join System Based on a Flexible Join Model	2024	SIGMOD	4.9605343e-05

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
68	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00037861537
209	Cache Conscious Indexing for Decision-Support in Main Memory	1999	VLDB	0.00024915373
230	A Study of Index Structures for Main Memory Database Management Systems	1986	VLDB	0.00023845485
233	Storm @Twitter	2014	SIGMOD	0.00023754096
688	Trill: A High-Performance Incremental Query Processor for Diverse Analytics	2015	VLDB	0.00014736145
1,340	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00010962559
1,384	PLP: Page Latch-free Shared-everything OLTP	2011	VLDB	0.00010824715
1,390	SPADE: The System S Declarative Stream Processing Engine	2008	SIGMOD	0.00010802626
1,391	How Soccer Players Would do Stream Joins	2011	SIGMOD	0.00010790581
1,724	Cache-Conscious Concurrency Control of Main-Memory Indexes on Shared-Memory Multiprocessor Systems	2001	VLDB	9.7779713e-05
1,865	PALM: Parallel Architecture-Friendly Latch-Free Modifications to B+ Trees on Many-Core Processors	2011	VLDB	9.4644494e-05
2,485	A Memory Bandwidth-Efficient Hybrid Radix Sort on GPUs	2017	SIGMOD	8.3800709e-05
3,117	SABER: Window-Based Hybrid Stream Processing for Heterogeneous Architectures	2016	SIGMOD	7.6142606e-05
3,383	A Hybrid B+-tree as Solution for In-Memory Indexing on CPU-GPU Heterogeneous Computing Platforms	2016	SIGMOD	7.3393628e-05
3,610	Scalable Distributed Stream Join Processing	2015	SIGMOD	7.1463915e-05
3,939	Analyzing Efficient Stream Processing on Modern Hardware	2019	VLDB	6.8967981e-05
5,455	Low-Latency Handshake Join	2014	VLDB	6.107413e-05
5,933	Logical and Physical Versioning in Main Memory Databases	1997	VLDB	5.926126e-05
6,079	ParPaRaw: Massively Parallel Parsing of Delimiter-Separated Raw Data	2020	VLDB	5.8759961e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	11,580	Low-Latency Adaptive Distributed Stream Join System Based on a Flexible Join Model	2024	SIGMOD
2	6,616	Revisiting Pipelined Parallelism in Multi-Join Query Processing	2005	VLDB
3	1,439	Approximate Join Processing Over Data Streams	2003	SIGMOD
4	3,610	Scalable Distributed Stream Join Processing	2015	SIGMOD
5	423	Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems	2012	VLDB
6	2,762	Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams	2003	VLDB
7	8,433	Effective Resource Utilization for Multiprocessor Join Execution	1989	VLDB
8	7,985	Parallelizing Intra-Window Join on Multicores: An Experimental Study	2021	SIGMOD
9	4,422	Shared Arrangements: practical inter-query sharing for streaming dataflows	2020	VLDB
10	2,704	Executing Stream Joins on the Cell Processor	2007	VLDB