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: 5789
Venue: SIGMOD
Year: 2020
Pagerank: 5.0496617e-05
Overall Rank: 6,476 | 54.95%
DOI: 10.1145/3318464.3380576

Incoming Non-self Citations Over Time

Authors

1. Amirhesam Shahvarani
2. Hans-Arno Jacobsen

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,018	Parallelizing Intra-Window Join on Multicores: An Experimental Study	2021	SIGMOD	4.6046381e-05
9,953	Distributed Stream KNN Join	2021	SIGMOD	4.2405999e-05
10,488	HoneyComb: A Parallel Worst-Case Optimal Join on Multicores	2025	SIGMOD	4.1945683e-05
10,616	Unraveling the Impact of Window Semantics: Optimizing Join Order for Efficient Stream Processing	2025	VLDB	4.1945683e-05
10,941	PECJ: Stream Window Join on Disorder Data Streams with Proactive Error Compensation	2024	SIGMOD	4.1945683e-05
10,949	SWIX: A Memory-efficient Sliding Window Learned Index	2024	SIGMOD	4.1945683e-05
10,967	Low-Latency Adaptive Distributed Stream Join System Based on a Flexible Join Model	2024	SIGMOD	4.1945683e-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
103	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00049150032
233	A Study of Index Structures for Main Memory Database Management Systems	1986	VLDB	0.00032021526
238	Cache Conscious Indexing for Decision-Support in Main Memory	1999	VLDB	0.00031642425
288	Storm @Twitter	2014	SIGMOD	0.00028939871
1,098	Trill: A High-Performance Incremental Query Processor for Diverse Analytics	2015	VLDB	0.00014114442
1,467	SPADE: The System S Declarative Stream Processing Engine	2008	SIGMOD	0.00011849864
1,603	PLP: Page Latch-free Shared-everything OLTP	2011	VLDB	0.00011196902
1,694	How Soccer Players Would do Stream Joins	2011	SIGMOD	0.00010893764
1,731	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.0001073454
2,006	PALM: Parallel Architecture-Friendly Latch-Free Modifications to B+ Trees on Many-Core Processors	2011	VLDB	9.8101551e-05
2,244	Cache-Conscious Concurrency Control of Main-Memory Indexes on Shared-Memory Multiprocessor Systems	2001	VLDB	9.2097912e-05
3,151	A Memory Bandwidth-Efficient Hybrid Radix Sort on GPUs	2017	SIGMOD	7.4720668e-05
3,762	SABER: Window-Based Hybrid Stream Processing for Heterogeneous Architectures	2016	SIGMOD	6.7804471e-05
3,777	A Hybrid B+-tree as Solution for In-Memory Indexing on CPU-GPU Heterogeneous Computing Platforms	2016	SIGMOD	6.7750901e-05
4,167	Scalable Distributed Stream Join Processing	2015	SIGMOD	6.3919506e-05
4,488	Analyzing Efficient Stream Processing on Modern Hardware	2019	VLDB	6.145117e-05
5,866	Low-Latency Handshake Join	2014	VLDB	5.2968632e-05
5,886	Logical and Physical Versioning in Main Memory Databases	1997	VLDB	5.2880714e-05
7,360	ParPaRaw: Massively Parallel Parsing of Delimiter-Separated Raw Data	2020	VLDB	4.7525925e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
10,967	Low-Latency Adaptive Distributed Stream Join System Based on a Flexible Join Model	2024	SIGMOD	4.1945683e-05
6,324	Revisiting Pipelined Parallelism in Multi-Join Query Processing	2005	VLDB	5.1109987e-05
1,717	Approximate Join Processing Over Data Streams	2003	SIGMOD	0.00010793312
4,167	Scalable Distributed Stream Join Processing	2015	SIGMOD	6.3919506e-05
585	Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems	2012	VLDB	0.00019706145
7,839	Effective Resource Utilization for Multiprocessor Join Execution	1989	VLDB	4.637294e-05
3,656	Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams	2003	VLDB	6.8714509e-05
8,018	Parallelizing Intra-Window Join on Multicores: An Experimental Study	2021	SIGMOD	4.6046381e-05
4,920	Shared Arrangements: practical inter-query sharing for streaming dataflows	2020	VLDB	5.8241888e-05
2,763	Executing Stream Joins on the Cell Processor	2007	VLDB	8.1579306e-05