{"id":"https://openalex.org/W2153558284","doi":"https://doi.org/10.1109/ispan.2002.1004259","title":"An algorithm for resolving the join component selection problem in parallel join optimization","display_name":"An algorithm for resolving the join component selection problem in parallel join optimization","publication_year":2003,"publication_date":"2003-06-25","ids":{"openalex":"https://openalex.org/W2153558284","doi":"https://doi.org/10.1109/ispan.2002.1004259","mag":"2153558284"},"language":"en","primary_location":{"id":"doi:10.1109/ispan.2002.1004259","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ispan.2002.1004259","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings International Symposium on Parallel Architectures, Algorithms and Networks. I-SPAN'02","raw_type":"proceedings-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/A5111262778","display_name":"James Esquivel","orcid":null},"institutions":[{"id":"https://openalex.org/I79905719","display_name":"De La Salle University \u2013 Dasmari\u00f1as","ror":"https://ror.org/03a39dd69","country_code":"PH","type":"education","lineage":["https://openalex.org/I79905719"]}],"countries":["PH"],"is_corresponding":false,"raw_author_name":"J. Esquivel","raw_affiliation_strings":["Computer Studies Department, De La Salle University Dasmarinas, Cavite, Philippines"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer Studies Department, De La Salle University Dasmarinas, Cavite, Philippines","institution_ids":["https://openalex.org/I79905719"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003044727","display_name":"Patrick Matthew J. Chan","orcid":null},"institutions":[{"id":"https://openalex.org/I5996616","display_name":"De La Salle University","ror":"https://ror.org/04xftk194","country_code":"PH","type":"education","lineage":["https://openalex.org/I5996616"]}],"countries":["PH"],"is_corresponding":false,"raw_author_name":"P. Chan","raw_affiliation_strings":["College of Computer Studies, De La Salle University-Professional Schools, Inc., Manila, Philippines"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer Studies, De La Salle University-Professional Schools, Inc., Manila, Philippines","institution_ids":["https://openalex.org/I5996616"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.24688914,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"45","last_page":"50"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.9983999729156494,"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.9368664026260376},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.9147599339485168},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8214340209960938},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6935917139053345},{"id":"https://openalex.org/keywords/component","display_name":"Component (thermodynamics)","score":0.67335444688797},{"id":"https://openalex.org/keywords/hash-join","display_name":"Hash join","score":0.531604528427124},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3734109103679657},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.37224310636520386},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.14146941900253296},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.12372520565986633},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08855026960372925}],"concepts":[{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.9368664026260376},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9147599339485168},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8214340209960938},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6935917139053345},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.67335444688797},{"id":"https://openalex.org/C188805328","wikidata":"https://www.wikidata.org/wiki/Q4060691","display_name":"Hash join","level":3,"score":0.531604528427124},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3734109103679657},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.37224310636520386},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14146941900253296},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.12372520565986633},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08855026960372925},{"id":"https://openalex.org/C97355855","wikidata":"https://www.wikidata.org/wiki/Q11473","display_name":"Thermodynamics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"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":1,"locations":[{"id":"doi:10.1109/ispan.2002.1004259","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ispan.2002.1004259","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings International Symposium on Parallel Architectures, Algorithms and Networks. I-SPAN'02","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.8500000238418579,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W187405143","https://openalex.org/W1502629466","https://openalex.org/W1551935098","https://openalex.org/W1748095660","https://openalex.org/W2023467128","https://openalex.org/W2100037261","https://openalex.org/W2110605895","https://openalex.org/W2124170481","https://openalex.org/W2151817724","https://openalex.org/W6633167738","https://openalex.org/W6682553477"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W650102067","https://openalex.org/W2740404111","https://openalex.org/W1550806730","https://openalex.org/W1496672428","https://openalex.org/W2589740103","https://openalex.org/W2397450670","https://openalex.org/W1966967794","https://openalex.org/W3086237447"],"abstract_inverted_index":{"The":[0,25],"use":[1],"of":[2,22,43,70,76],"a":[3,12,32,40],"page-level":[4],"join":[5,9,23,56,92,114],"index":[6],"in":[7,19,54],"parallel":[8,113],"optimization":[10],"requires":[11],"proper":[13],"sequence":[14],"for":[15],"accessing":[16],"data":[17],"pages":[18],"the":[20,55,68,79,91,112,122],"form":[21],"components.":[24],"current":[26],"approach":[27],"to":[28,48],"this":[29,99,101],"method":[30],"involves":[31],"strategy":[33],"that":[34,108],"first":[35],"retrieves":[36],"those":[37],"components":[38],"with":[39,62],"high":[41],"number":[42],"page":[44],"joins":[45],"so":[46],"as":[47],"keep":[49],"all":[50],"processors":[51],"busy":[52],"early":[53],"execution.":[57,115],"However,":[58],"problems":[59],"regarding":[60],"conflicts":[61,90],"other":[63],"valid":[64],"reading":[65],"strategies":[66,107],"and":[67],"choice":[69],"an":[71,119],"appropriate":[72,104],"component":[73,93,105],"whenever":[74],"several":[75],"them":[77],"satisfy":[78],"selection":[80,94],"criterion":[81],"have":[82],"not":[83],"been":[84],"specifically":[85],"addressed":[86],"We":[87],"call":[88],"such":[89],"(JCS)":[95],"problem.":[96],"To":[97],"resolve":[98],"problem,":[100],"paper":[102],"proposes":[103],"retrieval":[106],"will":[109],"further":[110],"optimize":[111],"Simulation":[116],"results":[117],"demonstrate":[118],"improvement":[120],"over":[121],"existing":[123],"one.":[124]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}