{"id":"https://openalex.org/W2964142859","doi":"https://doi.org/10.14778/3236187.3236200","title":"Axiomatic foundations and algorithms for deciding semantic equivalences of SQL queries","display_name":"Axiomatic foundations and algorithms for deciding semantic equivalences of SQL queries","publication_year":2018,"publication_date":"2018-07-01","ids":{"openalex":"https://openalex.org/W2964142859","doi":"https://doi.org/10.14778/3236187.3236200","mag":"2964142859"},"language":"en","primary_location":{"id":"doi:10.14778/3236187.3236200","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3236187.3236200","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","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/A5102141433","display_name":"Shumo Chu","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Shumo Chu","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003505771","display_name":"Brendan Murphy","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Brendan Murphy","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076140574","display_name":"Jared Roesch","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jared Roesch","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059427197","display_name":"Alvin Cheung","orcid":"https://orcid.org/0000-0001-6261-6263"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alvin Cheung","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048204602","display_name":"Dan Suciu","orcid":"https://orcid.org/0000-0002-4144-0868"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dan Suciu","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5102141433"],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":3.6998,"has_fulltext":false,"cited_by_count":59,"citation_normalized_percentile":{"value":0.93847383,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":100},"biblio":{"volume":"11","issue":"11","first_page":"1482","last_page":"1495"},"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.9994999766349792,"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.9994999766349792,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9979000091552734,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8429777026176453},{"id":"https://openalex.org/keywords/semiring","display_name":"Semiring","score":0.8324320316314697},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7067751884460449},{"id":"https://openalex.org/keywords/axiom","display_name":"Axiom","score":0.5953323841094971},{"id":"https://openalex.org/keywords/formalism","display_name":"Formalism (music)","score":0.5510627627372742},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5454431772232056},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.49906206130981445},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4521484971046448},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33010584115982056},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.30204880237579346},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2424931824207306},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.21410256624221802}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8429777026176453},{"id":"https://openalex.org/C21696900","wikidata":"https://www.wikidata.org/wiki/Q1333055","display_name":"Semiring","level":2,"score":0.8324320316314697},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7067751884460449},{"id":"https://openalex.org/C167729594","wikidata":"https://www.wikidata.org/wiki/Q17736","display_name":"Axiom","level":2,"score":0.5953323841094971},{"id":"https://openalex.org/C73301696","wikidata":"https://www.wikidata.org/wiki/Q5469984","display_name":"Formalism (music)","level":3,"score":0.5510627627372742},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5454431772232056},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.49906206130981445},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4521484971046448},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33010584115982056},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.30204880237579346},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2424931824207306},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.21410256624221802},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C558565934","wikidata":"https://www.wikidata.org/wiki/Q2743","display_name":"Musical","level":2,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3236187.3236200","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3236187.3236200","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":53,"referenced_works":["https://openalex.org/W135863099","https://openalex.org/W151059316","https://openalex.org/W162365910","https://openalex.org/W1464569014","https://openalex.org/W1512639828","https://openalex.org/W1549008998","https://openalex.org/W1558832481","https://openalex.org/W1582686279","https://openalex.org/W1587829740","https://openalex.org/W1588115473","https://openalex.org/W1633805695","https://openalex.org/W1970165929","https://openalex.org/W1974695870","https://openalex.org/W1979514837","https://openalex.org/W1988504473","https://openalex.org/W2038412523","https://openalex.org/W2048531653","https://openalex.org/W2056660085","https://openalex.org/W2074935284","https://openalex.org/W2079590017","https://openalex.org/W2090438868","https://openalex.org/W2093793584","https://openalex.org/W2122406210","https://openalex.org/W2122917446","https://openalex.org/W2142317753","https://openalex.org/W2153131284","https://openalex.org/W2156717879","https://openalex.org/W2163491591","https://openalex.org/W2165674271","https://openalex.org/W2199514203","https://openalex.org/W2293299776","https://openalex.org/W2503947316","https://openalex.org/W2579532545","https://openalex.org/W2584709123","https://openalex.org/W2585641484","https://openalex.org/W2612045938","https://openalex.org/W2613232875","https://openalex.org/W2613947812","https://openalex.org/W2614913282","https://openalex.org/W2734461124","https://openalex.org/W2753707546","https://openalex.org/W2763179278","https://openalex.org/W2786433339","https://openalex.org/W2898627148","https://openalex.org/W2963046270","https://openalex.org/W4206031975","https://openalex.org/W4230287978","https://openalex.org/W4244028915","https://openalex.org/W4285719527","https://openalex.org/W6605485969","https://openalex.org/W6633513001","https://openalex.org/W6732730294","https://openalex.org/W7073745442"],"related_works":["https://openalex.org/W2786433339","https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W2902831276","https://openalex.org/W2898886863","https://openalex.org/W3174970460","https://openalex.org/W1639806124","https://openalex.org/W2165259096","https://openalex.org/W3022423983","https://openalex.org/W12347151"],"abstract_inverted_index":{"Deciding":[0],"the":[1,21,25,48,117],"equivalence":[2],"of":[3,24,50,119,147],"SQL":[4,51,101,143],"queries":[5,102,130],"is":[6,67],"a":[7,40],"fundamental":[8],"problem":[9],"in":[10],"data":[11,137],"management.":[12],"As":[13],"prior":[14],"work":[15],"has":[16],"mainly":[17],"focused":[18],"on":[19],"studying":[20],"theoretical":[22],"limitations":[23],"problem,":[26],"very":[27,71],"few":[28,72],"implementations":[29],"for":[30,45,86],"checking":[31],"such":[32,83],"equivalences":[33,49],"exist.":[34],"In":[35],"this":[36],"paper,":[37],"we":[38,121],"present":[39],"new":[41],"formalism":[42],"and":[43,63,74,108,131,141],"implementation":[44],"reasoning":[46],"about":[47,99],"queries.":[52],"Our":[53],"formalism,":[54],"U-semiring,":[55,120],"extends":[56],"SQL's":[57],"semiring":[58],"semantics":[59],"with":[60,111],"unbounded":[61],"summation":[62],"duplicate":[64],"elimination.":[65],"U-semiring":[66],"defined":[68],"using":[69,80],"only":[70],"axioms":[73],"can":[75],"thus":[76],"be":[77],"easily":[78],"implemented":[79],"proof":[81],"assistants":[82],"as":[84],"Lean":[85],"automated":[87],"query":[88],"reasoning.":[89],"Yet,":[90],"they":[91],"are":[92,104],"sufficient":[93],"enough":[94],"to":[95,125],"enable":[96],"us":[97],"reason":[98],"sophisticated":[100],"that":[103],"evaluated":[105],"over":[106],"bags":[107],"sets,":[109],"along":[110],"various":[112],"integrity":[113],"constraints.":[114],"To":[115],"evaluate":[116],"effectiveness":[118],"have":[122,149],"used":[123],"it":[124],"formally":[126],"verify":[127],"68":[128],"equivalent":[129],"rewrite":[132],"rules":[133],"from":[134],"both":[135],"classical":[136],"management":[138],"research":[139],"papers":[140],"real-world":[142],"engines,":[144],"where":[145],"many":[146],"them":[148],"never":[150],"been":[151],"proven":[152],"correct":[153],"before.":[154]},"counts_by_year":[{"year":2025,"cited_by_count":17},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":13},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":11},{"year":2019,"cited_by_count":5}],"updated_date":"2026-03-09T08:58:05.943551","created_date":"2025-10-10T00:00:00"}