{"id":"https://openalex.org/W2971026710","doi":"https://doi.org/10.14778/3342263.3342267","title":"Automated verification of query equivalence using satisfiability modulo theories","display_name":"Automated verification of query equivalence using satisfiability modulo theories","publication_year":2019,"publication_date":"2019-07-01","ids":{"openalex":"https://openalex.org/W2971026710","doi":"https://doi.org/10.14778/3342263.3342267","mag":"2971026710"},"language":"en","primary_location":{"id":"doi:10.14778/3342263.3342267","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3342263.3342267","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/A5034240514","display_name":"Qi Zhou","orcid":"https://orcid.org/0000-0003-2591-395X"},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Qi Zhou","raw_affiliation_strings":["Georgia Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060680349","display_name":"Joy Arulraj","orcid":"https://orcid.org/0000-0002-7706-6978"},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Joy Arulraj","raw_affiliation_strings":["Georgia Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027462416","display_name":"Shamkant B. Navathe","orcid":"https://orcid.org/0000-0002-6666-0031"},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shamkant Navathe","raw_affiliation_strings":["Georgia Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030836304","display_name":"William R. Harris","orcid":"https://orcid.org/0000-0002-7667-1287"},"institutions":[{"id":"https://openalex.org/I4210140281","display_name":"Galois (United States)","ror":"https://ror.org/03g8y8161","country_code":"US","type":"company","lineage":["https://openalex.org/I4210140281"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"William Harris","raw_affiliation_strings":["Galois.Inc"],"affiliations":[{"raw_affiliation_string":"Galois.Inc","institution_ids":["https://openalex.org/I4210140281"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103804893","display_name":"Dong Xu","orcid":null},"institutions":[{"id":"https://openalex.org/I4210095624","display_name":"Alibaba Group (United States)","ror":"https://ror.org/00rn0m335","country_code":"US","type":"company","lineage":["https://openalex.org/I4210095624","https://openalex.org/I45928872"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dong Xu","raw_affiliation_strings":["Alibaba Group"],"affiliations":[{"raw_affiliation_string":"Alibaba Group","institution_ids":["https://openalex.org/I4210095624"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5034240514"],"corresponding_institution_ids":["https://openalex.org/I130701444"],"apc_list":null,"apc_paid":null,"fwci":3.0063,"has_fulltext":false,"cited_by_count":41,"citation_normalized_percentile":{"value":0.92121391,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"12","issue":"11","first_page":"1276","last_page":"1288"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9976999759674072,"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"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9962000250816345,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8043511509895325},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5452760457992554},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5149343609809875},{"id":"https://openalex.org/keywords/satisfiability-modulo-theories","display_name":"Satisfiability modulo theories","score":0.5041557550430298},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.49500101804733276},{"id":"https://openalex.org/keywords/formal-equivalence-checking","display_name":"Formal equivalence checking","score":0.45372819900512695},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.42839545011520386},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4272681474685669},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.39705681800842285},{"id":"https://openalex.org/keywords/model-checking","display_name":"Model checking","score":0.32048726081848145},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.0927499532699585}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8043511509895325},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5452760457992554},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5149343609809875},{"id":"https://openalex.org/C164155591","wikidata":"https://www.wikidata.org/wiki/Q2067766","display_name":"Satisfiability modulo theories","level":2,"score":0.5041557550430298},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.49500101804733276},{"id":"https://openalex.org/C96654402","wikidata":"https://www.wikidata.org/wiki/Q5469962","display_name":"Formal equivalence checking","level":3,"score":0.45372819900512695},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.42839545011520386},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4272681474685669},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.39705681800842285},{"id":"https://openalex.org/C110251889","wikidata":"https://www.wikidata.org/wiki/Q1569697","display_name":"Model checking","level":2,"score":0.32048726081848145},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0927499532699585},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3342263.3342267","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3342263.3342267","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":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":51,"referenced_works":["https://openalex.org/W1128447031","https://openalex.org/W1480909796","https://openalex.org/W1483974062","https://openalex.org/W1512639828","https://openalex.org/W1553142094","https://openalex.org/W1556019018","https://openalex.org/W1561908196","https://openalex.org/W1570787829","https://openalex.org/W1587048407","https://openalex.org/W1587829740","https://openalex.org/W1592609929","https://openalex.org/W1595443289","https://openalex.org/W1633805695","https://openalex.org/W1835281610","https://openalex.org/W1979514837","https://openalex.org/W2013409229","https://openalex.org/W2020949660","https://openalex.org/W2022110761","https://openalex.org/W2026745535","https://openalex.org/W2035020007","https://openalex.org/W2048531653","https://openalex.org/W2056660085","https://openalex.org/W2057361103","https://openalex.org/W2079590017","https://openalex.org/W2094756211","https://openalex.org/W2094841990","https://openalex.org/W2134483537","https://openalex.org/W2135322712","https://openalex.org/W2141591281","https://openalex.org/W2142317753","https://openalex.org/W2151655370","https://openalex.org/W2156717879","https://openalex.org/W2163491591","https://openalex.org/W2164778826","https://openalex.org/W2171831739","https://openalex.org/W2497955259","https://openalex.org/W2503947316","https://openalex.org/W2530836305","https://openalex.org/W2613232875","https://openalex.org/W2734461124","https://openalex.org/W2763179278","https://openalex.org/W2766208582","https://openalex.org/W2799237774","https://openalex.org/W2963046270","https://openalex.org/W2964142859","https://openalex.org/W4241317396","https://openalex.org/W4244028915","https://openalex.org/W6635494053","https://openalex.org/W6635551685","https://openalex.org/W6740456295","https://openalex.org/W7028132910"],"related_works":["https://openalex.org/W2293855260","https://openalex.org/W2155162307","https://openalex.org/W4295885746","https://openalex.org/W3041332907","https://openalex.org/W2031915568","https://openalex.org/W55591046","https://openalex.org/W1594074817","https://openalex.org/W4285818047","https://openalex.org/W1982981798","https://openalex.org/W2005214031"],"abstract_inverted_index":{"Database-as-a-service":[0],"offerings":[1],"enable":[2],"users":[3],"to":[4,24,38,66,73,87,131,143,163,194],"quickly":[5],"create":[6],"and":[7,35,53,100,116,157,197],"deploy":[8],"complex":[9,97],"data":[10],"processing":[11],"pipelines.":[12],"In":[13],"practice,":[14],"these":[15],"pipelines":[16],"often":[17],"exhibit":[18],"significant":[19],"overlap":[20,41],"of":[21,27,76,91,149,186,190,211,223],"computation":[22,68],"due":[23],"redundant":[25,219],"execution":[26,220],"certain":[28],"sub-queries.":[29],"It":[30],"is":[31,142,230],"challenging":[32],"for":[33,62,127],"developers":[34],"database":[36],"administrators":[37],"manually":[39],"detect":[40],"across":[42,49,221],"queries":[43,65,151],"since":[44],"they":[45,84,104],"may":[46],"be":[47],"distributed":[48],"teams,":[50],"organization":[51],"roles,":[52],"geographic":[54],"locations.":[55],"Thus,":[56],"we":[57],"require":[58],"automated":[59,74],"cloud-scale":[60,119],"tools":[61],"identifying":[63],"equivalent":[64],"minimize":[67],"overlap.":[69],"State-of-the-art":[70],"algebraic":[71,195],"approaches":[72,196],"verification":[75,109,200],"query":[77,98,133,191],"equivalence":[78,134,185],"suffer":[79],"from":[80],"two":[81],"limitations.":[82],"First,":[83],"are":[85],"unable":[86],"model":[88],"the":[89,125,183,199,224],"semantics":[90],"widely-used":[92],"SQL":[93,150,214],"features,":[94],"such":[95],"as":[96],"predicates":[99],"three-valued":[101],"logic.":[102],"Second,":[103],"have":[105,169],"a":[106,146,187,209],"computationally":[107],"intensive":[108],"procedure.":[110],"These":[111],"limitations":[112],"restrict":[113],"their":[114,166],"efficacy":[115],"efficiency":[117],"in":[118,175],"database-as-a-service":[120,236],"offerings.":[121],"This":[122],"paper":[123],"makes":[124],"case":[126],"an":[128],"alternate":[129],"approach":[130,174],"determining":[132],"based":[135,228],"on":[136,208,233],"symbolic":[137,172],"representation.":[138],"The":[139],"key":[140],"idea":[141],"effectively":[144],"transform":[145],"wide":[147],"range":[148],"into":[152],"first":[153],"order":[154],"logic":[155],"formulae":[156],"then":[158],"use":[159],"satisfiability":[160],"modulo":[161],"theories":[162],"efficiently":[164],"verify":[165],"equivalence.":[167],"We":[168,204],"implemented":[170],"this":[171],"representation-based":[173],"EQUITAS.":[176],"Our":[177,226],"evaluation":[178],"shows":[179],"that":[180,207],"EQUITAS":[181],"proves":[182],"semantic":[184],"larger":[188],"set":[189,210],"pairs":[192],"compared":[193],"reduces":[198],"time":[201],"by":[202],"27X.":[203],"also":[205],"demonstrate":[206],"17,461":[212],"real-world":[213],"queries,":[215],"it":[216],"automatically":[217],"identifies":[218],"11%":[222],"queries.":[225],"symbolic-representation":[227],"technique":[229],"currently":[231],"deployed":[232],"Alibaba's":[234],"MaxCompute":[235],"platform.":[237]},"counts_by_year":[{"year":2025,"cited_by_count":11},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":7},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}