{"id":"https://openalex.org/W4225140824","doi":"https://doi.org/10.1145/3527327","title":"Translating canonical SQL to imperative code in Coq","display_name":"Translating canonical SQL to imperative code in Coq","publication_year":2022,"publication_date":"2022-04-29","ids":{"openalex":"https://openalex.org/W4225140824","doi":"https://doi.org/10.1145/3527327"},"language":"en","primary_location":{"is_oa":true,"landing_page_url":"https://doi.org/10.1145/3527327","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3527327","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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true},"type":"article","type_crossref":"journal-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3527327","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5070335587","display_name":"V\u00e9ronique Benzaken","orcid":"https://orcid.org/0000-0002-1227-3327"},"institutions":[{"id":"https://openalex.org/I277688954","display_name":"Universit\u00e9 Paris-Saclay","ror":"https://ror.org/03xjwb503","country_code":"FR","type":"education","lineage":["https://openalex.org/I277688954"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"V\u00e9ronique Benzaken","raw_affiliation_strings":["LMF, France / Universit\u00e9 Paris-Saclay, France"],"affiliations":[{"raw_affiliation_string":"LMF, France / Universit\u00e9 Paris-Saclay, France","institution_ids":["https://openalex.org/I277688954"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014621785","display_name":"\u00c9velyne Contejean","orcid":"https://orcid.org/0000-0002-8195-7861"},"institutions":[{"id":"https://openalex.org/I1294671590","display_name":"Centre National de la Recherche Scientifique","ror":"https://ror.org/02feahw73","country_code":"FR","type":"government","lineage":["https://openalex.org/I1294671590"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"\u00c9velyne Contejean","raw_affiliation_strings":["CNRS - Centre National de la Recherche Scientifique (France)"],"affiliations":[{"raw_affiliation_string":"CNRS - Centre National de la Recherche Scientifique (France)","institution_ids":["https://openalex.org/I1294671590"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022020571","display_name":"Mohammed Houssem Eddine Hachmaoui","orcid":"https://orcid.org/0000-0001-8030-807X"},"institutions":[{"id":"https://openalex.org/I277688954","display_name":"Universit\u00e9 Paris-Saclay","ror":"https://ror.org/03xjwb503","country_code":"FR","type":"education","lineage":["https://openalex.org/I277688954"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Mohammed Houssem Hachmaoui","raw_affiliation_strings":["LMF, France / Universit\u00e9 Paris-Saclay, France"],"affiliations":[{"raw_affiliation_string":"LMF, France / Universit\u00e9 Paris-Saclay, France","institution_ids":["https://openalex.org/I277688954"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007051267","display_name":"Chantal Keller","orcid":"https://orcid.org/0000-0002-1282-0677"},"institutions":[{"id":"https://openalex.org/I277688954","display_name":"Universit\u00e9 Paris-Saclay","ror":"https://ror.org/03xjwb503","country_code":"FR","type":"education","lineage":["https://openalex.org/I277688954"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Chantal Keller","raw_affiliation_strings":["LMF, France / Universit\u00e9 Paris-Saclay, France"],"affiliations":[{"raw_affiliation_string":"LMF, France / Universit\u00e9 Paris-Saclay, France","institution_ids":["https://openalex.org/I277688954"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058012721","display_name":"Louis Mandel","orcid":"https://orcid.org/0000-0002-5291-6067"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Louis Mandel","raw_affiliation_strings":["IBM Watson Research Center (PO Box 704, Yorktown Heights, NY 10598 - United States)"],"affiliations":[{"raw_affiliation_string":"IBM Watson Research Center (PO Box 704, Yorktown Heights, NY 10598 - United States)","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079889502","display_name":"Avraham Shinnar","orcid":"https://orcid.org/0000-0001-6259-0016"},"institutions":[{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Avraham Shinnar","raw_affiliation_strings":["IBM Thomas J. Watson Research Center (1101 Kitchawan Road, Route 134, Yorktown Heights, N.Y. 10598 - United States)"],"affiliations":[{"raw_affiliation_string":"IBM Thomas J. Watson Research Center (1101 Kitchawan Road, Route 134, Yorktown Heights, N.Y. 10598 - United States)","institution_ids":["https://openalex.org/I4210114115"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5000705679","display_name":"J\u00e9r\u01d2me Sim\u00e8on","orcid":"https://orcid.org/0000-0002-8622-9716"},"institutions":[{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"J\u00e9r\u00f4me Sim\u00e9on","raw_affiliation_strings":["Docusign, USA","IBM Thomas J. Watson Research Center (1101 Kitchawan Road, Route 134, Yorktown Heights, N.Y. 10598 - United States)"],"affiliations":[{"raw_affiliation_string":"IBM Thomas J. Watson Research Center (1101 Kitchawan Road, Route 134, Yorktown Heights, N.Y. 10598 - United States)","institution_ids":["https://openalex.org/I4210114115"]},{"raw_affiliation_string":"Docusign, USA","institution_ids":[]}]}],"institution_assertions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"fulltext_origin":"pdf","cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":0,"max":60},"biblio":{"volume":"6","issue":"OOPSLA1","first_page":"1","last_page":"27"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9995,"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"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9995,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9987,"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/null","display_name":"Null (SQL)","score":0.5720755}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8390615},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.79278904},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7889815},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.5720755},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.5032415},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.42041487},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.41711938},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.20760775},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.15847135},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"is_oa":true,"landing_page_url":"https://doi.org/10.1145/3527327","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3527327","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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true},{"is_oa":true,"landing_page_url":"https://hal.science/hal-03876233","pdf_url":"https://hal.science/hal-03876233/document","source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":["Centre National de la Recherche Scientifique"],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true},{"is_oa":true,"landing_page_url":"https://hal.science/hal-03876233/file/oopsla22main-p90-p-849926a7a9-61675-final.pdf","pdf_url":"https://hal.science/hal-03876233/file/oopsla22main-p90-p-849926a7a9-61675-final.pdf","source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":["Centre National de la Recherche Scientifique"],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true},{"is_oa":true,"landing_page_url":"https://arxiv.org/abs/2203.08941","pdf_url":"https://arxiv.org/pdf/2203.08941","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":["Cornell University"],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false}],"best_oa_location":{"is_oa":true,"landing_page_url":"https://doi.org/10.1145/3527327","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3527327","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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.48,"display_name":"Quality education"}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":20,"referenced_works":["https://openalex.org/W1572478860","https://openalex.org/W1979093255","https://openalex.org/W2021347435","https://openalex.org/W2045522022","https://openalex.org/W2082841864","https://openalex.org/W2107605224","https://openalex.org/W2138474070","https://openalex.org/W2200355770","https://openalex.org/W2293299776","https://openalex.org/W2295409301","https://openalex.org/W2340838390","https://openalex.org/W2501699297","https://openalex.org/W2502658919","https://openalex.org/W2503947316","https://openalex.org/W2556472269","https://openalex.org/W2612045938","https://openalex.org/W2613500637","https://openalex.org/W2614913282","https://openalex.org/W2788164529","https://openalex.org/W2862455684"],"related_works":["https://openalex.org/W4320473518","https://openalex.org/W4312632526","https://openalex.org/W2573939812","https://openalex.org/W2389720334","https://openalex.org/W2382973082","https://openalex.org/W2155838697","https://openalex.org/W2086783690","https://openalex.org/W2056177422","https://openalex.org/W2056093042","https://openalex.org/W151494989"],"abstract_inverted_index":{"SQL":[0,39,52,83,107],"is":[1],"by":[2],"far":[3],"the":[4,36,46,85,124,131],"most":[5],"widely":[6],"used":[7,92],"and":[8,21,40,77,108],"implemented":[9],"query":[10,41,94],"language.":[11],"Yet,":[12],"on":[13],"some":[14],"key":[15],"features,":[16],"such":[17],"as":[18,135],"correlated":[19],"queries":[20,53],"NULL":[22],"value":[23],"semantics,":[24],"many":[25],"implementations":[26],"diverge":[27],"or":[28],"contain":[29],"bugs.":[30],"We":[31],"leverage":[32],"recent":[33],"advances":[34],"in":[35,55,71],"formalization":[37],"of":[38],"compilers":[42],"to":[43,59,84,105,128],"develop":[44,119],"DBCert,":[45],"first":[47],"mechanically":[48],"verified":[49],"compiler":[50],"from":[51,82,123],"written":[54],"a":[56,79,100,120],"canonical":[57],"form":[58],"imperative":[60,102],"code.":[61],"Building":[62],"DBCert":[63],"required":[64],"several":[65,112],"new":[66],"contributions":[67],"which":[68,89,109],"are":[69],"described":[70],"this":[72],"paper.":[73],"First,":[74],"we":[75,97,118],"specify":[76],"mechanize":[78],"complete":[80],"translation":[81,122],"Nested":[86],"Relational":[87],"Algebra":[88],"can":[90,110],"be":[91],"for":[93],"optimization.":[95],"Second,":[96],"define":[98],"Imp,":[99,129],"small":[101],"language":[103],"sufficient":[104],"express":[106],"target":[111],"execution":[113],"languages":[114],"including":[115],"JavaScript.":[116],"Finally,":[117],"mechanized":[121],"nested":[125,132],"relational":[126,133],"algebra":[127],"using":[130],"calculus":[134],"an":[136],"intermediate":[137],"step.":[138]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4225140824","counts_by_year":[],"updated_date":"2024-12-09T02:31:46.041412","created_date":"2022-05-01"}
