{"id":"https://openalex.org/W2026344425","doi":"https://doi.org/10.1145/1007568.1007643","title":"Canonical abstraction for outerjoin optimization","display_name":"Canonical abstraction for outerjoin optimization","publication_year":2004,"publication_date":"2004-06-13","ids":{"openalex":"https://openalex.org/W2026344425","doi":"https://doi.org/10.1145/1007568.1007643","mag":"2026344425"},"language":"en","primary_location":{"id":"doi:10.1145/1007568.1007643","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007643","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 ACM SIGMOD international conference on Management of data","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/A5009094344","display_name":"Jun Rao","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]},{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Jun Rao","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083725187","display_name":"Hamid Pirahesh","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hamid Pirahesh","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5012414288","display_name":"Calisto Zuzarte","orcid":"https://orcid.org/0009-0006-1440-6775"},"institutions":[{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Calisto Zuzarte","raw_affiliation_strings":["IBM Toronto","IBM/Toronto"],"affiliations":[{"raw_affiliation_string":"IBM Toronto","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM/Toronto","institution_ids":["https://openalex.org/I4210113654"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5009094344"],"corresponding_institution_ids":["https://openalex.org/I1341412227","https://openalex.org/I4210085935"],"apc_list":null,"apc_paid":null,"fwci":1.3905,"has_fulltext":false,"cited_by_count":36,"citation_normalized_percentile":{"value":0.8479473,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"671","last_page":"682"},"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.9997000098228455,"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.9997000098228455,"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.9980999827384949,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9905999898910522,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7035890221595764},{"id":"https://openalex.org/keywords/abstraction","display_name":"Abstraction","score":0.6359786987304688},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5110677480697632},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.37009334564208984}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7035890221595764},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.6359786987304688},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5110677480697632},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.37009334564208984},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1007568.1007643","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007643","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4399999976158142,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W144096106","https://openalex.org/W976993123","https://openalex.org/W1484962256","https://openalex.org/W1543070288","https://openalex.org/W1543773280","https://openalex.org/W1578954050","https://openalex.org/W1583189939","https://openalex.org/W1592403016","https://openalex.org/W1593822674","https://openalex.org/W1598005293","https://openalex.org/W1604668037","https://openalex.org/W1835905248","https://openalex.org/W1844857636","https://openalex.org/W1875283749","https://openalex.org/W1882909919","https://openalex.org/W1992810975","https://openalex.org/W2008116177","https://openalex.org/W2013334450","https://openalex.org/W2049578111","https://openalex.org/W2072191579","https://openalex.org/W2108940005","https://openalex.org/W2122789628","https://openalex.org/W2127872176","https://openalex.org/W2136195851","https://openalex.org/W2145037882","https://openalex.org/W2153329411","https://openalex.org/W2156859522","https://openalex.org/W2162621793","https://openalex.org/W2171504682","https://openalex.org/W2240264416","https://openalex.org/W2253899864","https://openalex.org/W2258116623","https://openalex.org/W4244424643"],"related_works":["https://openalex.org/W2068700777","https://openalex.org/W2166247150","https://openalex.org/W4243252198","https://openalex.org/W3216885170","https://openalex.org/W2118300983","https://openalex.org/W2112962394","https://openalex.org/W3137189469","https://openalex.org/W4235530921","https://openalex.org/W2104078272","https://openalex.org/W3160136729"],"abstract_inverted_index":{"Outerjoins":[0],"are":[1,8,211],"an":[2,225,238,245,252],"important":[3],"class":[4],"of":[5,14,47,54,64,78,81,88,153,156,197,255,278],"joins":[6],"and":[7,40,158,178,193,200,233],"widely":[9],"used":[10],"in":[11,95,244,264],"various":[12],"kinds":[13],"applications.":[15],"It":[16],"is":[17,57,102],"challenging":[18],"to":[19,110,145,207,241],"optimize":[20],"queries":[21,56,125],"that":[22,43,63,210,218,227,236,270],"contain":[23],"outerjoins":[24,26],"because":[25,105],"do":[27],"not":[28,59,127],"always":[29,71,135],"commute":[30],"with":[31],"inner":[32,65,67,157,183],"joins.":[33],"Previous":[34],"work":[35],"has":[36,126],"studied":[37],"this":[38],"problem":[39],"provided":[41],"techniques":[42,134],"allow":[44],"certain":[45,137],"reordering":[46],"the":[48,52,96,108,163,182,195,256,261,276],"join":[49,68,97,113,138,184,191],"sequences.":[50],"However,":[51],"optimization":[53],"outerjoin":[55,124,187,279],"still":[58],"as":[60,62,75],"powerful":[61,104],"joins.An":[66],"query":[69,151],"can":[70,143,273],"be":[72,220],"canonically":[73],"represented":[74],"a":[76,86,93,120,131,146,150,154,167,230,234],"sequence":[77,87,114,155],"Cartesian":[79,175],"products":[80],"all":[82,190],"relations,":[83],"followed":[84],"by":[85],"selection":[89],"operations,":[90],"each":[91],"applying":[92],"conjunct":[94],"predicates.":[98,203],"This":[99,204],"canonical":[100,121,168,231],"abstraction":[101,122,169,188],"very":[103,212],"it":[106],"enables":[107],"optimizer":[109,240],"use":[111],"any":[112],"for":[115,123,162,214],"plan":[116],"generation.":[117],"Unfortunately,":[118],"such":[119,229],"been":[128],"developed.":[129],"As":[130],"result,":[132],"existing":[133],"exclude":[136],"sequences":[139],"from":[140],"planning,":[141],"which":[142],"lead":[144],"severe":[147],"performance":[148,215,277],"penalty.Given":[149],"consisting":[152],"outer":[159,174],"joins,":[160],"we,":[161],"first":[164],"time,":[165],"present":[166,224],"based":[170],"on":[171],"three":[172],"operations:":[173],"products,":[176],"nullification,":[177],"best":[179,257],"match.":[180],"Like":[181],"abstraction,":[185,232],"our":[186,271],"permits":[189],"sequences,":[192],"preserves":[194],"property":[196],"both":[198],"commutativity":[199],"transitivity":[201],"among":[202],"allows":[205],"us":[206],"generate":[208,242],"plans":[209,243],"desirable":[213],"reasons":[216],"but":[217],"couldn't":[219],"done":[221],"before.":[222],"We":[223,249],"algorithm":[226],"produces":[228],"method":[235],"extends":[237],"inner-join":[239],"expanded":[246],"search":[247],"space.":[248],"also":[250],"describe":[251],"efficient":[253],"implementation":[254],"match":[258],"operation":[259],"using":[260],"OLAP":[262],"functionalities":[263],"SQL:1999.":[265],"Our":[266],"experimental":[267],"results":[268],"show":[269],"technique":[272],"significantly":[274],"improve":[275],"queries.":[280]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}