{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,5]],"date-time":"2026-05-05T17:40:31Z","timestamp":1778002831245,"version":"3.51.4"},"reference-count":22,"publisher":"Springer Science and Business Media LLC","issue":"4","license":[{"start":{"date-parts":[[2018,5,23]],"date-time":"2018-05-23T00:00:00Z","timestamp":1527033600000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Distrib Parallel Databases"],"published-print":{"date-parts":[[2019,12]]},"DOI":"10.1007\/s10619-018-7226-4","type":"journal-article","created":{"date-parts":[[2018,5,23]],"date-time":"2018-05-23T05:14:23Z","timestamp":1527052463000},"page":"469-506","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":4,"title":["Main-memory foreign key joins on advanced processors: design and re-evaluations for OLAP workloads"],"prefix":"10.1007","volume":"37","author":[{"given":"Yansong","family":"Zhang","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Yu","family":"Zhang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xuan","family":"Zhou","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jiaheng","family":"Lu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2018,5,23]]},"reference":[{"key":"7226_CR1","doi-asserted-by":"publisher","unstructured":"Blanas, S., Li, Y., Patel, J.M.: Design and evaluation of main memory hash join algorithms for multi-core CPUs. In: Proceedings of SIGMOD Conference. ACM, New York, NY, pp. 37\u201348. https:\/\/doi.org\/10.1145\/1989323.1989328 (2011)","DOI":"10.1145\/1989323.1989328"},{"key":"7226_CR2","doi-asserted-by":"publisher","unstructured":"Balkesen, C., Teubner, J., Alonso, G., Ozsu, T.: Main-memory hash joins on multi-core cpus: tuning to the underlying hardware. In: Proceedings of ICDE Conference, pp. 362\u2013373, https:\/\/doi.org\/10.1109\/icde.2013.6544839 (2013)","DOI":"10.1109\/icde.2013.6544839"},{"issue":"12","key":"7226_CR3","doi-asserted-by":"publisher","first-page":"77","DOI":"10.1145\/1409360.1409380","volume":"51","author":"PA Boncz","year":"2008","unstructured":"Boncz, P.A., Kersten, M.L., Manegold, S.: Breaking the memory wall in MonetDB. Commun. ACM 51(12), 77\u201385 (2008). https:\/\/doi.org\/10.1145\/1409360.1409380","journal-title":"Commun. ACM"},{"key":"7226_CR4","doi-asserted-by":"crossref","unstructured":"Stefan, S., Xiao, C., Jens, D.: An experimental comparison of thirteen relational equi-joins in main memory. In: Proceedings of SIGMOD Conference, pp. 1961\u20131976 (2016)","DOI":"10.1145\/2882903.2882917"},{"issue":"4","key":"7226_CR5","doi-asserted-by":"publisher","first-page":"1061","DOI":"10.1109\/TKDE.2015.2499199","volume":"28","author":"Y Zhang","year":"2016","unstructured":"Zhang, Y., Zhou, X., Zhang, Y., Zhang, Y., Su, M., Wang, S.: Virtual denormalization via array index reference for main memory OLAP. IEEE Trans. Knowl. Data Eng. 28(4), 1061\u20131074 (2016)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"7226_CR6","doi-asserted-by":"crossref","unstructured":"Kaldewey, T., Lohman, G., Mueller, R., Volk, P.: GPU join processing revisited. In: Proceedings of DaMoN Conference, pp. 55\u201362 (2012)","DOI":"10.1145\/2236584.2236592"},{"issue":"10","key":"7226_CR7","first-page":"817","volume":"6","author":"Y Yuan","year":"2013","unstructured":"Yuan, Y., Lee, R., Zhang, X.: The Yin and Yang of processing data warehousing queries on GPU devices. PVLDB 6(10), 817\u2013828 (2013)","journal-title":"PVLDB"},{"issue":"10","key":"7226_CR8","doi-asserted-by":"publisher","first-page":"889","DOI":"10.14778\/2536206.2536216","volume":"6","author":"Jiong He","year":"2013","unstructured":"He, J., Lu, M., He, B.: Revisiting co-processing for hash joins on the coupled CPU-GPU architecture. In: Proceedings of VLDB Conference, vol. 6, no. 10, pp. 889\u2013900 (2013)","journal-title":"Proceedings of the VLDB Endowment"},{"issue":"6","key":"7226_CR9","first-page":"642","volume":"8","author":"S Jha","year":"2015","unstructured":"Jha, S., He, B., Lu, M., Cheng, X., Huynh, H.P.: Improving main memory hash joins on Intel Xeon Phi processors: an experimental approach. PVLDB 8(6), 642\u2013653 (2015)","journal-title":"PVLDB"},{"key":"7226_CR10","unstructured":"Halstead, R.J., Absalyamov, I., Najjar, W.A., Tsotras, V.J.: FPGA-based multithreading for in-memory hash joins. In: Proceedings of CIDR Conference (2015)"},{"issue":"2","key":"7226_CR11","doi-asserted-by":"publisher","first-page":"34","DOI":"10.1109\/MM.2016.25","volume":"36","author":"S Avinash","year":"2016","unstructured":"Avinash, S., Roger, G., Jes\u00fas, C., Ho-Seop, K., Krishna, V., Sundaram, C., Steven, H., Rajat, A., Yen-Chen, L.: Knights landing: second-generation Intel Xeon Phi Product. IEEE Micro 36(2), 34\u201346 (2016)","journal-title":"IEEE Micro"},{"issue":"2","key":"7226_CR12","doi-asserted-by":"publisher","first-page":"52","DOI":"10.1109\/MM.2017.38","volume":"37","author":"D Jack","year":"2017","unstructured":"Jack, D., Wen-Fu, K., Allen, K.L., Julius, M., Anirudha, R., Lihu, R., Efraim, R., Ahmad, Y., Adi, Y.: Inside 6th-generation Intel Core: new microarchitecture code-named Skylake. IEEE Micro 37(2), 52\u201362 (2017)","journal-title":"IEEE Micro"},{"issue":"4","key":"7226_CR13","doi-asserted-by":"publisher","first-page":"353","DOI":"10.14778\/2735496.2735499","volume":"8","author":"R Barber","year":"2015","unstructured":"Barber, R., Lohman, G.M., Pandis, I., et al.: Memory-efficient hash joins. Proc. VLDB Endow. 8(4), 353\u2013364 (2015)","journal-title":"Proc. VLDB Endow."},{"key":"7226_CR14","doi-asserted-by":"crossref","unstructured":"Sompolski, J., Zukowski, M., Boncz, P.A.: Vectorization vs. compilation in query execution. In: Proceedings of DaMoN Conference, pp. 33\u201340 (2011)","DOI":"10.1145\/1995441.1995446"},{"key":"7226_CR15","unstructured":"Boncz, P.A., Zukowski, M., Nes, N.: MonetDB\/X100: hyper-pipelining query execution. In: Proceedings of CIDR Conference, pp. 225\u2013237 (2005)"},{"key":"7226_CR16","doi-asserted-by":"publisher","unstructured":"Polychroniou, O., Raghavan, A., Ross, K.A.: Rethinking SIMD vectorization for in-memory databases. In: Proceedings of SIGMOD Conference, pp. 1493\u20131508, May. 2015, https:\/\/doi.org\/10.1145\/2723372.2747645 (2015)","DOI":"10.1145\/2723372.2747645"},{"issue":"3","key":"7226_CR17","first-page":"96","volume":"9","author":"S Richter","year":"2015","unstructured":"Richter, S., Alvarez, V., Dittrich, J.: A seven-dimensional analysis of hashing methods and its implications on query processing. PVLDB 9(3), 96\u2013107 (2015)","journal-title":"PVLDB"},{"key":"7226_CR18","doi-asserted-by":"publisher","unstructured":"Kemper, A., Neumann, T.: HyPer: a hybrid OLTP&OLAP main memory database system based on virtual memory snapshots. In: Proceedings of ICDE Conference, pp. 195\u2013206, https:\/\/doi.org\/10.1109\/icde.2011.5767867 (2011)","DOI":"10.1109\/icde.2011.5767867"},{"key":"7226_CR19","doi-asserted-by":"crossref","unstructured":"Sikka, V., F\u00e4rber, F., Lehner, W., Cha, S.K., Peh, T., Bornh\u00f6vd, C.: Efficient transaction processing in SAP HANA database: the end of a column store myth. In: Proceedings of SIGMOD Conference, pp. 731\u2013742 (2012)","DOI":"10.1145\/2213836.2213946"},{"issue":"2","key":"7226_CR20","doi-asserted-by":"publisher","first-page":"236","DOI":"10.1007\/s11704-011-9181-3","volume":"5","author":"Y Zhang","year":"2011","unstructured":"Zhang, Y., Wang, S., Lu, J.: Improving performance by creating a native join-index for OLAP. Front Comput Sci China 5(2): 236\u2013249 (2011)","journal-title":"Front Comput Sci China"},{"issue":"1","key":"7226_CR21","first-page":"85","volume":"7","author":"C Balkesen","year":"2013","unstructured":"Balkesen, C., Alonso, G., Teubner, J., \u00d6zsu, M.T.: Multi-core, main-memory joins: sort vs. hash revisited. PVLDB 7(1), 85\u201396 (2013)","journal-title":"PVLDB"},{"key":"7226_CR22","doi-asserted-by":"crossref","unstructured":"Abadi, D.J., Madden, S., Hachem, N.: Column-stores vs. row-stores: how different are they really? In: Proceedings of SIGMOD Conference, pp. 967\u2013980 (2008)","DOI":"10.1145\/1376616.1376712"}],"container-title":["Distributed and Parallel Databases"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10619-018-7226-4.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s10619-018-7226-4\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10619-018-7226-4.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,7,4]],"date-time":"2025-07-04T18:06:59Z","timestamp":1751652419000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s10619-018-7226-4"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018,5,23]]},"references-count":22,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2019,12]]}},"alternative-id":["7226"],"URL":"https:\/\/doi.org\/10.1007\/s10619-018-7226-4","relation":{},"ISSN":["0926-8782","1573-7578"],"issn-type":[{"value":"0926-8782","type":"print"},{"value":"1573-7578","type":"electronic"}],"subject":[],"published":{"date-parts":[[2018,5,23]]},"assertion":[{"value":"23 May 2018","order":1,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}