{"id":"https://openalex.org/W3065207484","doi":"https://doi.org/10.1002/ett.4084","title":"Utilizing the column imprints to accelerate no\u2010partitioning hash joins in large\u2010scale edge systems","display_name":"Utilizing the column imprints to accelerate no\u2010partitioning hash joins in large\u2010scale edge systems","publication_year":2020,"publication_date":"2020-08-17","ids":{"openalex":"https://openalex.org/W3065207484","doi":"https://doi.org/10.1002/ett.4084","mag":"3065207484"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1002/ett.4084","pdf_url":null,"source":{"id":"https://openalex.org/S4306425600","display_name":"Transactions on Emerging Telecommunications Technologies","issn_l":"2161-3915","issn":["2161-3915","2161-5748"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5100345881","display_name":"Yu Li","orcid":"https://orcid.org/0000-0003-0092-2462"},"institutions":[{"id":"https://openalex.org/I50760025","display_name":"Hangzhou Dianzi University","ror":"https://ror.org/0576gt767","country_code":"CN","type":"education","lineage":["https://openalex.org/I50760025"]},{"id":"https://openalex.org/I1327237609","display_name":"Ministry of Education of the People's Republic of China","ror":"https://ror.org/01mv9t934","country_code":"CN","type":"government","lineage":["https://openalex.org/I1327237609","https://openalex.org/I4210127390"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yu Li","raw_affiliation_strings":["Key Laboratory of Complex Systems Modeling and Simulation of Ministry of Education, Hangzhou, China","School of Computer, Hangzhou Dianzi University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"School of Computer, Hangzhou Dianzi University, Hangzhou, China","institution_ids":["https://openalex.org/I50760025"]},{"raw_affiliation_string":"Key Laboratory of Complex Systems Modeling and Simulation of Ministry of Education, Hangzhou, China","institution_ids":["https://openalex.org/I1327237609"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067642735","display_name":"Wenjian Xu","orcid":"https://orcid.org/0000-0001-8852-2601"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Wenjian Xu","raw_affiliation_strings":["Alibaba Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5067642735"],"corresponding_institution_ids":["https://openalex.org/I45928872"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.503359,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":60,"max":69},"biblio":{"volume":"32","issue":"6","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9983,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9983,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9978,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T11478","display_name":"Caching and Content Delivery","score":0.9976,"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":[],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8892677},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.7661838},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.6473771},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.583032},{"id":"https://openalex.org/C162307627","wikidata":"https://www.wikidata.org/wiki/Q204833","display_name":"Enhanced Data Rates for GSM Evolution","level":2,"score":0.53751487},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.44234407},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.39076164},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13215965},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.10577828},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.1029616},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.07577905},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.07539621},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.070368886},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1002/ett.4084","pdf_url":null,"source":{"id":"https://openalex.org/S4306425600","display_name":"Transactions on Emerging Telecommunications Technologies","issn_l":"2161-3915","issn":["2161-3915","2161-5748"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[{"funder":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China","award_id":"61802098"}],"datasets":[],"versions":[],"referenced_works_count":58,"referenced_works":["https://openalex.org/W1987238352","https://openalex.org/W1991223838","https://openalex.org/W2003515726","https://openalex.org/W2054046497","https://openalex.org/W2055774867","https://openalex.org/W2062666276","https://openalex.org/W2072541977","https://openalex.org/W2086977914","https://openalex.org/W2091459966","https://openalex.org/W2097880677","https://openalex.org/W2103670492","https://openalex.org/W2112735105","https://openalex.org/W2113831242","https://openalex.org/W2121699250","https://openalex.org/W2123686039","https://openalex.org/W2125529470","https://openalex.org/W2136083615","https://openalex.org/W2137077706","https://openalex.org/W2140453381","https://openalex.org/W2147076738","https://openalex.org/W2159726625","https://openalex.org/W2160404300","https://openalex.org/W2166955231","https://openalex.org/W2249320699","https://openalex.org/W2278783412","https://openalex.org/W2292693431","https://openalex.org/W2338665915","https://openalex.org/W2396727930","https://openalex.org/W2406955896","https://openalex.org/W2440477515","https://openalex.org/W2444247778","https://openalex.org/W2585469311","https://openalex.org/W2610608907","https://openalex.org/W2765206444","https://openalex.org/W2789660489","https://openalex.org/W2798422034","https://openalex.org/W2798926543","https://openalex.org/W2799019920","https://openalex.org/W2801524022","https://openalex.org/W2806745756","https://openalex.org/W2940791172","https://openalex.org/W2942497346","https://openalex.org/W2952468414","https://openalex.org/W2964122023","https://openalex.org/W2964607928","https://openalex.org/W2965898445","https://openalex.org/W2981165461","https://openalex.org/W2987695188","https://openalex.org/W2990303645","https://openalex.org/W2993119222","https://openalex.org/W2998083613","https://openalex.org/W2998373160","https://openalex.org/W3007133776","https://openalex.org/W3008684691","https://openalex.org/W3009703478","https://openalex.org/W3015615481","https://openalex.org/W3128750954","https://openalex.org/W3136655632"],"related_works":["https://openalex.org/W9089673","https://openalex.org/W6488013","https://openalex.org/W6348178","https://openalex.org/W5925040","https://openalex.org/W5157284","https://openalex.org/W4572039","https://openalex.org/W197484","https://openalex.org/W14300485","https://openalex.org/W13292397","https://openalex.org/W12527996"],"abstract_inverted_index":{"Abstract":[0],"With":[1],"the":[2,38,46,59,74,84,94,102,126,161,166,169,176,180,184,187,193,197,202,205,212,215,226,230],"increasing":[3,47],"number":[4],"of":[5,30,37,42,61,87,107,122,179,204,214],"edge":[6,10],"devices":[7],"in":[8,32,129,165,183,218],"large\u2010scale":[9],"systems,":[11],"more":[12,14],"and":[13,45,124,142,229],"data":[15,24,228,232],"are":[16,172],"collected":[17],"to":[18,80,111,151,156,195],"be":[19,81],"processed.":[20],"In":[21,53,146],"such":[22,54,200],"big":[23],"scenarios,":[25],"there":[26],"is":[27,57,77,110,190,208],"a":[28,70,153],"resurgence":[29],"interest":[31],"main\u2010memory":[33],"analytic":[34,51],"databases":[35],"because":[36],"large":[39,79],"RAM":[40,123],"capacity":[41],"modern":[43,103],"servers":[44],"demand":[48],"for":[49,115],"real\u2010time":[50],"platforms.":[52],"databases,":[55],"join":[56,134],"at":[58],"heart":[60],"almost":[62],"every":[63,120],"query":[64],"plan.":[65],"Join":[66],"also":[67],"stays":[68],"as":[69,192],"time\u2010consuming":[71],"operation":[72],"when":[73],"denormalization":[75],"overhead":[76],"too":[78],"applicable.":[82],"However,":[83],"current":[85],"implementations":[86],"these":[88],"operations":[89],"have":[90,138],"not":[91],"fully":[92],"leveraged":[93],"new":[95],"features":[96],"(eg,":[97],"SIMD,":[98],"multi\u2010core)":[99],"provided":[100],"by":[101,117],"hardware.":[104],"The":[105],"goal":[106],"this":[108,147],"article":[109],"design":[112],"efficient":[113],"algorithms":[114],"joins":[116,137,159],"judiciously":[118],"exploiting":[119],"bit":[121],"all":[125],"available":[127],"parallelisms":[128],"each":[130],"processing":[131],"unit.":[132],"For":[133],"operations,":[135],"hash":[136,158,170,181,206],"been":[139],"studied,":[140],"improved,":[141],"reexamined":[143],"over":[144,241],"decades.":[145],"article,":[148],"we":[149],"propose":[150],"utilize":[152],"secondary":[154,188],"index":[155,189],"improve":[157],"without":[160],"physical":[162],"partitioning.":[163],"Specifically,":[164],"build":[167],"phase,":[168,186],"values":[171],"scattered":[173],"evenly":[174],"into":[175],"logical":[177],"partitions":[178],"table;":[182],"probe":[185],"used":[191],"hints":[194],"re\u2010order":[196],"probing":[198,207],"sequence,":[199],"that":[201,234],"locality":[203],"increased.":[209],"We":[210],"benchmark":[211],"performance":[213,239],"proposed":[216],"techniques":[217],"our":[219,235],"column\u2010store":[220],"research":[221],"prototype.":[222],"Extensive":[223],"experiments":[224],"on":[225],"synthetic":[227],"real":[231],"show":[233],"methods":[236],"offer":[237],"significant":[238],"improvement":[240],"their":[242],"counterparts.":[243]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3065207484","counts_by_year":[{"year":2024,"cited_by_count":1}],"updated_date":"2024-12-31T09:09:55.135656","created_date":"2020-08-24"}