{"id":"https://openalex.org/W2613232875","doi":"https://doi.org/10.1145/3035918.3058728","title":"Demonstration of the Cosette Automated SQL Prover","display_name":"Demonstration of the Cosette Automated SQL Prover","publication_year":2017,"publication_date":"2017-05-09","ids":{"openalex":"https://openalex.org/W2613232875","doi":"https://doi.org/10.1145/3035918.3058728","mag":"2613232875"},"language":"en","primary_location":{"id":"doi:10.1145/3035918.3058728","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3035918.3058728","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3058728&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://dl.acm.org/ft_gateway.cfm?id=3058728&type=pdf","any_repository_has_fulltext":null},"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, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100714110","display_name":"Daniel Li","orcid":"https://orcid.org/0000-0002-7536-3418"},"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":"Daniel Li","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100367825","display_name":"Chenglong Wang","orcid":"https://orcid.org/0000-0003-2391-0923"},"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":"Chenglong Wang","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","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, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","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, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","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":1.5348,"has_fulltext":true,"cited_by_count":27,"citation_normalized_percentile":{"value":0.85021702,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1591","last_page":"1594"},"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.9991999864578247,"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.9991999864578247,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9984999895095825,"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"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9782000184059143,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"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/computer-science","display_name":"Computer science","score":0.8266067504882812},{"id":"https://openalex.org/keywords/gas-meter-prover","display_name":"Gas meter prover","score":0.6399345397949219},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6286451816558838},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5655984282493591},{"id":"https://openalex.org/keywords/automated-theorem-proving","display_name":"Automated theorem proving","score":0.5541669726371765},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.42294031381607056},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.42233479022979736},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.42010048031806946},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.41587570309638977},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.4139735698699951},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33998191356658936},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.21440407633781433},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.09819236397743225},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.09512510895729065}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8266067504882812},{"id":"https://openalex.org/C159718280","wikidata":"https://www.wikidata.org/wiki/Q5526353","display_name":"Gas meter prover","level":3,"score":0.6399345397949219},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6286451816558838},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5655984282493591},{"id":"https://openalex.org/C206880738","wikidata":"https://www.wikidata.org/wiki/Q431667","display_name":"Automated theorem proving","level":2,"score":0.5541669726371765},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.42294031381607056},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.42233479022979736},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.42010048031806946},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.41587570309638977},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.4139735698699951},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33998191356658936},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.21440407633781433},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09819236397743225},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.09512510895729065},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C108710211","wikidata":"https://www.wikidata.org/wiki/Q11538","display_name":"Mathematical proof","level":2,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3035918.3058728","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3035918.3058728","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3058728&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3035918.3058728","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3035918.3058728","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3058728&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2017 ACM International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1515542360","display_name":null,"funder_award_id":"CNS-1563788","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G3785592558","display_name":null,"funder_award_id":"FA8750-16-2-0032","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G4451656","display_name":"BIGDATA: Collaborative Research: F: Holistic Optimization of Data-Driven Applications","funder_award_id":"1546083","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4713059963","display_name":null,"funder_award_id":"FA8750","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G4806205923","display_name":null,"funder_award_id":"IIS-1546083","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G5974677782","display_name":null,"funder_award_id":"DE-SC0016260","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G620229259","display_name":null,"funder_award_id":"1614738","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G656365904","display_name":null,"funder_award_id":"1535565","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6947076996","display_name":null,"funder_award_id":"FA8750-16-2-003","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G7722544557","display_name":"NeTS: Medium: Collaborative Research: Language and Hardware Primitives for Programming the Data Plane in High Speed Networks","funder_award_id":"1563788","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8429701143","display_name":null,"funder_award_id":"FA8750-16-2-0032","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","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/F4320306084","display_name":"U.S. Department of Energy","ror":"https://ror.org/01bj3aw27"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2613232875.pdf","grobid_xml":"https://content.openalex.org/works/W2613232875.grobid-xml"},"referenced_works_count":16,"referenced_works":["https://openalex.org/W1558832481","https://openalex.org/W1582686279","https://openalex.org/W1970165929","https://openalex.org/W2008116177","https://openalex.org/W2056660085","https://openalex.org/W2057156093","https://openalex.org/W2122406210","https://openalex.org/W2138474070","https://openalex.org/W2144829796","https://openalex.org/W2165674271","https://openalex.org/W2293299776","https://openalex.org/W2339920159","https://openalex.org/W2503947316","https://openalex.org/W2584709123","https://openalex.org/W4244028915","https://openalex.org/W6732730294"],"related_works":["https://openalex.org/W4246350535","https://openalex.org/W4238632608","https://openalex.org/W3083050876","https://openalex.org/W1875958796","https://openalex.org/W1780472831","https://openalex.org/W1976200187","https://openalex.org/W1561644379","https://openalex.org/W2969536091","https://openalex.org/W783488073","https://openalex.org/W2584449131"],"abstract_inverted_index":{"In":[0],"this":[1],"demonstration,":[2],"we":[3],"showcase":[4,98],"COSETTE,":[5,131],"the":[6,12,35,50,57,72,117,138,144,148,150,155,160,165],"first":[7],"automated":[8,26,126],"prover":[9],"for":[10],"determining":[11],"equivalences":[13,36],"of":[14,37,41,59,84,93,102,125,140],"SQL":[15],"queries.":[16],"Despite":[17],"theoretical":[18],"limitations,":[19],"COSETTE":[20,53,79,133,161],"leverages":[21],"recent":[22],"advances":[23],"in":[24],"both":[25],"constraint":[27],"solving":[28],"and":[29,121,158],"interactive":[30,123],"theorem":[31],"proving":[32,104],"to":[33,136,143],"decide":[34],"a":[38,91,105],"wide":[39],"range":[40],"real":[42,86],"world":[43,87],"queries,":[44,74],"including":[45,90],"complex":[46],"rewrite":[47,107],"rules":[48],"from":[49,109,116],"database":[51,66],"literature.":[52],"can":[54,80,152],"also":[55],"validate":[56],"inequality":[58],"queries":[60,89],"by":[61,130,162],"finding":[62,113],"counter":[63,82,114],"examples,":[64],"i.e.,":[65],"instances":[67],"which,":[68],"when":[69],"executed":[70],"on":[71],"two":[73],"will":[75],"return":[76],"different":[77],"results.":[78],"find":[81],"examples":[83,115],"many":[85],"inequivalent":[88],"number":[92],"real-world":[94],"optimizer":[95,119],"bugs.":[96],"We":[97],"three":[99,156],"representative":[100],"applications":[101],"COSETTE:":[103],"query":[106],"rule":[108],"magic":[110],"set":[111],"rewrite,":[112],"infamous":[118],"bug,":[120],"an":[122,168],"visualization":[124],"grading":[127],"results":[128],"powered":[129],"where":[132],"is":[134],"used":[135],"check":[137],"equivalence":[139],"students'":[141],"answers":[142],"standard":[145],"solution.":[146],"For":[147],"demo,":[149],"audience":[151],"experience":[153],"through":[154],"applications,":[157],"explore":[159],"interacting":[163],"with":[164],"tool":[166],"using":[167],"easy-to-use":[169],"web":[170],"interface.":[171]},"counts_by_year":[{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}