{"id":"https://openalex.org/W4379135644","doi":"https://doi.org/10.1145/3584372.3588653","title":"Synthesizing Nested Relational Queries from Implicit Specifications","display_name":"Synthesizing Nested Relational Queries from Implicit Specifications","publication_year":2023,"publication_date":"2023-06-02","ids":{"openalex":"https://openalex.org/W4379135644","doi":"https://doi.org/10.1145/3584372.3588653"},"language":"en","primary_location":{"id":"doi:10.1145/3584372.3588653","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3584372.3588653","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-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/A5037774973","display_name":"Michael Benedikt","orcid":"https://orcid.org/0000-0003-2964-0880"},"institutions":[{"id":"https://openalex.org/I40120149","display_name":"University of Oxford","ror":"https://ror.org/052gg0110","country_code":"GB","type":"education","lineage":["https://openalex.org/I40120149"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Michael Benedikt","raw_affiliation_strings":["University of Oxford, Oxford, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Oxford, Oxford, United Kingdom","institution_ids":["https://openalex.org/I40120149"]}]},{"author_position":"middle","author":{"id":null,"display_name":"C\u00e9cilia Pradic","orcid":"https://orcid.org/0000-0003-2964-0880"},"institutions":[{"id":"https://openalex.org/I39586589","display_name":"Swansea University","ror":"https://ror.org/053fq8t95","country_code":"GB","type":"education","lineage":["https://openalex.org/I39586589"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"C\u00e9cilia Pradic","raw_affiliation_strings":["University of Swansea, Swansea, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Swansea, Swansea, United Kingdom","institution_ids":["https://openalex.org/I39586589"]}]},{"author_position":"last","author":{"id":null,"display_name":"Christoph Wernhard","orcid":"https://orcid.org/0000-0003-2964-0880"},"institutions":[{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Christoph Wernhard","raw_affiliation_strings":["University of Potsdam, Potsdam, Germany"],"affiliations":[{"raw_affiliation_string":"University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I176453806"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5037774973"],"corresponding_institution_ids":["https://openalex.org/I40120149"],"apc_list":null,"apc_paid":null,"fwci":0.5962,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.67387647,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"33","last_page":"45"},"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.9997000098228455,"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.9997000098228455,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9944000244140625,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.7055943012237549},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.6285864114761353},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5631449818611145},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.5313157439231873},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.515509843826294},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.48542651534080505},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.46541404724121094},{"id":"https://openalex.org/keywords/codds-theorem","display_name":"Codd's theorem","score":0.4533500075340271},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.333943247795105},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.22515514492988586}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7055943012237549},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.6285864114761353},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5631449818611145},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.5313157439231873},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.515509843826294},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.48542651534080505},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.46541404724121094},{"id":"https://openalex.org/C16739119","wikidata":"https://www.wikidata.org/wiki/Q5139948","display_name":"Codd's theorem","level":5,"score":0.4533500075340271},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.333943247795105},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.22515514492988586}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3584372.3588653","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3584372.3588653","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1399413881","display_name":null,"funder_award_id":"EP/T022124/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G5106512922","display_name":null,"funder_award_id":"Deutsche Forschungsgemeinschaft (DFG","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G585225138","display_name":"QUINTON -- QUerying and INTegrating Over Nested data","funder_award_id":"EP/T022124/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G6240107832","display_name":"Beweisstrukturen: Beweise als formale Objekte und als Datenstrukturen","funder_award_id":"457292495","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G762232396","display_name":null,"funder_award_id":"Project","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"}],"funders":[{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"},{"id":"https://openalex.org/F4320334627","display_name":"Engineering and Physical Sciences Research Council","ror":"https://ror.org/0439y7842"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W195752099","https://openalex.org/W997000086","https://openalex.org/W1512074225","https://openalex.org/W1554618854","https://openalex.org/W1968753703","https://openalex.org/W1972122408","https://openalex.org/W1972514879","https://openalex.org/W1998141358","https://openalex.org/W2000487974","https://openalex.org/W2004201635","https://openalex.org/W2057072590","https://openalex.org/W2063770561","https://openalex.org/W2066684585","https://openalex.org/W2074669964","https://openalex.org/W2080197492","https://openalex.org/W2100220081","https://openalex.org/W2114633883","https://openalex.org/W2153036557","https://openalex.org/W3100186693","https://openalex.org/W3114122494","https://openalex.org/W4206913075","https://openalex.org/W4250399921","https://openalex.org/W4282550487","https://openalex.org/W4301040220","https://openalex.org/W4312248044","https://openalex.org/W6600634118","https://openalex.org/W6806571184","https://openalex.org/W6831939039"],"related_works":["https://openalex.org/W2089781037","https://openalex.org/W2085988990","https://openalex.org/W2056340443","https://openalex.org/W2005835473","https://openalex.org/W2095263945","https://openalex.org/W2243465518","https://openalex.org/W1516375613","https://openalex.org/W1969375478","https://openalex.org/W2613697899","https://openalex.org/W2049150522"],"abstract_inverted_index":{"Derived":[0],"datasets":[1,17],"can":[2,77,87,122,139],"be":[3,88,123],"defined":[4],"implicitly":[5],"or":[6],"explicitly.":[7],"An":[8],"implicit":[9,79,95,112],"definition":[10,37,61],"(of":[11],"dataset":[12],"O":[13,39,67],"in":[14,40,97,115,129,146],"terms":[15,41,147],"of":[16,38,42,48,71,143,148],"I)":[18],"is":[19,34,62,158],"a":[20,35,63,92,98,136,152],"logical":[21],"specification":[22,50],"involving":[23],"the":[24,29,49,104,116,130,156,161],"source":[25],"data":[26,31],"I":[27,53],"and":[28],"interface":[30],"O.":[32,56],"It":[33],"valid":[36],"I,":[43],"if":[44],"any":[45],"two":[46],"models":[47],"agreeing":[51],"on":[52,55],"agree":[54],"In":[57],"contrast,":[58],"an":[59],"explicit":[60,82,127],"query":[64,157],"that":[65,75,155],"produces":[66],"from":[68],"I.":[69],"Variants":[70],"Beth's":[72],"theorem":[73],"state":[74],"one":[76],"convert":[78],"definitions":[80,128],"to":[81,126],"ones.":[83],"Further,":[84],"this":[85],"conversion":[86],"done":[89],"effectively":[90,124,140],"given":[91,114,151],"proof":[93,100,153],"witnessing":[94,154],"definability":[96],"suitable":[99],"system.":[101],"We":[102],"prove":[103],"analogous":[105],"effective":[106],"implicit-to-explicit":[107],"result":[108],"for":[109,119],"nested":[110,120,131],"relations:":[111],"definitions,":[113],"natural":[117],"logic":[118],"relations,":[121],"converted":[125],"relational":[132],"calculus":[133],"(NRC).":[134],"As":[135],"consequence,":[137],"we":[138],"extract":[141],"rewritings":[142],"NRC":[144,149],"queries":[145],"views,":[150],"determined":[159],"by":[160],"views.":[162]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}