{"id":"https://openalex.org/W2795553818","doi":"https://doi.org/10.1109/tkde.2018.2822707","title":"A Hardware-Accelerated Solution for Hierarchical Index-Based Merge-Join","display_name":"A Hardware-Accelerated Solution for Hierarchical Index-Based Merge-Join","publication_year":2018,"publication_date":"2018-04-03","ids":{"openalex":"https://openalex.org/W2795553818","doi":"https://doi.org/10.1109/tkde.2018.2822707","mag":"2795553818"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2018.2822707","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2018.2822707","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5025167300","display_name":"Zimeng Zhou","orcid":"https://orcid.org/0000-0002-6683-3991"},"institutions":[{"id":"https://openalex.org/I168719708","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23","country_code":"HK","type":"education","lineage":["https://openalex.org/I168719708"]}],"countries":["HK"],"is_corresponding":true,"raw_author_name":"Zimeng Zhou","raw_affiliation_strings":["Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","institution_ids":["https://openalex.org/I168719708"]},{"raw_affiliation_string":"Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong","institution_ids":["https://openalex.org/I168719708"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050042433","display_name":"Chenyun Yu","orcid":"https://orcid.org/0000-0001-9774-1590"},"institutions":[{"id":"https://openalex.org/I168719708","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23","country_code":"HK","type":"education","lineage":["https://openalex.org/I168719708"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Chenyun Yu","raw_affiliation_strings":["Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","institution_ids":["https://openalex.org/I168719708"]},{"raw_affiliation_string":"Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong","institution_ids":["https://openalex.org/I168719708"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071030042","display_name":"Sarana Nutanong","orcid":"https://orcid.org/0000-0003-1068-850X"},"institutions":[{"id":"https://openalex.org/I168719708","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23","country_code":"HK","type":"education","lineage":["https://openalex.org/I168719708"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Sarana Nutanong","raw_affiliation_strings":["Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","institution_ids":["https://openalex.org/I168719708"]},{"raw_affiliation_string":"Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong","institution_ids":["https://openalex.org/I168719708"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027306735","display_name":"Yufei Cui","orcid":"https://orcid.org/0000-0002-9663-0079"},"institutions":[{"id":"https://openalex.org/I168719708","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23","country_code":"HK","type":"education","lineage":["https://openalex.org/I168719708"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Yufei Cui","raw_affiliation_strings":["Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","institution_ids":["https://openalex.org/I168719708"]},{"raw_affiliation_string":"Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong","institution_ids":["https://openalex.org/I168719708"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025857856","display_name":"Chenchen Fu","orcid":"https://orcid.org/0000-0002-6724-9594"},"institutions":[{"id":"https://openalex.org/I168719708","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23","country_code":"HK","type":"education","lineage":["https://openalex.org/I168719708"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Chenchen Fu","raw_affiliation_strings":["Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","institution_ids":["https://openalex.org/I168719708"]},{"raw_affiliation_string":"Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong","institution_ids":["https://openalex.org/I168719708"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101441768","display_name":"Chun Jason Xue","orcid":"https://orcid.org/0000-0002-6431-9868"},"institutions":[{"id":"https://openalex.org/I168719708","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23","country_code":"HK","type":"education","lineage":["https://openalex.org/I168719708"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Chun Jason Xue","raw_affiliation_strings":["Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, City University of Hong Kong, Kowloon Tong, Hong Kong","institution_ids":["https://openalex.org/I168719708"]},{"raw_affiliation_string":"Department of Computer Science City University of Hong Kong Kowloon Tong Hong Kong","institution_ids":["https://openalex.org/I168719708"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5025167300"],"corresponding_institution_ids":["https://openalex.org/I168719708"],"apc_list":null,"apc_paid":null,"fwci":1.4704,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.83745852,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"31","issue":"1","first_page":"91","last_page":"104"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8524994850158691},{"id":"https://openalex.org/keywords/merge","display_name":"Merge (version control)","score":0.6522054672241211},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.6138414144515991},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.6067355871200562},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5322574973106384},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.5263432264328003},{"id":"https://openalex.org/keywords/sort","display_name":"sort","score":0.49727776646614075},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.4480566680431366},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.40502074360847473},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.35942232608795166},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3203246593475342},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.2986176013946533},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1475091278553009},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08679470419883728}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8524994850158691},{"id":"https://openalex.org/C197129107","wikidata":"https://www.wikidata.org/wiki/Q1921621","display_name":"Merge (version control)","level":2,"score":0.6522054672241211},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6138414144515991},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.6067355871200562},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5322574973106384},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.5263432264328003},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.49727776646614075},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.4480566680431366},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40502074360847473},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35942232608795166},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3203246593475342},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.2986176013946533},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1475091278553009},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08679470419883728},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2018.2822707","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2018.2822707","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1485418712","display_name":null,"funder_award_id":"7004675","funder_id":"https://openalex.org/F4320309893","funder_display_name":"City University of Hong Kong"},{"id":"https://openalex.org/G4182905934","display_name":null,"funder_award_id":"7004421","funder_id":"https://openalex.org/F4320309893","funder_display_name":"City University of Hong Kong"},{"id":"https://openalex.org/G8624155259","display_name":null,"funder_award_id":"7004891","funder_id":"https://openalex.org/F4320309893","funder_display_name":"City University of Hong Kong"}],"funders":[{"id":"https://openalex.org/F4320309893","display_name":"City University of Hong Kong","ror":"https://ror.org/03q8dnn23"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":39,"referenced_works":["https://openalex.org/W1578512165","https://openalex.org/W1659263304","https://openalex.org/W1852059679","https://openalex.org/W1990947147","https://openalex.org/W1998545184","https://openalex.org/W2001040824","https://openalex.org/W2003515726","https://openalex.org/W2043099794","https://openalex.org/W2047210602","https://openalex.org/W2058178853","https://openalex.org/W2058903936","https://openalex.org/W2059681118","https://openalex.org/W2059966434","https://openalex.org/W2082695854","https://openalex.org/W2098730617","https://openalex.org/W2108783070","https://openalex.org/W2112479717","https://openalex.org/W2114965603","https://openalex.org/W2115500858","https://openalex.org/W2120335261","https://openalex.org/W2125529470","https://openalex.org/W2128605322","https://openalex.org/W2130130225","https://openalex.org/W2143909327","https://openalex.org/W2153485419","https://openalex.org/W2158347038","https://openalex.org/W2166955231","https://openalex.org/W2194597860","https://openalex.org/W2249471622","https://openalex.org/W2286264920","https://openalex.org/W2406955896","https://openalex.org/W2508516675","https://openalex.org/W2526538406","https://openalex.org/W2547319955","https://openalex.org/W2623697208","https://openalex.org/W6638950451","https://openalex.org/W6647986034","https://openalex.org/W6664827037","https://openalex.org/W6687566308"],"related_works":["https://openalex.org/W2381211091","https://openalex.org/W2091359263","https://openalex.org/W2067184662","https://openalex.org/W2469706965","https://openalex.org/W4234452035","https://openalex.org/W2511848805","https://openalex.org/W2061292114","https://openalex.org/W1589496614","https://openalex.org/W1989231289","https://openalex.org/W3033055359"],"abstract_inverted_index":{"Hardware":[0],"acceleration":[1],"through":[2],"field":[3],"programmable":[4],"gate":[5],"arrays":[6],"(FPGAs)":[7],"has":[8],"recently":[9],"become":[10],"a":[11,60,130,138,147],"technique":[12],"of":[13,24,67,80,96,111,141,150],"growing":[14],"interest":[15],"for":[16,143],"many":[17],"data-intensive":[18],"applications.":[19],"Join":[20],"query":[21,29,53,105],"is":[22,122],"one":[23],"the":[25,38,65,88,125,135],"most":[26],"fundamental":[27],"database":[28,34],"types":[30],"useful":[31],"in":[32,49,87,91,100,129],"relational":[33],"management":[35],"systems.":[36],"However,":[37],"available":[39],"solutions":[40],"so":[41],"far":[42],"have":[43],"been":[44],"beset":[45],"by":[46],"higher":[47],"costs":[48],"comparison":[50],"to":[51,63,83,93,102,124],"other":[52],"types.":[54],"In":[55],"this":[56],"paper,":[57],"we":[58],"develop":[59],"novel":[61],"solution":[62,77,89,108,121],"accelerate":[64],"processing":[66,110],"sort-merge":[68],"join":[69,114,144],"queries":[70,145],"with":[71,146],"low":[72,131],"match":[73,132,148],"rates.":[74],"Specifically,":[75],"our":[76,107,120],"makes":[78],"use":[79],"hierarchical":[81],"indexes":[82],"identify":[84],"result-yielding":[85],"regions":[86],"space":[90],"order":[92],"take":[94],"advantage":[95],"result":[97],"sparseness.":[98],"Further,":[99],"addition":[101],"one-dimensional":[103],"equi-join":[104],"processing,":[106],"supports":[109],"multidimensional":[112],"similarity":[113],"queries.":[115],"Experimental":[116],"results":[117],"show":[118],"that":[119],"superior":[123],"best":[126],"existing":[127],"method":[128,136],"rate":[133,149],"setting;":[134],"achieves":[137],"speedup":[139],"factor":[140],"4.8":[142],"5":[151],"percent.":[152]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}