{"id":"https://openalex.org/W2503947316","doi":"https://doi.org/10.1145/3062341.3062348","title":"HoTTSQL: proving query rewrites with univalent SQL semantics","display_name":"HoTTSQL: proving query rewrites with univalent SQL semantics","publication_year":2017,"publication_date":"2017-06-14","ids":{"openalex":"https://openalex.org/W2503947316","doi":"https://doi.org/10.1145/3062341.3062348","mag":"2503947316"},"language":"en","primary_location":{"id":"doi:10.1145/3062341.3062348","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3062341.3062348","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3062348&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 38th ACM SIGPLAN Conference on Programming Language Design and Implementation","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"http://dl.acm.org/ft_gateway.cfm?id=3062348&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":false,"raw_author_name":"Shumo Chu","raw_affiliation_strings":["University of Washington, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Washington, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052717111","display_name":"Konstantin Weitz","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":false,"raw_author_name":"Konstantin Weitz","raw_affiliation_strings":["University of Washington, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Washington, 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, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Washington, 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, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Washington, USA","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":8.0928,"has_fulltext":true,"cited_by_count":59,"citation_normalized_percentile":{"value":0.98477052,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"510","last_page":"524"},"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9909999966621399,"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/T11106","display_name":"Data Management and Algorithms","score":0.9884999990463257,"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.8112139105796814},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6679519414901733},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6424999237060547},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5885863900184631},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5825703740119934},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.5507916212081909},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5466828346252441},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.47658225893974304},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.45862051844596863},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.4221835732460022},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.398715078830719},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.35440582036972046},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.32661595940589905},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3071574866771698},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.21644243597984314},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.14224186539649963}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8112139105796814},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6679519414901733},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6424999237060547},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5885863900184631},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5825703740119934},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5507916212081909},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5466828346252441},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.47658225893974304},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.45862051844596863},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.4221835732460022},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.398715078830719},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35440582036972046},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.32661595940589905},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3071574866771698},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21644243597984314},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.14224186539649963},{"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/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.1145/3062341.3062348","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3062341.3062348","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3062348&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 38th ACM SIGPLAN Conference on Programming Language Design and Implementation","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3062341.3062348","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3062341.3062348","pdf_url":"http://dl.acm.org/ft_gateway.cfm?id=3062348&type=pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 38th ACM SIGPLAN Conference on Programming Language Design and Implementation","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.75}],"awards":[{"id":"https://openalex.org/G1952784096","display_name":"CAREER: Generating Application-Specific Database Management Systems","funder_award_id":"1651489","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2551027135","display_name":"USING VERIFIED LIFTING TO OPTIMIZE LEGACY STENCIL CODES","funder_award_id":"DESC0016260","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"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/G620229259","display_name":"III: Small: Scalable Probabilistic Inference for Large Knowledge Bases","funder_award_id":"1614738","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G656365904","display_name":"AitF: FULL: Query Processing with Optimal Communication Cost","funder_award_id":"1535565","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"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"}],"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/F4320319907","display_name":"Alberta Innovates - Technology Futures","ror":"https://ror.org/00ynafe15"},{"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/W2503947316.pdf","grobid_xml":"https://content.openalex.org/works/W2503947316.grobid-xml"},"referenced_works_count":69,"referenced_works":["https://openalex.org/W79051208","https://openalex.org/W135863099","https://openalex.org/W144096106","https://openalex.org/W151059316","https://openalex.org/W1434079718","https://openalex.org/W1524668325","https://openalex.org/W1558832481","https://openalex.org/W1563590781","https://openalex.org/W1570025952","https://openalex.org/W1582686279","https://openalex.org/W1583095677","https://openalex.org/W1633805695","https://openalex.org/W1965547751","https://openalex.org/W1975808766","https://openalex.org/W1979514837","https://openalex.org/W1988504473","https://openalex.org/W1992810975","https://openalex.org/W1996032017","https://openalex.org/W2020949660","https://openalex.org/W2023035194","https://openalex.org/W2027548946","https://openalex.org/W2036240164","https://openalex.org/W2048531653","https://openalex.org/W2056660085","https://openalex.org/W2072764742","https://openalex.org/W2073742357","https://openalex.org/W2087290458","https://openalex.org/W2090438868","https://openalex.org/W2102387332","https://openalex.org/W2107823752","https://openalex.org/W2114883263","https://openalex.org/W2120172501","https://openalex.org/W2122406210","https://openalex.org/W2126004201","https://openalex.org/W2130872776","https://openalex.org/W2136195851","https://openalex.org/W2136310957","https://openalex.org/W2138474070","https://openalex.org/W2139875914","https://openalex.org/W2144829796","https://openalex.org/W2153131284","https://openalex.org/W2156717879","https://openalex.org/W2158141386","https://openalex.org/W2162621793","https://openalex.org/W2163491591","https://openalex.org/W2165467455","https://openalex.org/W2165674271","https://openalex.org/W2167814583","https://openalex.org/W2185907055","https://openalex.org/W2200545814","https://openalex.org/W2255433971","https://openalex.org/W2293299776","https://openalex.org/W2339920159","https://openalex.org/W2503947316","https://openalex.org/W2561675875","https://openalex.org/W2568721247","https://openalex.org/W2584709123","https://openalex.org/W2963560792","https://openalex.org/W4206031975","https://openalex.org/W4244028915","https://openalex.org/W4250587856","https://openalex.org/W6605485969","https://openalex.org/W6631393269","https://openalex.org/W6633513001","https://openalex.org/W6633828322","https://openalex.org/W6635043461","https://openalex.org/W6675450584","https://openalex.org/W6678760027","https://openalex.org/W6732730294"],"related_works":["https://openalex.org/W1003283331","https://openalex.org/W2607400785","https://openalex.org/W2406556739","https://openalex.org/W2217632272","https://openalex.org/W2128834514","https://openalex.org/W3031390801","https://openalex.org/W4379390531","https://openalex.org/W2148814251","https://openalex.org/W2887264929","https://openalex.org/W3008396432"],"abstract_inverted_index":{"Every":[0],"database":[1,151],"system":[2],"contains":[3],"a":[4,16,46,75,141,196],"query":[5,9,13,32,160,179],"optimizer":[6],"that":[7,68,203],"performs":[8],"rewrites.":[10],"Unfortunately,":[11],"developing":[12],"optimizers":[14,161],"remains":[15],"highly":[17],"challenging":[18],"task.":[19],"Part":[20],"of":[21,31,78,88,136,144,166,201],"the":[22,26,52],"challenges":[23],"comes":[24],"from":[25,118,150],"intricacies":[27],"and":[28,95,107,138,158],"rich":[29],"features":[30,87],"languages,":[33],"which":[34,129],"makes":[35],"reasoning":[36],"about":[37],"rewrite":[38,62,146,168],"rules":[39,169],"difficult.":[40],"In":[41,176],"this":[42],"paper,":[43],"we":[44,112,184],"propose":[45],"machine-checkable":[47],"denotational":[48],"semantics":[49,67,83],"for":[50,56,59,193],"SQL,":[51,89,102],"de":[53],"facto":[54],"language":[55,80],"relational":[57],"database,":[58],"rigorously":[60],"validating":[61],"rules.":[63],"Unlike":[64],"previously":[65,173],"proposed":[66],"are":[69],"either":[70],"non-mechanized":[71],"or":[72],"only":[73,131],"cover":[74],"small":[76],"amount":[77],"SQL":[79,145,202],"features,":[81],"our":[82],"covers":[84],"all":[85],"major":[86],"including":[90,148],"bags,":[91],"correlated":[92],"subqueries,":[93],"aggregation,":[94],"indexes.":[96],"Our":[97],"mechanized":[98],"semantics,":[99],"called":[100],"HoTT":[101],"is":[103,181],"based":[104],"on":[105],"K-Relations":[106],"homotopy":[108],"type":[109],"theory,":[110],"where":[111],"denote":[113],"relations":[114],"as":[115],"mathematical":[116],"functions":[117],"tuples":[119],"to":[120],"univalent":[121],"types.":[122],"We":[123],"have":[124,139,170,185],"implemented":[125,186],"HoTTSQL":[126,192],"in":[127],"Coq,":[128],"takes":[130],"fewer":[132],"than":[133],"300":[134],"lines":[135],"code":[137],"proved":[140],"wide":[142],"range":[143],"rules,":[147],"those":[149],"research":[152],"literature":[153],"(e.g.,":[154,162],"magic":[155],"set":[156],"rewrites)":[157],"real-world":[159,206],"subquery":[163],"elimination).":[164],"Several":[165],"these":[167],"never":[171],"been":[172],"proven":[174],"correct.":[175],"addition,":[177],"while":[178],"equivalence":[180],"generally":[182],"undecidable,":[183],"an":[187],"automated":[188],"decision":[189],"procedure":[190],"using":[191],"conjunctive":[194],"queries:":[195],"well":[197],"studied":[198],"decidable":[199],"fragment":[200],"encompasses":[204],"many":[205],"queries.":[207]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":6},{"year":2020,"cited_by_count":10},{"year":2019,"cited_by_count":10},{"year":2018,"cited_by_count":8},{"year":2017,"cited_by_count":8},{"year":2016,"cited_by_count":1}],"updated_date":"2026-08-06T08:24:18.245995","created_date":"2025-10-10T00:00:00"}