{"id":"https://openalex.org/W2127872176","doi":"https://doi.org/10.1145/93597.98738","title":"Query graphs, implementing trees, and freely-reorderable outerjoins","display_name":"Query graphs, implementing trees, and freely-reorderable outerjoins","publication_year":1990,"publication_date":"1990-05-01","ids":{"openalex":"https://openalex.org/W2127872176","doi":"https://doi.org/10.1145/93597.98738","mag":"2127872176"},"language":"en","primary_location":{"is_oa":true,"landing_page_url":"https://doi.org/10.1145/93597.98738","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/93597.98738","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true},"type":"article","type_crossref":"proceedings-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/93597.98738","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5032376111","display_name":"Arnon Rosenthal","orcid":"https://orcid.org/0000-0001-8421-8004"},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Arnon Rosenthal","raw_affiliation_strings":["ETH Zurich and Xerox AIT#TAB#"],"affiliations":[{"raw_affiliation_string":"ETH Zurich and Xerox AIT#TAB#","institution_ids":["https://openalex.org/I35440088"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5016107143","display_name":"C\u00e9sar Galindo-Legaria","orcid":"https://orcid.org/0009-0006-5344-9495"},"institutions":[{"id":"https://openalex.org/I136199984","display_name":"Harvard University","ror":"https://ror.org/03vek6s52","country_code":"US","type":"education","lineage":["https://openalex.org/I136199984"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Cesar Galindo-Legaria","raw_affiliation_strings":["Alken Computation Laboratory, Harvard University"],"affiliations":[{"raw_affiliation_string":"Alken Computation Laboratory, Harvard University","institution_ids":["https://openalex.org/I136199984"]}]}],"institution_assertions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.119,"has_fulltext":true,"fulltext_origin":"pdf","cited_by_count":43,"citation_normalized_percentile":{"value":0.890492,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":92,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"291","last_page":"299"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9996,"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.9996,"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.9994,"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.9861,"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"}}],"keywords":[],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7211813}],"mesh":[],"locations_count":1,"locations":[{"is_oa":true,"landing_page_url":"https://doi.org/10.1145/93597.98738","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/93597.98738","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true}],"best_oa_location":{"is_oa":true,"landing_page_url":"https://doi.org/10.1145/93597.98738","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/93597.98738","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true},"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":7,"referenced_works":["https://openalex.org/W1481270797","https://openalex.org/W1550420318","https://openalex.org/W1721126460","https://openalex.org/W1825341804","https://openalex.org/W2002171029","https://openalex.org/W2013334450","https://openalex.org/W2147869465"],"related_works":["https://openalex.org/W4396701345","https://openalex.org/W4396696052","https://openalex.org/W4391913857","https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2376932109","https://openalex.org/W2358668433","https://openalex.org/W2001405890"],"abstract_inverted_index":{"We":[0],"determine":[1],"when":[2],"a":[3,11,36,56,71,79],"join/outerjoin":[4,38,57],"query":[5,12,39,58,64],"can":[6],"be":[7],"expressed":[8],"unambiguously":[9],"as":[10],"graph,":[13,40],"without":[14],"an":[15],"explicit":[16],"specification":[17],"of":[18,21,31,45],"the":[19,29,43,48,63,83],"order":[20],"evaluation.":[22],"To":[23],"do":[24],"so,":[25],"we":[26],"first":[27],"characterize":[28],"set":[30],"expression":[32],"trees":[33],"that":[34,55,76],"implement":[35],"given":[37],"and":[41],"investigate":[42],"existence":[44],"transformations":[46],"among":[47],"various":[49],"trees.":[50],"Our":[51],"main":[52],"theorem":[53],"is":[54,59],"freely":[60],"reorderable":[61],"if":[62],"graph":[65,80],"derived":[66],"from":[67],"it":[68],"falls":[69],"within":[70],"particular":[72],"class,":[73],"every":[74],"tree":[75],"\"implements\"":[77],"such":[78],"evaluates":[81],"to":[82],"same":[84],"result.":[85]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2127872176","counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":3}],"updated_date":"2025-01-15T22:00:42.947954","created_date":"2016-06-24"}