{"id":"https://openalex.org/W2078109763","doi":"https://doi.org/10.1137/0210030","title":"Inferring a Tree from Lowest Common Ancestors with an Application to the Optimization of Relational Expressions","display_name":"Inferring a Tree from Lowest Common Ancestors with an Application to the Optimization of Relational Expressions","publication_year":1981,"publication_date":"1981-08-01","ids":{"openalex":"https://openalex.org/W2078109763","doi":"https://doi.org/10.1137/0210030","mag":"2078109763"},"language":"en","primary_location":{"id":"doi:10.1137/0210030","is_oa":false,"landing_page_url":"https://doi.org/10.1137/0210030","pdf_url":null,"source":{"id":"https://openalex.org/S153560523","display_name":"SIAM Journal on Computing","issn_l":"0097-5397","issn":["0097-5397","1095-7111"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320508","host_organization_name":"Society for Industrial and Applied Mathematics","host_organization_lineage":["https://openalex.org/P4310320508"],"host_organization_lineage_names":["Society for Industrial and Applied Mathematics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SIAM Journal on Computing","raw_type":"journal-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/A5032983362","display_name":"A. V. Aho","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"A. V. Aho","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014143171","display_name":"Yehoshua Sagiv","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Y. Sagiv","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028962222","display_name":"Thomas G. Szymanski","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"T. G. Szymanski","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5089065417","display_name":"Jeffrey D. Ullman","orcid":"https://orcid.org/0000-0002-1847-3426"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"J. D. Ullman","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5032983362"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.4258,"has_fulltext":false,"cited_by_count":412,"citation_normalized_percentile":{"value":0.89909351,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":"10","issue":"3","first_page":"405","last_page":"421"},"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.9994000196456909,"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.9994000196456909,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9962999820709229,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9950000047683716,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6286156177520752},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.6216115951538086},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5988131165504456},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.5521478056907654},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5370757579803467},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.5260396003723145},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.5239639282226562},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.4971008598804474},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4047185778617859},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.3898726999759674},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.36582762002944946},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.29929158091545105},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.13730740547180176},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08198392391204834}],"concepts":[{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6286156177520752},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.6216115951538086},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5988131165504456},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.5521478056907654},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5370757579803467},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.5260396003723145},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.5239639282226562},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.4971008598804474},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4047185778617859},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.3898726999759674},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.36582762002944946},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.29929158091545105},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.13730740547180176},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08198392391204834},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1137/0210030","is_oa":false,"landing_page_url":"https://doi.org/10.1137/0210030","pdf_url":null,"source":{"id":"https://openalex.org/S153560523","display_name":"SIAM Journal on Computing","issn_l":"0097-5397","issn":["0097-5397","1095-7111"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320508","host_organization_name":"Society for Industrial and Applied Mathematics","host_organization_lineage":["https://openalex.org/P4310320508"],"host_organization_lineage_names":["Society for Industrial and Applied Mathematics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SIAM Journal on Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W1655990431","https://openalex.org/W1967992696","https://openalex.org/W1969148345","https://openalex.org/W1975714036","https://openalex.org/W2000346568","https://openalex.org/W2111607006","https://openalex.org/W2169012378","https://openalex.org/W2185907055"],"related_works":["https://openalex.org/W2085988990","https://openalex.org/W2056340443","https://openalex.org/W2005835473","https://openalex.org/W2378275298","https://openalex.org/W60748262","https://openalex.org/W3174970460","https://openalex.org/W1979093255","https://openalex.org/W2056147406","https://openalex.org/W2376710457","https://openalex.org/W206482712"],"abstract_inverted_index":{"We":[0,18],"present":[1],"an":[2],"algorithm":[3,22],"for":[4],"constructing":[5],"a":[6,10,25,30,33],"tree":[7],"to":[8,23],"satisfy":[9],"set":[11],"of":[12,39],"lineage":[13],"constraints":[14],"on":[15],"common":[16],"ancestors.":[17],"then":[19],"apply":[20],"this":[21],"synthesize":[24],"relational":[26,40],"algebra":[27],"expression":[28],"from":[29],"simple":[31],"tableau,":[32],"problem":[34],"arising":[35],"in":[36],"the":[37],"theory":[38],"databases.":[41]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":12},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":20},{"year":2020,"cited_by_count":18},{"year":2019,"cited_by_count":14},{"year":2018,"cited_by_count":21},{"year":2017,"cited_by_count":18},{"year":2016,"cited_by_count":22},{"year":2015,"cited_by_count":17},{"year":2014,"cited_by_count":16},{"year":2013,"cited_by_count":14},{"year":2012,"cited_by_count":20}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}