{"id":"https://openalex.org/W2765220885","doi":"https://doi.org/10.1007/978-3-319-89366-2_27","title":"The Equational Theory of the Natural Join and Inner Union is Decidable","display_name":"The Equational Theory of the Natural Join and Inner Union is Decidable","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2765220885","doi":"https://doi.org/10.1007/978-3-319-89366-2_27","mag":"2765220885"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-319-89366-2_27","is_oa":true,"landing_page_url":"https://doi.org/10.1007/978-3-319-89366-2_27","pdf_url":"https://link.springer.com/content/pdf/10.1007%2F978-3-319-89366-2_27.pdf","source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"preprint","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007%2F978-3-319-89366-2_27.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5049300785","display_name":"Luigi Santocanale","orcid":"https://orcid.org/0000-0002-4237-7856"},"institutions":[{"id":"https://openalex.org/I1294671590","display_name":"Centre National de la Recherche Scientifique","ror":"https://ror.org/02feahw73","country_code":"FR","type":"funder","lineage":["https://openalex.org/I1294671590"]},{"id":"https://openalex.org/I21491767","display_name":"Aix-Marseille Universit\u00e9","ror":"https://ror.org/035xkbk20","country_code":"FR","type":"education","lineage":["https://openalex.org/I21491767"]},{"id":"https://openalex.org/I4210114274","display_name":"Laboratoire d\u2019Informatique et Syst\u00e8mes","ror":"https://ror.org/0257sgk90","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I143002897","https://openalex.org/I21491767","https://openalex.org/I4210114274"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Luigi Santocanale","raw_affiliation_strings":["LIS, CNRS UMR 7020, Aix-Marseille Universit\u00e9, Marseille, France","LIS-CNRS UMR 7020, Aix-Marseille Universit\u00e9, Marseille, France"],"affiliations":[{"raw_affiliation_string":"LIS, CNRS UMR 7020, Aix-Marseille Universit\u00e9, Marseille, France","institution_ids":["https://openalex.org/I21491767","https://openalex.org/I4210114274","https://openalex.org/I1294671590"]},{"raw_affiliation_string":"LIS-CNRS UMR 7020, Aix-Marseille Universit\u00e9, Marseille, France","institution_ids":["https://openalex.org/I21491767","https://openalex.org/I4210114274","https://openalex.org/I1294671590"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5049300785"],"corresponding_institution_ids":["https://openalex.org/I1294671590","https://openalex.org/I21491767","https://openalex.org/I4210114274"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":{"value":5000,"currency":"EUR","value_usd":5392},"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.01958425,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"494","last_page":"510"},"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9961000084877014,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9943000078201294,"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/undecidable-problem","display_name":"Undecidable problem","score":0.8407769799232483},{"id":"https://openalex.org/keywords/decidability","display_name":"Decidability","score":0.8194116353988647},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.6834180355072021},{"id":"https://openalex.org/keywords/lattice","display_name":"Lattice (music)","score":0.5487233400344849},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5372951030731201},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.5369230508804321},{"id":"https://openalex.org/keywords/codds-theorem","display_name":"Codd's theorem","score":0.5015854835510254},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.45029258728027344},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.43442779779434204},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.42215076088905334},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.3516964912414551},{"id":"https://openalex.org/keywords/algebra-over-a-field","display_name":"Algebra over a field","score":0.3432750701904297},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.3132047653198242},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.2961800992488861},{"id":"https://openalex.org/keywords/pure-mathematics","display_name":"Pure mathematics","score":0.25850236415863037},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.09017378091812134}],"concepts":[{"id":"https://openalex.org/C192034797","wikidata":"https://www.wikidata.org/wiki/Q3502995","display_name":"Undecidable problem","level":3,"score":0.8407769799232483},{"id":"https://openalex.org/C153269930","wikidata":"https://www.wikidata.org/wiki/Q430001","display_name":"Decidability","level":2,"score":0.8194116353988647},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.6834180355072021},{"id":"https://openalex.org/C2781204021","wikidata":"https://www.wikidata.org/wiki/Q6497091","display_name":"Lattice (music)","level":2,"score":0.5487233400344849},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5372951030731201},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.5369230508804321},{"id":"https://openalex.org/C16739119","wikidata":"https://www.wikidata.org/wiki/Q5139948","display_name":"Codd's theorem","level":5,"score":0.5015854835510254},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.45029258728027344},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.43442779779434204},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.42215076088905334},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.3516964912414551},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.3432750701904297},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3132047653198242},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.2961800992488861},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.25850236415863037},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.09017378091812134},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C24890656","wikidata":"https://www.wikidata.org/wiki/Q82811","display_name":"Acoustics","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1007/978-3-319-89366-2_27","is_oa":true,"landing_page_url":"https://doi.org/10.1007/978-3-319-89366-2_27","pdf_url":"https://link.springer.com/content/pdf/10.1007%2F978-3-319-89366-2_27.pdf","source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:arXiv.org:1710.11500","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1710.11500","pdf_url":"https://arxiv.org/pdf/1710.11500","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"mag:2765220885","is_oa":true,"landing_page_url":"https://arxiv.org/pdf/1710.11500.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"arXiv (Cornell University)","raw_type":null},{"id":"pmh:oai:HAL:hal-01625134v1","is_oa":true,"landing_page_url":"https://hal.science/hal-01625134","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"FOSSACS 2018, Apr 2018, Thessaloniki, Greece. pp.494--510, ⟨10.1007/978-3-319-89366-2_27⟩","raw_type":"Conference papers"},{"id":"doi:10.48550/arxiv.1710.11500","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.1710.11500","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.1007/978-3-319-89366-2_27","is_oa":true,"landing_page_url":"https://doi.org/10.1007/978-3-319-89366-2_27","pdf_url":"https://link.springer.com/content/pdf/10.1007%2F978-3-319-89366-2_27.pdf","source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"sustainable_development_goals":[{"display_name":"Reduced inequalities","score":0.7400000095367432,"id":"https://metadata.un.org/sdg/10"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2765220885.pdf","grobid_xml":"https://content.openalex.org/works/W2765220885.grobid-xml"},"referenced_works_count":22,"referenced_works":["https://openalex.org/W1489614395","https://openalex.org/W1753706763","https://openalex.org/W1771944222","https://openalex.org/W1963646041","https://openalex.org/W1990711332","https://openalex.org/W2012917747","https://openalex.org/W2020879982","https://openalex.org/W2059402157","https://openalex.org/W2093397547","https://openalex.org/W2146163245","https://openalex.org/W2165467455","https://openalex.org/W2185907055","https://openalex.org/W2265945562","https://openalex.org/W2274584817","https://openalex.org/W2490805901","https://openalex.org/W2609335432","https://openalex.org/W2615988713","https://openalex.org/W2724355227","https://openalex.org/W2793632772","https://openalex.org/W2964260489","https://openalex.org/W4254880666","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2479163333","https://openalex.org/W2471670988","https://openalex.org/W2793632772","https://openalex.org/W2592191834","https://openalex.org/W2274584817","https://openalex.org/W2520551121","https://openalex.org/W2494931246","https://openalex.org/W3046072471","https://openalex.org/W2806335044","https://openalex.org/W1611141590","https://openalex.org/W2019159031","https://openalex.org/W3173971361","https://openalex.org/W2044089506","https://openalex.org/W3031008428","https://openalex.org/W2147980870","https://openalex.org/W2049561126","https://openalex.org/W2913583188","https://openalex.org/W1967637206","https://openalex.org/W3210454497","https://openalex.org/W3034071501"],"abstract_inverted_index":{"The":[0],"natural":[1],"join":[2,26],"and":[3,14,25,173],"the":[4,23,37,50,56,65,72,81,87,92,100,169],"inner":[5],"union":[6],"operations":[7,21,27],"combine":[8],"relations":[9],"of":[10,31,52,68,74,103,149,168,171],"a":[11,29,156,164],"database.":[12],"Tropashko":[13],"Spight":[15],"[25]":[16],"realized":[17],"that":[18,64,99,139],"these":[19,69,150],"two":[20,117],"are":[22,123],"meet":[24],"in":[28,79,129,147,155],"class":[30],"lattices,":[32,151],"known":[33],"by":[34,137,163],"now":[35],"as":[36,45],"relational":[38,57,82,104,131,157],"lattices.":[39],"They":[40],"proposed":[41],"then":[42,152],"lattice":[43,94,118,158],"theory":[44,51,67,102],"an":[46,112,141],"algebraic":[47],"approach":[48],"to":[49,55,91,114],"databases,":[53],"alternative":[54],"algebra.":[58],"Previous":[59],"works":[60],"[17,":[61],"23]":[62],"proved":[63],"quasiequational":[66],"lattices\u2014that":[70],"is,":[71],"set":[73],"definite":[75],"Horn":[76],"sentences":[77],"valid":[78],"all":[80,127],"lattices\u2014is":[83],"undecidable,":[84],"even":[85],"when":[86],"signature":[88],"is":[89,106,109,161],"restricted":[90],"pure":[93],"signature.":[95],"We":[96,133],"prove":[97],"here":[98],"equational":[101],"lattices":[105],"decidable.":[107],"That,":[108],"we":[110],"provide":[111],"algorithm":[113],"decide":[115],"if":[116,140],"theoretic":[119],"terms":[120],"t,":[121],"s":[122],"made":[124],"equal":[125],"under":[126],"interpretations":[128],"some":[130],"lattice.":[132],"achieve":[134],"this":[135],"goal":[136],"showing":[138],"inclusion":[142],"$$t":[143],"\\le":[144],"s$$":[145],"fails":[146,154],"any":[148],"it":[153],"whose":[159],"size":[160],"bound":[162],"triple":[165],"exponential":[166],"function":[167],"sizes":[170],"t":[172],"s.":[174]},"counts_by_year":[],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}