{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,19]],"date-time":"2026-03-19T02:18:08Z","timestamp":1773886688766,"version":"3.50.1"},"publisher-location":"New York, NY, USA","reference-count":47,"publisher":"ACM","license":[{"start":{"date-parts":[[2021,6,9]],"date-time":"2021-06-09T00:00:00Z","timestamp":1623196800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"DOI":"10.13039\/501100000781","name":"European Research Council","doi-asserted-by":"publisher","award":["725286"],"award-info":[{"award-number":["725286"]}],"id":[{"id":"10.13039\/501100000781","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2021,6,9]]},"DOI":"10.1145\/3448016.3452831","type":"proceedings-article","created":{"date-parts":[[2021,6,18]],"date-time":"2021-06-18T17:22:39Z","timestamp":1624036959000},"page":"168-180","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":38,"title":["To Partition, or Not to Partition, That is the Join Question in a Real System"],"prefix":"10.1145","author":[{"given":"Maximilian","family":"Bandle","sequence":"first","affiliation":[{"name":"Technische Universit\u00e4t M\u00fcnchen, Munich, Germany"}]},{"given":"Jana","family":"Giceva","sequence":"additional","affiliation":[{"name":"Technische Universit\u00e4t M\u00fcnchen, Munich, Germany"}]},{"given":"Thomas","family":"Neumann","sequence":"additional","affiliation":[{"name":"Technische Universit\u00e4t M\u00fcnchen, Munich, Germany"}]}],"member":"320","published-online":{"date-parts":[[2021,6,18]]},"reference":[{"key":"e_1_3_2_2_1_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.367892"},{"key":"e_1_3_2_2_2_1","doi-asserted-by":"publisher","DOI":"10.14778\/2336664.2336678"},{"key":"e_1_3_2_2_3_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732219.2732227"},{"key":"e_1_3_2_2_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544839"},{"key":"e_1_3_2_2_5_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2014.2313874"},{"key":"e_1_3_2_2_6_1","doi-asserted-by":"publisher","DOI":"10.14778\/2735496.2735499"},{"key":"e_1_3_2_2_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989328"},{"key":"e_1_3_2_2_8_1","volume-title":"TPCTC 2017","author":"Boncz P. A.","year":"2017","unstructured":"P. A. Boncz , A. G. Anadiotis , and S. Kl\"a be. JCC-H : adding join crossing correlations with skew to TPC-H. In Performance Evaluation and Benchmarking for the Analytics Era - 9th TPC Technology Conference , TPCTC 2017 , Munich, Germany , August 28, 2017 , Revised Selected Papers, pages 103--119, 2017. P. A. Boncz, A. G. Anadiotis, and S. Kl\"a be. JCC-H: adding join crossing correlations with skew to TPC-H. In Performance Evaluation and Benchmarking for the Analytics Era - 9th TPC Technology Conference, TPCTC 2017, Munich, Germany, August 28, 2017, Revised Selected Papers, pages 103--119, 2017."},{"key":"e_1_3_2_2_9_1","doi-asserted-by":"publisher","DOI":"10.5555\/645925.671364"},{"key":"e_1_3_2_2_10_1","volume-title":"TPCTC 2013","author":"Boncz P. A.","year":"2013","unstructured":"P. A. Boncz , T. Neumann , and O. Erling . TPC-H analyzed: Hidden messages and lessons learned from an influential benchmark. In Performance Characterization and Benchmarking - 5th TPC Technology Conference , TPCTC 2013 , Trento, Italy , August 26, 2013 , Revised Selected Papers, pages 61--76, 2013. P. A. Boncz, T. Neumann, and O. Erling. TPC-H analyzed: Hidden messages and lessons learned from an influential benchmark. In Performance Characterization and Benchmarking - 5th TPC Technology Conference, TPCTC 2013, Trento, Italy, August 26, 2013, Revised Selected Papers, pages 61--76, 2013."},{"key":"e_1_3_2_2_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/3389133.3389138"},{"key":"e_1_3_2_2_12_1","first-page":"18","volume-title":"International Workshop on Accelerating Analytics and Data Management Systems Using Modern Processor and Storage Architectures, ADMS@VLDB 2017","author":"Fang J.","year":"2017","unstructured":"J. Fang , J. Lee , P. Hofstee , and J. Hidders . Analyzing in-memory hash joins: Granularity matters . In International Workshop on Accelerating Analytics and Data Management Systems Using Modern Processor and Storage Architectures, ADMS@VLDB 2017 , Munich, Germany , September 1, 2017 ., pages 18 -- 25 , 2017. J. Fang, J. Lee, P. Hofstee, and J. Hidders. Analyzing in-memory hash joins: Granularity matters. In International Workshop on Accelerating Analytics and Data Management Systems Using Modern Processor and Storage Architectures, ADMS@VLDB 2017, Munich, Germany, September 1, 2017., pages 18--25, 2017."},{"key":"e_1_3_2_2_13_1","volume-title":"CIDR","author":"Freitag M.","year":"2020","unstructured":"M. Freitag and T. Neumann . Umbra: A disk-based system with in-memory performance . In CIDR , 2020 . M. Freitag and T. Neumann. Umbra: A disk-based system with in-memory performance. In CIDR, 2020."},{"key":"e_1_3_2_2_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3035946"},{"key":"e_1_3_2_2_15_1","first-page":"30","author":"Kersten T.","year":"2021","unstructured":"T. Kersten , V. Leis , and T. Neumann . Tidy Tuples and Flying Start: Fast Compilation and Fast Execution of Relational Queries in Umbra. VLDB J. , 30 , 2021 . T. Kersten, V. Leis, and T. Neumann. Tidy Tuples and Flying Start: Fast Compilation and Fast Execution of Relational Queries in Umbra. VLDB J., 30, 2021.","journal-title":"VLDB J."},{"key":"e_1_3_2_2_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/3269206.3271680"},{"key":"e_1_3_2_2_17_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687564"},{"key":"e_1_3_2_2_18_1","volume-title":"In Memory Data Management and Analysis - First and Second International Workshops, IMDM 2013, Riva del Garda, Italy, August 26, 2013, IMDM 2014","author":"Lang H.","year":"2014","unstructured":"H. Lang , V. Leis , M. Albutiu , T. Neumann , and A. Kemper . Massively parallel numa-aware hash joins . In In Memory Data Management and Analysis - First and Second International Workshops, IMDM 2013, Riva del Garda, Italy, August 26, 2013, IMDM 2014 , Hongzhou, China , September 1, 2014 , Revised Selected Papers, pages 3--14, 2013. H. Lang, V. Leis, M. Albutiu, T. Neumann, and A. Kemper. Massively parallel numa-aware hash joins. In In Memory Data Management and Analysis - First and Second International Workshops, IMDM 2013, Riva del Garda, Italy, August 26, 2013, IMDM 2014, Hongzhou, China, September 1, 2014, Revised Selected Papers, pages 3--14, 2013."},{"key":"e_1_3_2_2_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882925"},{"key":"e_1_3_2_2_20_1","doi-asserted-by":"publisher","DOI":"10.14778\/3303753.3303757"},{"key":"e_1_3_2_2_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2610507"},{"key":"e_1_3_2_2_22_1","doi-asserted-by":"publisher","DOI":"10.14778\/2850583.2850594"},{"key":"e_1_3_2_2_23_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-017-0475-4"},{"key":"e_1_3_2_2_24_1","volume-title":"VLDB 2000, Proceedings of 26th International Conference on Very Large Data Bases, September 10--14, 2000","author":"Manegold S.","year":"2000","unstructured":"S. Manegold , P. A. Boncz , and M. L. Kersten . What happens during a join? dissecting CPU and memory optimization effects . In VLDB 2000, Proceedings of 26th International Conference on Very Large Data Bases, September 10--14, 2000 , Cairo, Egypt, pages 339--350 , 2000 . S. Manegold, P. A. Boncz, and M. L. Kersten. What happens during a join? dissecting CPU and memory optimization effects. In VLDB 2000, Proceedings of 26th International Conference on Very Large Data Bases, September 10--14, 2000, Cairo, Egypt, pages 339--350, 2000."},{"key":"e_1_3_2_2_25_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2002.1019210"},{"key":"e_1_3_2_2_26_1","first-page":"684","volume-title":"VLDB 2004","author":"Manegold S.","year":"2004","unstructured":"S. Manegold , P. A. Boncz , and N. Nes . Cache-conscious radix-decluster projections. In (e)Proceedings of the Thirtieth International Conference on Very Large Data Bases , VLDB 2004 , Toronto, Canada, August 31 - September 3 2004 , pages 684 -- 695 , 2004. S. Manegold, P. A. Boncz, and N. Nes. Cache-conscious radix-decluster projections. In (e)Proceedings of the Thirtieth International Conference on Very Large Data Bases, VLDB 2004, Toronto, Canada, August 31 - September 3 2004, pages 684--695, 2004."},{"key":"e_1_3_2_2_27_1","doi-asserted-by":"publisher","DOI":"10.14778\/3151113.3151114"},{"key":"e_1_3_2_2_28_1","doi-asserted-by":"publisher","DOI":"10.14778\/3402707.3402723"},{"key":"e_1_3_2_2_29_1","doi-asserted-by":"publisher","DOI":"10.14778\/2733004.2733076"},{"key":"e_1_3_2_2_30_1","volume-title":"Apr","author":"Neumann T.","year":"2016","unstructured":"T. Neumann . Comparing join implementations. http:\/\/databasearchitects.blogspot.com\/2016\/04\/comparing-join-implementations.html , Apr 2016 . T. Neumann. Comparing join implementations. http:\/\/databasearchitects.blogspot.com\/2016\/04\/comparing-join-implementations.html, Apr 2016."},{"key":"e_1_3_2_2_31_1","first-page":"383","volume-title":"BTW","author":"Neumann T.","year":"2015","unstructured":"T. Neumann and A. Kemper . Unnesting arbitrary queries . In BTW , Germany , pages 383 -- 402 , 2015 . T. Neumann and A. Kemper. Unnesting arbitrary queries. In BTW, Germany, pages 383--402, 2015."},{"issue":"1","key":"e_1_3_2_2_32_1","first-page":"3","article-title":"Compiling database queries into machine code","volume":"37","author":"Neumann T.","year":"2014","unstructured":"T. Neumann and V. Leis . Compiling database queries into machine code . IEEE Data Eng. Bull. , 37 ( 1 ): 3 -- 11 , 2014 . T. Neumann and V. Leis. Compiling database queries into machine code. IEEE Data Eng. Bull., 37(1):3--11, 2014.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_3_2_2_33_1","first-page":"31","volume-title":"BTW","author":"Neumann T.","year":"2017","unstructured":"T. Neumann , V. Leis , and A. Kemper . The complete story of joins (in hyper) . In BTW , Germany , pages 31 -- 50 , 2017 . T. Neumann, V. Leis, and A. Kemper. The complete story of joins (in hyper). In BTW, Germany, pages 31--50, 2017."},{"key":"e_1_3_2_2_34_1","doi-asserted-by":"publisher","DOI":"10.14778\/3007328.3007336"},{"key":"e_1_3_2_2_35_1","first-page":"07","article-title":"Joins on high-bandwidth memory: a new level in the memory hierarchy","author":"Pohl C.","year":"2019","unstructured":"C. Pohl , K.-U. Sattler , and G. Graefe . Joins on high-bandwidth memory: a new level in the memory hierarchy . The VLDB Journal , 07 2019 . C. Pohl, K.-U. Sattler, and G. Graefe. Joins on high-bandwidth memory: a new level in the memory hierarchy. The VLDB Journal, 07 2019.","journal-title":"The VLDB Journal"},{"key":"e_1_3_2_2_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2747645"},{"key":"e_1_3_2_2_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/2588555.2610522"},{"key":"e_1_3_2_2_38_1","doi-asserted-by":"publisher","DOI":"10.14778\/2850583.2850585"},{"key":"e_1_3_2_2_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807207"},{"key":"e_1_3_2_2_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882917"},{"key":"e_1_3_2_2_41_1","doi-asserted-by":"publisher","DOI":"10.14778\/2777598.2777602"},{"key":"e_1_3_2_2_42_1","doi-asserted-by":"publisher","DOI":"10.5555\/645920.758363"},{"key":"e_1_3_2_2_43_1","first-page":"1196","volume-title":"29th IEEE International Conference on Data Engineering, ICDE 2013","author":"Shrinivas L.","year":"2013","unstructured":"L. Shrinivas , S. Bodagala , R. Varadarajan , A. Cary , V. Bharathan , and C. Bear . Materialization strategies in the vertica analytic database: Lessons learned. In C. S. Jensen, C. M. Jermaine, and X. Zhou, editors , 29th IEEE International Conference on Data Engineering, ICDE 2013 , Brisbane, Australia, April 8--12 , 2013 , pages 1196 -- 1207 . IEEE Computer Society, 2013. L. Shrinivas, S. Bodagala, R. Varadarajan, A. Cary, V. Bharathan, and C. Bear. Materialization strategies in the vertica analytic database: Lessons learned. In C. S. Jensen, C. M. Jermaine, and X. Zhou, editors, 29th IEEE International Conference on Data Engineering, ICDE 2013, Brisbane, Australia, April 8--12, 2013, pages 1196--1207. IEEE Computer Society, 2013."},{"key":"e_1_3_2_2_44_1","unstructured":"Transaction Processing Performance Council (TPC). TPC BENCHMARK$^\u2122$ H (Decision Support) -- Standard Specification Revision 2.18.0. 1993--2018.  Transaction Processing Performance Council (TPC). TPC BENCHMARK$^\u2122$ H (Decision Support) -- Standard Specification Revision 2.18.0. 1993--2018."},{"key":"e_1_3_2_2_45_1","doi-asserted-by":"publisher","DOI":"10.1145\/3209950.3209952"},{"key":"e_1_3_2_2_46_1","first-page":"160","volume-title":"Proceedings, Part II","author":"Wassenberg J.","year":"2011","unstructured":"J. Wassenberg and P. Sanders . Engineering a multi-core radix sort. In Euro-Par 2011 Parallel Processing - 17th International Conference, Euro-Par 2011, Bordeaux, France, August 29 - September 2, 2011 , Proceedings, Part II , pages 160 -- 169 , 2011 . J. Wassenberg and P. Sanders. Engineering a multi-core radix sort. In Euro-Par 2011 Parallel Processing - 17th International Conference, Euro-Par 2011, Bordeaux, France, August 29 - September 2, 2011, Proceedings, Part II, pages 160--169, 2011."},{"key":"e_1_3_2_2_47_1","volume-title":"CIDR","author":"Zhang Z.","year":"2019","unstructured":"Z. Zhang , H. Deshmukh , and J. M. Patel . Data partitioning for in-memory systems: Myths, challenges, and opportunities . In CIDR , 2019 . Z. Zhang, H. Deshmukh, and J. M. Patel. Data partitioning for in-memory systems: Myths, challenges, and opportunities. In CIDR, 2019."}],"event":{"name":"SIGMOD\/PODS '21: International Conference on Management of Data","location":"Virtual Event China","acronym":"SIGMOD\/PODS '21","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the 2021 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3448016.3452831","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3448016.3452831","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T21:28:05Z","timestamp":1750195685000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3448016.3452831"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021,6,9]]},"references-count":47,"alternative-id":["10.1145\/3448016.3452831","10.1145\/3448016"],"URL":"https:\/\/doi.org\/10.1145\/3448016.3452831","relation":{},"subject":[],"published":{"date-parts":[[2021,6,9]]},"assertion":[{"value":"2021-06-18","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}