DBScholar

Back to papers

Parallelizing Intra-Window Join on Multicores: An Experimental Study

Summary: Experimental study of parallel intra-window joins on multicore CPUs, classifying IaWJ algorithms into lazy and eager execution with different join methods and partitioning. No universal winner; performance depends on workload, requirements, and hardware; a decision tree guides the best algorithm. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
6136
Venue
SIGMOD
Year
2021
Pagerank
5.5373345e-05
Overall Rank
7,820 | 46.35%
DOI
10.1145/3448016.3452793

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhang_sigmod21,
        title = {{Parallelizing Intra-Window Join on Multicores: An Experimental Study}},
        author = {Zhang, Shuhao and Mao, Yancan and He, Jiong and Grulich, Philipp M. and Zeuch, Steffen and He, Bingsheng and Ma, Richard T. B. and Markl, Volker},
        series = {{SIGMOD} '21},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3448016.3452793},
        url = {https://dl.acm.org/doi/10.1145/3448016.3452793},
        year = {2021}
}

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 22 of 22 cited papers.

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

Rank Cited Paper Year Venue Pagerank
131 Ripple Joins for Online Aggregation 1999 SIGMOD 0.00030424509
209 Sort vs. Hash Revisited: Fast Join Implementation on Modern Multi-Core CPUs 2009 VLDB 0.00024932174
220 Storm @Twitter 2014 SIGMOD 0.00024244587
252 Multi-Core, Main-Memory Joins: Sort vs. Hash Revisited 2014 VLDB 0.00023242719
360 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.00020182846
423 Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems 2012 VLDB 0.00018725853
712 Efficient Implementation of Sorting on Multi-Core SIMD CPU Architecture 2008 VLDB 0.0001468812
959 Memory-Efficient Hash Joins 2015 VLDB 0.00012953588
1,265 An Experimental Comparison of Thirteen Relational Equi-Joins in Main Memory 2016 SIGMOD 0.00011415709
1,369 How Soccer Players Would do Stream Joins 2011 SIGMOD 0.0001099892
2,566 Pump Up the Volume: Processing Large Data on GPUs with Fast Interconnects 2020 SIGMOD 8.4116562e-05
2,787 Progressive Merge Join: A Generic and Non-Blocking Sort-Based Join Algorithm 2002 VLDB 8.1205738e-05
2,892 Scalable and Adaptive Online Joins 2014 VLDB 7.9852178e-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,215 The NebulaStream Platform: Data and Application Management for the Internet of Things 2020 CIDR 6.3124972e-05
5,310 Low-Latency Handshake Join 2014 VLDB 6.2702891e-05
5,515 FPGA-based Multithreading for In-Memory Hash Joins 2015 CIDR 6.189963e-05
5,663 Early Hash Join: A Configurable Algorithm for the Efficient and Early Production of Join Results 2005 VLDB 6.1298345e-05
5,911 RPJ: Producing Fast Join Results on Streams through Rate-based Optimization 2005 SIGMOD 6.0443263e-05
6,012 Parallel Index-based Stream Join on a Multicore CPU 2020 SIGMOD 6.0102675e-05
6,108 Providing Streaming Joins as a Service at Facebook 2018 VLDB 5.9730511e-05
Previous Page 1 / 1 Next

Semantically Similar Papers