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: 5851
Venue: SIGMOD
Year: 2020
Pagerank: 6.0102675e-05
Overall Rank: 6,012 | 58.76%
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,820	Parallelizing Intra-Window Join on Multicores: An Experimental Study	2021	SIGMOD	5.5373345e-05
9,998	SWIX: A Memory-efficient Sliding Window Learned Index	2024	SIGMOD	5.1814573e-05
10,102	Distributed Stream KNN Join	2021	SIGMOD	5.1488731e-05
10,765	HoneyComb: A Parallel Worst-Case Optimal Join on Multicores	2025	SIGMOD	5.093636e-05
10,873	Unraveling the Impact of Window Semantics: Optimizing Join Order for Efficient Stream Processing	2025	VLDB	5.093636e-05
11,159	PECJ: Stream Window Join on Disorder Data Streams with Proactive Error Compensation	2024	SIGMOD	5.093636e-05
11,181	Low-Latency Adaptive Distributed Stream Join System Based on a Flexible Join Model	2024	SIGMOD	5.093636e-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
67	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00038461275
204	Cache Conscious Indexing for Decision-Support in Main Memory	1999	VLDB	0.00025342994
219	A Study of Index Structures for Main Memory Database Management Systems	1986	VLDB	0.00024293529
220	Storm @Twitter	2014	SIGMOD	0.00024244587
710	Trill: A High-Performance Incremental Query Processor for Diverse Analytics	2015	VLDB	0.00014715033
1,315	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00011181796
1,353	SPADE: The System S Declarative Stream Processing Engine	2008	SIGMOD	0.00011061346
1,358	PLP: Page Latch-free Shared-everything OLTP	2011	VLDB	0.0001104203
1,369	How Soccer Players Would do Stream Joins	2011	SIGMOD	0.0001099892
1,710	Cache-Conscious Concurrency Control of Main-Memory Indexes on Shared-Memory Multiprocessor Systems	2001	VLDB	9.9537123e-05
1,822	PALM: Parallel Architecture-Friendly Latch-Free Modifications to B+ Trees on Many-Core Processors	2011	VLDB	9.6765747e-05
2,667	A Memory Bandwidth-Efficient Hybrid Radix Sort on GPUs	2017	SIGMOD	8.2756346e-05
3,060	SABER: Window-Based Hybrid Stream Processing for Heterogeneous Architectures	2016	SIGMOD	7.8062155e-05
3,378	A Hybrid B+-tree as Solution for In-Memory Indexing on CPU-GPU Heterogeneous Computing Platforms	2016	SIGMOD	7.4587887e-05
3,532	Scalable Distributed Stream Join Processing	2015	SIGMOD	7.3369085e-05
3,851	Analyzing Efficient Stream Processing on Modern Hardware	2019	VLDB	7.0735328e-05
5,310	Low-Latency Handshake Join	2014	VLDB	6.2702891e-05
5,809	Logical and Physical Versioning in Main Memory Databases	1997	VLDB	6.0801663e-05
7,217	ParPaRaw: Massively Parallel Parsing of Delimiter-Separated Raw Data	2020	VLDB	5.668373e-05

Semantically Similar Papers

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