{"id":"https://openalex.org/W4396214235","doi":"https://doi.org/10.1145/3649849","title":"VeriEQL: Bounded Equivalence Verification for Complex SQL Queries with Integrity Constraints","display_name":"VeriEQL: Bounded Equivalence Verification for Complex SQL Queries with Integrity Constraints","publication_year":2024,"publication_date":"2024-04-29","ids":{"openalex":"https://openalex.org/W4396214235","doi":"https://doi.org/10.1145/3649849"},"language":"en","primary_location":{"id":"doi:10.1145/3649849","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649849","pdf_url":null,"source":{"id":"https://openalex.org/S4210216081","display_name":"Proceedings of the ACM on Programming Languages","issn_l":"2475-1421","issn":["2475-1421"],"is_oa":true,"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Programming Languages","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://doi.org/10.1145/3649849","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101932345","display_name":"Yang He","orcid":"https://orcid.org/0009-0007-7755-3112"},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Yang He","raw_affiliation_strings":["Simon Fraser University, Burnaby, Canada"],"raw_orcid":"https://orcid.org/0009-0007-7755-3112","affiliations":[{"raw_affiliation_string":"Simon Fraser University, Burnaby, Canada","institution_ids":["https://openalex.org/I18014758"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048880936","display_name":"P. Zhao","orcid":"https://orcid.org/0009-0002-1149-0706"},"institutions":[{"id":"https://openalex.org/I27837315","display_name":"University of Michigan","ror":"https://ror.org/00jmfr291","country_code":"US","type":"education","lineage":["https://openalex.org/I27837315"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pinhan Zhao","raw_affiliation_strings":["University of Michigan, Ann Arbor, USA"],"raw_orcid":"https://orcid.org/0009-0002-1149-0706","affiliations":[{"raw_affiliation_string":"University of Michigan, Ann Arbor, USA","institution_ids":["https://openalex.org/I27837315"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100352782","display_name":"Xinyu Wang","orcid":"https://orcid.org/0000-0002-1836-0202"},"institutions":[{"id":"https://openalex.org/I27837315","display_name":"University of Michigan","ror":"https://ror.org/00jmfr291","country_code":"US","type":"education","lineage":["https://openalex.org/I27837315"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xinyu Wang","raw_affiliation_strings":["University of Michigan, Ann Arbor, USA"],"raw_orcid":"https://orcid.org/0000-0002-1836-0202","affiliations":[{"raw_affiliation_string":"University of Michigan, Ann Arbor, USA","institution_ids":["https://openalex.org/I27837315"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5024695395","display_name":"Yuepeng Wang","orcid":"https://orcid.org/0000-0003-3370-2431"},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Yuepeng Wang","raw_affiliation_strings":["Simon Fraser University, Burnaby, Canada"],"raw_orcid":"https://orcid.org/0000-0003-3370-2431","affiliations":[{"raw_affiliation_string":"Simon Fraser University, Burnaby, Canada","institution_ids":["https://openalex.org/I18014758"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.0037,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.86055476,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"8","issue":"OOPSLA1","first_page":"1071","last_page":"1099"},"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.9998000264167786,"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.9998000264167786,"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/T10772","display_name":"Distributed systems and fault tolerance","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/T10126","display_name":"Logic, programming, and type systems","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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.6887428164482117},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6685859560966492},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.652597188949585},{"id":"https://openalex.org/keywords/bounded-function","display_name":"Bounded function","score":0.644371509552002},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5982136130332947},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5215632319450378},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5103296637535095},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5066788792610168},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.36315733194351196},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.32137763500213623}],"concepts":[{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.6887428164482117},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6685859560966492},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.652597188949585},{"id":"https://openalex.org/C34388435","wikidata":"https://www.wikidata.org/wiki/Q2267362","display_name":"Bounded function","level":2,"score":0.644371509552002},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5982136130332947},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5215632319450378},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5103296637535095},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5066788792610168},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.36315733194351196},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.32137763500213623},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3649849","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649849","pdf_url":null,"source":{"id":"https://openalex.org/S4210216081","display_name":"Proceedings of the ACM on Programming Languages","issn_l":"2475-1421","issn":["2475-1421"],"is_oa":true,"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Programming Languages","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3649849","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3649849","pdf_url":null,"source":{"id":"https://openalex.org/S4210216081","display_name":"Proceedings of the ACM on Programming Languages","issn_l":"2475-1421","issn":["2475-1421"],"is_oa":true,"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Programming Languages","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":48,"referenced_works":["https://openalex.org/W57185801","https://openalex.org/W135863099","https://openalex.org/W1480909796","https://openalex.org/W1507006488","https://openalex.org/W1582686279","https://openalex.org/W1587844310","https://openalex.org/W1806382567","https://openalex.org/W1970165929","https://openalex.org/W1975714036","https://openalex.org/W1976978933","https://openalex.org/W1979514837","https://openalex.org/W2004188181","https://openalex.org/W2020949660","https://openalex.org/W2028980140","https://openalex.org/W2040856861","https://openalex.org/W2057156093","https://openalex.org/W2058560220","https://openalex.org/W2129538349","https://openalex.org/W2131231258","https://openalex.org/W2134179408","https://openalex.org/W2140782052","https://openalex.org/W2149996206","https://openalex.org/W2295144739","https://openalex.org/W2418260908","https://openalex.org/W2503947316","https://openalex.org/W2613232875","https://openalex.org/W2614913282","https://openalex.org/W2740841986","https://openalex.org/W2803369237","https://openalex.org/W2862455684","https://openalex.org/W2898350230","https://openalex.org/W2911450990","https://openalex.org/W2942769268","https://openalex.org/W2952590799","https://openalex.org/W2963046270","https://openalex.org/W2963426888","https://openalex.org/W2964115955","https://openalex.org/W2964142859","https://openalex.org/W2971026710","https://openalex.org/W3013999834","https://openalex.org/W3014023550","https://openalex.org/W3100044845","https://openalex.org/W3107615119","https://openalex.org/W3202030395","https://openalex.org/W4239146630","https://openalex.org/W4289866538","https://openalex.org/W6605485969","https://openalex.org/W6948912970"],"related_works":["https://openalex.org/W3013085049","https://openalex.org/W1560496689","https://openalex.org/W1992739770","https://openalex.org/W4386900933","https://openalex.org/W4229058035","https://openalex.org/W2152797858","https://openalex.org/W3125672081","https://openalex.org/W4385301946","https://openalex.org/W2006389905","https://openalex.org/W4297797135"],"abstract_inverted_index":{"The":[0],"task":[1],"of":[2,35,57,71,77,99,130,134,137],"SQL":[3,79],"query":[4,14,91],"equivalence":[5,76],"checking":[6],"is":[7,82,105],"important":[8],"in":[9,32,51,132,160],"various":[10],"real-world":[11],"applications":[12],"(including":[13],"rewriting":[15],"and":[16,66,73,164],"automated":[17],"grading)":[18],"that":[19,42,89,119,139,150],"involve":[20,43],"complex":[21,38,78],"queries":[22],"with":[23,101],"integrity":[24,48],"constraints;":[25],"yet,":[26],"state-of-the-art":[27,123],"techniques":[28,124],"are":[29],"very":[30],"limited":[31],"their":[33],"capability":[34],"reasoning":[36],"about":[37],"features":[39],"(e.g.,":[40],"those":[41],"sorting,":[44],"case":[45],"statement,":[46],"rich":[47],"constraints,":[49],"etc.)":[50],"real-life":[52],"queries.":[53,80],"To":[54],"the":[55,62,97,135],"best":[56],"our":[58,111],"knowledge,":[59],"we":[60],"propose":[61],"first":[63],"SMT-based":[64],"approach":[65],"its":[67],"implementation,":[68],"VeriEQL,":[69],"capable":[70],"proving":[72],"disproving":[74],"bounded":[75],"VeriEQL":[81,120,145],"based":[83],"on":[84,114],"a":[85],"new":[86],"logical":[87],"encoding":[88],"models":[90],"semantics":[92],"over":[93,115],"symbolic":[94],"tuples":[95],"using":[96],"theory":[98],"integers":[100],"uninterpreted":[102],"functions.":[103],"It":[104],"simple":[106],"yet":[107],"highly":[108],"practical":[109],"--":[110],"comprehensive":[112],"evaluation":[113],"20,000":[116],"benchmarks":[117,138],"shows":[118],"outperforms":[121],"all":[122],"by":[125],"more":[126],"than":[127],"one":[128],"order":[129],"magnitude":[131],"terms":[133],"number":[136],"can":[140,146],"be":[141],"proved":[142],"or":[143],"disproved.":[144],"also":[147],"generate":[148],"counterexamples":[149],"facilitate":[151],"many":[152],"downstream":[153],"tasks":[154],"(such":[155],"as":[156],"finding":[157],"serious":[158],"bugs":[159],"systems":[161],"like":[162],"MySQL":[163],"Apache":[165],"Calcite).":[166]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":7},{"year":2024,"cited_by_count":1}],"updated_date":"2026-08-14T07:06:38.338062","created_date":"2025-10-10T00:00:00"}