{"id":"https://openalex.org/W2614913282","doi":"https://doi.org/10.14778/3151113.3151116","title":"A formal semantics of SQL queries, its validation, and applications","display_name":"A formal semantics of SQL queries, its validation, and applications","publication_year":2017,"publication_date":"2017-09-01","ids":{"openalex":"https://openalex.org/W2614913282","doi":"https://doi.org/10.14778/3151113.3151116","mag":"2614913282"},"language":"en","primary_location":{"id":"doi:10.14778/3151113.3151116","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3151113.3151116","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":true,"oa_status":"green","oa_url":"https://www.research.ed.ac.uk/en/publications/e61e1954-1387-42eb-8d85-06c6403bfc5c","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5089657548","display_name":"Paolo Guagliardo","orcid":"https://orcid.org/0000-0003-0756-5787"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Paolo Guagliardo","raw_affiliation_strings":["University of Edinburgh"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069883356","display_name":"Leonid Libkin","orcid":"https://orcid.org/0000-0002-6698-2735"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Leonid Libkin","raw_affiliation_strings":["University of Edinburgh"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh","institution_ids":["https://openalex.org/I98677209"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5089657548"],"corresponding_institution_ids":["https://openalex.org/I98677209"],"apc_list":null,"apc_paid":null,"fwci":5.2622,"has_fulltext":true,"cited_by_count":54,"citation_normalized_percentile":{"value":0.96036195,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"11","issue":"1","first_page":"27","last_page":"39"},"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.9983000159263611,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9983000159263611,"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/programming-language","display_name":"Programming language","score":0.718659520149231},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7066982984542847},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6529810428619385},{"id":"https://openalex.org/keywords/operational-semantics","display_name":"Operational semantics","score":0.6058138608932495},{"id":"https://openalex.org/keywords/formal-semantics","display_name":"Formal semantics (linguistics)","score":0.5737565159797668},{"id":"https://openalex.org/keywords/well-founded-semantics","display_name":"Well-founded semantics","score":0.5710159540176392},{"id":"https://openalex.org/keywords/action-semantics","display_name":"Action semantics","score":0.5666294097900391},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5021941661834717},{"id":"https://openalex.org/keywords/fragment","display_name":"Fragment (logic)","score":0.42490947246551514},{"id":"https://openalex.org/keywords/denotational-semantics","display_name":"Denotational semantics","score":0.37213414907455444},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3556859493255615},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.323840856552124}],"concepts":[{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.718659520149231},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7066982984542847},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6529810428619385},{"id":"https://openalex.org/C156325763","wikidata":"https://www.wikidata.org/wiki/Q1930895","display_name":"Operational semantics","level":3,"score":0.6058138608932495},{"id":"https://openalex.org/C146499914","wikidata":"https://www.wikidata.org/wiki/Q5469969","display_name":"Formal semantics (linguistics)","level":2,"score":0.5737565159797668},{"id":"https://openalex.org/C89497691","wikidata":"https://www.wikidata.org/wiki/Q7981058","display_name":"Well-founded semantics","level":5,"score":0.5710159540176392},{"id":"https://openalex.org/C150607116","wikidata":"https://www.wikidata.org/wiki/Q4677421","display_name":"Action semantics","level":5,"score":0.5666294097900391},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5021941661834717},{"id":"https://openalex.org/C2776235265","wikidata":"https://www.wikidata.org/wiki/Q18392052","display_name":"Fragment (logic)","level":2,"score":0.42490947246551514},{"id":"https://openalex.org/C207648694","wikidata":"https://www.wikidata.org/wiki/Q1189746","display_name":"Denotational semantics","level":4,"score":0.37213414907455444},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3556859493255615},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.323840856552124}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.14778/3151113.3151116","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3151113.3151116","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"},{"id":"pmh:oai:pure.ed.ac.uk:openaire/e61e1954-1387-42eb-8d85-06c6403bfc5c","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/e61e1954-1387-42eb-8d85-06c6403bfc5c","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Guagliardo, P & Libkin, L 2017, 'A Formal Semantics of SQL Queries, Its Validation, and Applications', Proceedings of the VLDB Endowment (PVLDB), vol. 11, no. 1, pp. 27-39. https://doi.org/10.14778/3151113.3151116","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:pure.ed.ac.uk:publications/e61e1954-1387-42eb-8d85-06c6403bfc5c","is_oa":true,"landing_page_url":"https://dl.acm.org/citation.cfm?doid=3151113.3151116","pdf_url":"http://hdl.handle.net/20.500.11820/e61e1954-1387-42eb-8d85-06c6403bfc5c","source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""}],"best_oa_location":{"id":"pmh:oai:pure.ed.ac.uk:openaire/e61e1954-1387-42eb-8d85-06c6403bfc5c","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/e61e1954-1387-42eb-8d85-06c6403bfc5c","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Guagliardo, P & Libkin, L 2017, 'A Formal Semantics of SQL Queries, Its Validation, and Applications', Proceedings of the VLDB Endowment (PVLDB), vol. 11, no. 1, pp. 27-39. https://doi.org/10.14778/3151113.3151116","raw_type":"info:eu-repo/semantics/publishedVersion"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4378070110","display_name":null,"funder_award_id":"N023056","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G53695486","display_name":null,"funder_award_id":"EP/N023056/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G5458651130","display_name":null,"funder_award_id":"M025268","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G8400180575","display_name":null,"funder_award_id":"EP/M025268/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"}],"funders":[{"id":"https://openalex.org/F4320334627","display_name":"Engineering and Physical Sciences Research Council","ror":"https://ror.org/0439y7842"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":52,"referenced_works":["https://openalex.org/W163539143","https://openalex.org/W220935706","https://openalex.org/W223180054","https://openalex.org/W1499274542","https://openalex.org/W1534508664","https://openalex.org/W1558832481","https://openalex.org/W1559950975","https://openalex.org/W1569403765","https://openalex.org/W1577367252","https://openalex.org/W1582686279","https://openalex.org/W1592609929","https://openalex.org/W1593666219","https://openalex.org/W1668477564","https://openalex.org/W1760139041","https://openalex.org/W1783388813","https://openalex.org/W1818561783","https://openalex.org/W1829244603","https://openalex.org/W1996545223","https://openalex.org/W2002301065","https://openalex.org/W2020949660","https://openalex.org/W2021347435","https://openalex.org/W2029138494","https://openalex.org/W2039384225","https://openalex.org/W2047499522","https://openalex.org/W2047650147","https://openalex.org/W2138474070","https://openalex.org/W2143436119","https://openalex.org/W2408791408","https://openalex.org/W2431688250","https://openalex.org/W2503947316","https://openalex.org/W2584709123","https://openalex.org/W2753710282","https://openalex.org/W3100065561","https://openalex.org/W3144403471","https://openalex.org/W3149201378","https://openalex.org/W3200788958","https://openalex.org/W4206031975","https://openalex.org/W4230019621","https://openalex.org/W4246162927","https://openalex.org/W4255327858","https://openalex.org/W4302984605","https://openalex.org/W6629756347","https://openalex.org/W6631993249","https://openalex.org/W6633513001","https://openalex.org/W6633526040","https://openalex.org/W6633961643","https://openalex.org/W6637361011","https://openalex.org/W6638886220","https://openalex.org/W6648751428","https://openalex.org/W6662300712","https://openalex.org/W6732730294","https://openalex.org/W7018146823"],"related_works":["https://openalex.org/W91938043","https://openalex.org/W1988438613","https://openalex.org/W2070801544","https://openalex.org/W1975908952","https://openalex.org/W2348616540","https://openalex.org/W1487472891","https://openalex.org/W1426476981","https://openalex.org/W3007870257","https://openalex.org/W3106373601","https://openalex.org/W2952469471"],"abstract_inverted_index":{"While":[0],"formal":[1,47,58,93,157],"semantics":[2,28,45,59,94,172,226],"of":[3,35,41,46,53,60,76,129,140,150,159,162,227],"theoretical":[4],"languages":[5,54,62],"underlying":[6,49],"SQL":[7,77,164,213],"have":[8],"been":[9],"provided":[10],"in":[11,22,38,215],"the":[12,23,39,50,73,101,111,130,151,155,160,180,222],"past,":[13],"they":[14],"all":[15],"made":[16],"simplifying":[17],"assumptions":[18],"ranging":[19],"from":[20,100],"changes":[21],"syntax":[24],"to":[25,110,170,190,193],"omitting":[26],"bag":[27,171],"and":[29,68,87,90,114,144,165,173],"nulls.":[30,174,195],"This":[31,104],"situation":[32],"is":[33,154,187,201],"reminiscent":[34],"what":[36],"happens":[37],"field":[40],"programming":[42],"languages,":[43],"where":[44],"calculi":[48],"main":[51],"features":[52],"are":[55,66,119],"abundant,":[56],"but":[57],"real":[61,102],"that":[63,118,168,199],"people":[64],"use":[65],"few":[67],"far":[69],"between.":[70],"We":[71,146,196],"consider":[72],"basic":[74,163],"class":[75],"queries":[78,82,143],"---":[79,89],"essentially":[80],"SELECT-FROM-WHERE":[81],"with":[83],"subqueries,":[84],"set/bag":[85],"operations,":[86],"nulls":[88],"define":[91],"a":[92,137],"for":[95],"it,":[96],"without":[97],"any":[98],"departures":[99],"language.":[103],"fragment":[105,217],"already":[106],"requires":[107],"decisions":[108],"related":[109],"data":[112],"model":[113],"handling":[115],"variable":[116],"names":[117],"normally":[120],"disregarded":[121],"by":[122,184],"simplified":[123],"semantics.":[124,152],"To":[125],"justify":[126],"our":[127,216],"choice":[128],"semantics,":[131],"we":[132],"validate":[133],"it":[134],"experimentally":[135],"on":[136],"large":[138],"number":[139],"randomly":[141],"generated":[142],"databases.":[145],"give":[147],"two":[148],"applications":[149],"One":[153],"first":[156],"proof":[158],"equivalence":[161],"relational":[166],"algebra":[167],"extends":[169],"The":[175],"other":[176],"application":[177],"looks":[178],"at":[179],"three-valued":[181,205],"logic":[182,206],"employed":[183],"SQL,":[185],"which":[186],"universally":[188],"assumed":[189],"be":[191,219],"necessary":[192],"handle":[194],"prove":[197],"however":[198],"this":[200],"not":[202,208],"so,":[203],"as":[204],"does":[207],"add":[209],"expressive":[210],"power:":[211],"every":[212],"query":[214],"can":[218],"evaluated":[220],"under":[221],"usual":[223],"two-valued":[224],"Boolean":[225],"conditions.":[228]},"counts_by_year":[{"year":2025,"cited_by_count":8},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":9},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":9},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":8},{"year":2017,"cited_by_count":1}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}