{"id":"https://openalex.org/W2160149381","doi":"https://doi.org/10.1109/hipc.1998.738010","title":"Skew-insensitive parallel algorithms for relational join","display_name":"Skew-insensitive parallel algorithms for relational join","publication_year":2002,"publication_date":"2002-11-27","ids":{"openalex":"https://openalex.org/W2160149381","doi":"https://doi.org/10.1109/hipc.1998.738010","mag":"2160149381"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/hipc.1998.738010","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://surface.syr.edu/cgi/viewcontent.cgi?article=1049&context=lcsmith_other","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5002766037","display_name":"Khaled Alsabti","orcid":null},"institutions":[{"id":"https://openalex.org/I70983195","display_name":"Syracuse University","ror":"https://ror.org/025r5qe02","country_code":"US","type":"funder","lineage":["https://openalex.org/I70983195"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"K. Alsabti","raw_affiliation_strings":["Syracuse University, USA"],"affiliations":[{"raw_affiliation_string":"Syracuse University, USA","institution_ids":["https://openalex.org/I70983195"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077570468","display_name":"Sanjay Ranka","orcid":"https://orcid.org/0000-0003-4886-1988"},"institutions":[{"id":"https://openalex.org/I33213144","display_name":"University of Florida","ror":"https://ror.org/02y3ad647","country_code":"US","type":"funder","lineage":["https://openalex.org/I33213144"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"S. Ranka","raw_affiliation_strings":["University of Florida, USA"],"affiliations":[{"raw_affiliation_string":"University of Florida, USA","institution_ids":["https://openalex.org/I33213144"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.27,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":5,"citation_normalized_percentile":{"value":0.605884,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":73,"max":75},"biblio":{"volume":null,"issue":null,"first_page":"367","last_page":"374"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9994,"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"}},"topics":[{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9994,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9992,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9987,"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/join","display_name":"Join (topology)","score":0.8506404},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.8160987},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.7172067},{"id":"https://openalex.org/keywords/parallel-database","display_name":"Parallel database","score":0.47102958}],"concepts":[{"id":"https://openalex.org/C43711488","wikidata":"https://www.wikidata.org/wiki/Q7534783","display_name":"Skew","level":2,"score":0.8792583},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.8506404},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8366263},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.8160987},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.7172067},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.71529716},{"id":"https://openalex.org/C34736171","wikidata":"https://www.wikidata.org/wiki/Q918333","display_name":"Preprocessor","level":2,"score":0.5569143},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.55349},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.54787016},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5362951},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5258632},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.50547576},{"id":"https://openalex.org/C111696304","wikidata":"https://www.wikidata.org/wiki/Q2303697","display_name":"Sorting","level":2,"score":0.5033745},{"id":"https://openalex.org/C2777541480","wikidata":"https://www.wikidata.org/wiki/Q2051600","display_name":"Parallel database","level":2,"score":0.47102958},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.44865084},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.43008214},{"id":"https://openalex.org/C120373497","wikidata":"https://www.wikidata.org/wiki/Q1087987","display_name":"Parallel algorithm","level":2,"score":0.4121528},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3917011},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.24103743},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.19866228},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.096726835},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08685136},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.07445222},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/hipc.1998.738010","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},{"is_oa":true,"landing_page_url":"https://surface.syr.edu/lcsmith_other/50","pdf_url":"https://surface.syr.edu/cgi/viewcontent.cgi?article=1049&context=lcsmith_other","source":{"id":"https://openalex.org/S4306401700","display_name":"Syracuse University Libraries (Syracuse University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":false,"host_organization":"https://openalex.org/I70983195","host_organization_name":"Syracuse University","host_organization_lineage":["https://openalex.org/I70983195"],"host_organization_lineage_names":["Syracuse University"],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false}],"best_oa_location":{"is_oa":true,"landing_page_url":"https://surface.syr.edu/lcsmith_other/50","pdf_url":"https://surface.syr.edu/cgi/viewcontent.cgi?article=1049&context=lcsmith_other","source":{"id":"https://openalex.org/S4306401700","display_name":"Syracuse University Libraries (Syracuse University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":false,"host_organization":"https://openalex.org/I70983195","host_organization_name":"Syracuse University","host_organization_lineage":["https://openalex.org/I70983195"],"host_organization_lineage_names":["Syracuse University"],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false},"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":26,"referenced_works":["https://openalex.org/W1480588120","https://openalex.org/W1509342228","https://openalex.org/W154166887","https://openalex.org/W1559533846","https://openalex.org/W1585614323","https://openalex.org/W1588885340","https://openalex.org/W1597532222","https://openalex.org/W1615746410","https://openalex.org/W1971869874","https://openalex.org/W1997198602","https://openalex.org/W2000025733","https://openalex.org/W2023520683","https://openalex.org/W2078528123","https://openalex.org/W2079656678","https://openalex.org/W2085204501","https://openalex.org/W2097720418","https://openalex.org/W2100981089","https://openalex.org/W2106359405","https://openalex.org/W2123565672","https://openalex.org/W2131724164","https://openalex.org/W2133078257","https://openalex.org/W2138531328","https://openalex.org/W2146368765","https://openalex.org/W2157603986","https://openalex.org/W2176960828","https://openalex.org/W72853727"],"related_works":["https://openalex.org/W4212828571","https://openalex.org/W2999362268","https://openalex.org/W2572223517","https://openalex.org/W2160149381","https://openalex.org/W2140894225","https://openalex.org/W2128582123","https://openalex.org/W2126624503","https://openalex.org/W2125826941","https://openalex.org/W1966967794","https://openalex.org/W1530899458"],"abstract_inverted_index":{"Join":[0],"is":[1,15,53,58],"the":[2,19,22,56,71,74],"most":[3],"important":[4],"and":[5,55],"expensive":[6],"operation":[7,14],"in":[8,42],"relational":[9],"databases.":[10],"The":[11,50],"parallel":[12,32],"join":[13,33],"very":[16],"sensitive":[17],"to":[18,68,80],"presence":[20,43],"of":[21,44,47,61],"data":[23,48],"skew.":[24,49],"In":[25],"this":[26],"paper":[27],"we":[28],"present":[29],"two":[30],"new":[31],"algorithms":[34,63,77],"for":[35],"coarse":[36],"grained":[37],"machines":[38],"which":[39],"work":[40,72],"optimally":[41],"arbitrary":[45],"amount":[46],"first":[51],"algorithm":[52],"sort-based":[54],"second":[57],"hash-based.":[59],"Both":[60],"these":[62],"employ":[64],"a":[65],"preprocessing":[66],"phase":[67],"equally":[69],"partition":[70],"among":[73],"processors.":[75],"These":[76],"are":[78],"shown":[79],"be":[81],"theoretically":[82],"as":[83,85],"well":[84],"practically":[86],"scalable.":[87]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2160149381","counts_by_year":[{"year":2012,"cited_by_count":2}],"updated_date":"2025-03-19T07:32:44.303938","created_date":"2016-06-24"}