{"id":"https://openalex.org/W4389609814","doi":"https://doi.org/10.1145/3626768","title":"Proving Query Equivalence Using Linear Integer Arithmetic","display_name":"Proving Query Equivalence Using Linear Integer Arithmetic","publication_year":2023,"publication_date":"2023-12-08","ids":{"openalex":"https://openalex.org/W4389609814","doi":"https://doi.org/10.1145/3626768"},"language":"en","primary_location":{"id":"doi:10.1145/3626768","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3626768","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3626768","source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3626768","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5089127892","display_name":"Haoran Ding","orcid":"https://orcid.org/0009-0008-8138-8639"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haoran Ding","raw_affiliation_strings":["Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0008-8138-8639","affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101743342","display_name":"Zhaoguo Wang","orcid":"https://orcid.org/0000-0002-0220-5726"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhaoguo Wang","raw_affiliation_strings":["Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0002-0220-5726","affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064145014","display_name":"Yicun Yang","orcid":"https://orcid.org/0009-0004-5303-2599"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yicun Yang","raw_affiliation_strings":["Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0004-5303-2599","affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001664645","display_name":"D. Zhang","orcid":"https://orcid.org/0009-0005-9009-9503"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Dexin Zhang","raw_affiliation_strings":["Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0005-9009-9503","affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060692616","display_name":"Zhenglin Xu","orcid":"https://orcid.org/0009-0002-7868-6615"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhenglin Xu","raw_affiliation_strings":["Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0002-7868-6615","affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100406215","display_name":"Haibo Chen","orcid":"https://orcid.org/0000-0002-9720-0361"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haibo Chen","raw_affiliation_strings":["Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0002-9720-0361","affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045794652","display_name":"Ru\u017eica Piska\u010d","orcid":"https://orcid.org/0000-0002-3267-0776"},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ruzica Piskac","raw_affiliation_strings":["Yale University, New Haven, CT, USA"],"raw_orcid":"https://orcid.org/0000-0002-3267-0776","affiliations":[{"raw_affiliation_string":"Yale University, New Haven, CT, USA","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5073978798","display_name":"Jinyang Li","orcid":"https://orcid.org/0000-0002-9574-1746"},"institutions":[{"id":"https://openalex.org/I57206974","display_name":"New York University","ror":"https://ror.org/0190ak572","country_code":"US","type":"education","lineage":["https://openalex.org/I57206974"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jinyang Li","raw_affiliation_strings":["New York University, New York, NY, USA"],"raw_orcid":"https://orcid.org/0000-0002-9574-1746","affiliations":[{"raw_affiliation_string":"New York University, New York, NY, USA","institution_ids":["https://openalex.org/I57206974"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.8543,"has_fulltext":true,"cited_by_count":14,"citation_normalized_percentile":{"value":0.85682974,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"1","issue":"4","first_page":"1","last_page":"26"},"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.9948999881744385,"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.9929999709129333,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6320284605026245},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5951148271560669},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.5234260559082031},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.48175930976867676},{"id":"https://openalex.org/keywords/decidability","display_name":"Decidability","score":0.4756840467453003},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4518806040287018},{"id":"https://openalex.org/keywords/logical-equivalence","display_name":"Logical equivalence","score":0.4417969584465027},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.44160035252571106},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.4127786457538605},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.35061395168304443},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.34096312522888184},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3190538287162781},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2990362048149109},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.27968961000442505},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.15583086013793945}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6320284605026245},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5951148271560669},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.5234260559082031},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.48175930976867676},{"id":"https://openalex.org/C153269930","wikidata":"https://www.wikidata.org/wiki/Q430001","display_name":"Decidability","level":2,"score":0.4756840467453003},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4518806040287018},{"id":"https://openalex.org/C70846408","wikidata":"https://www.wikidata.org/wiki/Q220433","display_name":"Logical equivalence","level":3,"score":0.4417969584465027},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.44160035252571106},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.4127786457538605},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.35061395168304443},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.34096312522888184},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3190538287162781},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2990362048149109},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.27968961000442505},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.15583086013793945},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3626768","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3626768","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3626768","source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3626768","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3626768","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3626768","source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G205818515","display_name":null,"funder_award_id":"62132014","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4189931033","display_name":null,"funder_award_id":"62272304","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5655665177","display_name":null,"funder_award_id":"CCF-2131476","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5948185981","display_name":null,"funder_award_id":"FMitF-2220407,CCF-2131476","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"},{"id":"https://openalex.org/G7172231108","display_name":null,"funder_award_id":"62272304,62132014","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"},{"id":"https://openalex.org/G8054579944","display_name":"Collaborative Research: FMitF: Track I: Automatic Discovery and Verification of Database Query Transformations","funder_award_id":"2220407","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G96301305","display_name":"DASS: Accountability from Attention, not Assumption","funder_award_id":"2131476","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320323817","display_name":"Universitas Brawijaya","ror":"https://ror.org/01wk3d929"},{"id":"https://openalex.org/F4320335787","display_name":"Fundamental Research Funds for the Central Universities","ror":null}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4389609814.pdf","grobid_xml":"https://content.openalex.org/works/W4389609814.grobid-xml"},"referenced_works_count":31,"referenced_works":["https://openalex.org/W135863099","https://openalex.org/W1480909796","https://openalex.org/W1493089824","https://openalex.org/W1596865963","https://openalex.org/W1755598144","https://openalex.org/W1767788337","https://openalex.org/W1979514837","https://openalex.org/W2048531653","https://openalex.org/W2056660085","https://openalex.org/W2056907916","https://openalex.org/W2079590017","https://openalex.org/W2102913701","https://openalex.org/W2136195851","https://openalex.org/W2156717879","https://openalex.org/W2163491591","https://openalex.org/W2168838065","https://openalex.org/W2502658919","https://openalex.org/W2613232875","https://openalex.org/W2790625403","https://openalex.org/W2953181121","https://openalex.org/W2964142859","https://openalex.org/W2971026710","https://openalex.org/W2999746846","https://openalex.org/W3020616315","https://openalex.org/W3099158806","https://openalex.org/W4205381461","https://openalex.org/W4211008735","https://openalex.org/W4281813636","https://openalex.org/W4289866538","https://openalex.org/W4291713239","https://openalex.org/W6605485969"],"related_works":["https://openalex.org/W1003283331","https://openalex.org/W2371740287","https://openalex.org/W2406556739","https://openalex.org/W2351171547","https://openalex.org/W4242370757","https://openalex.org/W2110065340","https://openalex.org/W906795786","https://openalex.org/W4379390531","https://openalex.org/W4386123427","https://openalex.org/W2011795509"],"abstract_inverted_index":{"Proving":[0],"the":[1,87,120,155,185],"equivalence":[2,31,101],"between":[3],"SQL":[4,60,100,186],"queries":[5,16,90],"is":[6,117],"a":[7,37,51,98,111,138,142],"fundamental":[8],"problem":[9],"in":[10,44,50,55,74,110,189],"database":[11],"research.":[12],"Existing":[13],"solvers":[14,70],"model":[15,58],"using":[17,149],"algebraic":[18,53],"representations":[19,23],"and":[20,65,133,191],"convert":[21],"such":[22,62],"into":[24],"first-order":[25],"logic":[26],"formulas":[27,129],"so":[28],"that":[29,91,145,169],"query":[30,181],"can":[32,92,106,146],"be":[33,93,147],"verified":[34],"by":[35],"solving":[36],"satisfiability":[38],"problem.":[39],"The":[40],"main":[41],"challenge":[42],"lies":[43],"\"unbounded":[45],"summations\",":[46],"which":[47,84,105,124,201],"appear":[48],"commonly":[49],"query's":[52],"representation":[54],"order":[56],"to":[57,118,136,141,159],"common":[59],"features,":[61],"as":[63,165],"projection":[64],"aggregate":[66],"functions.":[67],"Unfortunately,":[68],"existing":[69,150,204],"handle":[71,107,160],"unbounded":[72,108,131,167],"summations":[73,109],"an":[75],"ad-hoc":[76],"manner":[77],"based":[78],"on":[79],"heuristics":[80],"or":[81],"syntax":[82],"comparison,":[83],"severely":[85],"limits":[86],"set":[88],"of":[89,122,199],"supported.":[94],"This":[95],"paper":[96],"develops":[97],"new":[99],"prover":[102],"called":[103],"SQLSolver,":[104],"principled":[112],"way.":[113],"Our":[114],"key":[115],"insight":[116],"use":[119],"theory":[121,158],"LIA^*,":[123],"extends":[125],"linear":[126],"integer":[127],"arithmetic":[128],"with":[130,178],"sums":[132],"provides":[134],"algorithms":[135],"translate":[137],"LIA^*":[139,157],"formula":[140,144],"LIA":[143],"decided":[148],"SMT":[151],"solvers.":[152],"We":[153,175],"augment":[154],"basic":[156],"several":[161],"complex":[162],"scenarios":[163],"(such":[164],"nested":[166],"summations)":[168],"arise":[170],"from":[171,184],"modeling":[172],"real-world":[173],"queries.":[174],"evaluate":[176],"SQLSolver":[177,194],"359":[179],"equivalent":[180],"pairs":[182,198],"derived":[183],"rewrite":[187],"rules":[188],"Calcite":[190],"Spark":[192],"SQL.":[193],"successfully":[195],"proves":[196],"346":[197],"them,":[200],"significantly":[202],"outperforms":[203],"provers.":[205]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":9},{"year":2024,"cited_by_count":3}],"updated_date":"2026-07-31T08:31:51.225901","created_date":"2025-10-10T00:00:00"}