{"id":"https://openalex.org/W2248883357","doi":"https://doi.org/10.5220/0004412100130022","title":"Are Multi-way Joins Actually Useful?","display_name":"Are Multi-way Joins Actually Useful?","publication_year":2013,"publication_date":"2013-01-01","ids":{"openalex":"https://openalex.org/W2248883357","doi":"https://doi.org/10.5220/0004412100130022","mag":"2248883357"},"language":"en","primary_location":{"id":"doi:10.5220/0004412100130022","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0004412100130022","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Conference on Enterprise Information Systems","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.5220/0004412100130022","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5060553062","display_name":"Michael Henderson","orcid":"https://orcid.org/0000-0003-3636-9232"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Michael Henderson","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5033389483","display_name":"Ramon Lawrence","orcid":"https://orcid.org/0000-0002-6779-4461"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ramon Lawrence","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2682,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.51259711,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"13","last_page":"22"},"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.9998000264167786,"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.9998000264167786,"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.9994000196456909,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/joins","display_name":"Joins","score":0.898816704750061},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7382404804229736},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.21733993291854858}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.898816704750061},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7382404804229736},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21733993291854858}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5220/0004412100130022","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0004412100130022","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Conference on Enterprise Information Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.702.7841","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.702.7841","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://people.ok.ubc.ca/rlawrenc/research/Papers/multiwayjoins.pdf","raw_type":"text"}],"best_oa_location":{"id":"doi:10.5220/0004412100130022","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0004412100130022","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th International Conference on Enterprise Information Systems","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1484772825","https://openalex.org/W1490731164","https://openalex.org/W1497748148","https://openalex.org/W1520750340","https://openalex.org/W1601880505","https://openalex.org/W1877188183","https://openalex.org/W1972693281","https://openalex.org/W2003515726","https://openalex.org/W2011078029","https://openalex.org/W2043934800","https://openalex.org/W2097880677","https://openalex.org/W2132244350","https://openalex.org/W2145812340","https://openalex.org/W2153180521","https://openalex.org/W2292514870"],"related_works":["https://openalex.org/W2158013543","https://openalex.org/W2073547112","https://openalex.org/W2462670247","https://openalex.org/W4230850137","https://openalex.org/W575918167","https://openalex.org/W2363930051","https://openalex.org/W2385485542","https://openalex.org/W2911362449","https://openalex.org/W1518140620","https://openalex.org/W1601817297"],"abstract_inverted_index":{"Abstract:":[0],"Multi-way":[1],"joins":[2,68,81,100],"improve":[3],"performance":[4],"by":[5,116],"avoiding":[6],"extra":[7],"I/Os":[8],"from":[9],"multiple":[10],"partitioning":[11],"steps.":[12],"There":[13],"are":[14,24,30,101,121],"several":[15,104],"multi-way":[16,34,47,67,80,99],"join":[17],"algorithms":[18,73],"proposed,":[19],"and":[20,42,49,52,63,82,84,111],"the":[21,40,76,117],"research":[22],"results":[23,96],"encouraging.":[25],"However,":[26],"commercial":[27],"database":[28,109],"systems":[29],"not":[31],"currently":[32],"using":[33],"joins.":[35],"Practical":[36],"issues":[37,123],"include":[38],"modifying":[39],"optimizer":[41,77],"execution":[43],"system":[44,110],"to":[45,78,128],"support":[46],"operators":[48],"ensuring":[50],"robust":[51,130],"reliable":[53],"performance.":[54,131],"The":[55],"contribution":[56],"of":[57,66],"this":[58],"work":[59],"is":[60],"an":[61],"implementation":[62,122],"experimental":[64],"evaluation":[65],"in":[69,106],"PostgreSQL.":[70],"We":[71],"provide":[72],"that":[74,88,98,124],"modify":[75],"cost":[79],"create":[83],"execute":[85],"query":[86],"plans":[87],"have":[89],"more":[90],"than":[91],"two":[92],"input":[93],"operators.":[94],"Experimental":[95],"show":[97],"beneficial":[102],"for":[103],"queries":[105],"a":[107],"production":[108],"can":[112],"be":[113,126],"effectively":[114],"exploited":[115],"optimizer,":[118],"however":[119],"there":[120],"must":[125],"resolved":[127],"guarantee":[129],"1":[132]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2014,"cited_by_count":1}],"updated_date":"2026-07-31T08:31:51.225901","created_date":"2025-10-10T00:00:00"}