{"id":"https://openalex.org/W2942769268","doi":"https://doi.org/10.1145/3315507.3330202","title":"Mixing set and bag semantics","display_name":"Mixing set and bag semantics","publication_year":2019,"publication_date":"2019-06-07","ids":{"openalex":"https://openalex.org/W2942769268","doi":"https://doi.org/10.1145/3315507.3330202","mag":"2942769268"},"language":"en","primary_location":{"id":"doi:10.1145/3315507.3330202","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3315507.3330202","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th ACM SIGPLAN International Symposium on Database Programming Languages","raw_type":"proceedings-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1905.02069","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Wilmer Ricciotti","orcid":null},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Wilmer Ricciotti","raw_affiliation_strings":["University of Edinburgh, UK"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, UK","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"last","author":{"id":null,"display_name":"James Cheney","orcid":null},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]},{"id":"https://openalex.org/I125680101","display_name":"Turing Institute","ror":"https://ror.org/02x2mw849","country_code":"GB","type":"facility","lineage":["https://openalex.org/I125680101"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"James Cheney","raw_affiliation_strings":["University of Edinburgh, UK / Alan Turing Institute, UK"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, UK / Alan Turing Institute, UK","institution_ids":["https://openalex.org/I125680101","https://openalex.org/I98677209"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I98677209"],"apc_list":null,"apc_paid":null,"fwci":0.557,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.69273735,"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":"70","last_page":"73"},"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.9977999925613403,"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.9977999925613403,"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/T10126","display_name":"Logic, programming, and type systems","score":0.9955999851226807,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9951000213623047,"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/multiset","display_name":"Multiset","score":0.8151000142097473},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.597000002861023},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5710999965667725},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5195000171661377},{"id":"https://openalex.org/keywords/nesting","display_name":"Nesting (process)","score":0.4964999854564667},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.44769999384880066},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.4343000054359436},{"id":"https://openalex.org/keywords/constructive","display_name":"Constructive","score":0.42899999022483826}],"concepts":[{"id":"https://openalex.org/C2779623528","wikidata":"https://www.wikidata.org/wiki/Q864377","display_name":"Multiset","level":2,"score":0.8151000142097473},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.597000002861023},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5710999965667725},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.5242000222206116},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5195000171661377},{"id":"https://openalex.org/C2776937656","wikidata":"https://www.wikidata.org/wiki/Q2229669","display_name":"Nesting (process)","level":2,"score":0.4964999854564667},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.48989999294281006},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.44769999384880066},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.4343000054359436},{"id":"https://openalex.org/C2778701210","wikidata":"https://www.wikidata.org/wiki/Q28130034","display_name":"Constructive","level":3,"score":0.42899999022483826},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4262000024318695},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.38580000400543213},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.3779999911785126},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.3747999966144562},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.34700000286102295},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.33379998803138733},{"id":"https://openalex.org/C202854965","wikidata":"https://www.wikidata.org/wiki/Q3044470","display_name":"Constructive proof","level":2,"score":0.32109999656677246},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.3183000087738037},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.31189998984336853},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.31189998984336853},{"id":"https://openalex.org/C2777299769","wikidata":"https://www.wikidata.org/wiki/Q3707858","display_name":"Type (biology)","level":2,"score":0.29789999127388},{"id":"https://openalex.org/C138777275","wikidata":"https://www.wikidata.org/wiki/Q6884054","display_name":"Mixing (physics)","level":2,"score":0.29589998722076416},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2700999975204468},{"id":"https://openalex.org/C184264201","wikidata":"https://www.wikidata.org/wiki/Q21199","display_name":"Natural number","level":2,"score":0.26499998569488525},{"id":"https://openalex.org/C162392398","wikidata":"https://www.wikidata.org/wiki/Q272404","display_name":"Finite set","level":2,"score":0.25099998712539673},{"id":"https://openalex.org/C2780841128","wikidata":"https://www.wikidata.org/wiki/Q5073781","display_name":"Characterization (materials science)","level":2,"score":0.2502000033855438}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3315507.3330202","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3315507.3330202","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th ACM SIGPLAN International Symposium on Database Programming Languages","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1905.02069","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1905.02069","pdf_url":"https://arxiv.org/pdf/1905.02069","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":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"pmh:oai:pure.ed.ac.uk:openaire/42eac732-ee19-4102-9092-216d13753bba","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/42eac732-ee19-4102-9092-216d13753bba","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Ricciotti, W & Cheney, J 2019, Mixing set and bag semantics. in Proceedings of The 17th International Symposium on Database Programming Languages. New york , pp. 70-73, 17th International Symposium on Database Programming Languages, Phoenix, Arizona, United States, 23/06/19. https://doi.org/10.1145/3315507.3330202","raw_type":"contributionToPeriodical"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1905.02069","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1905.02069","pdf_url":"https://arxiv.org/pdf/1905.02069","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":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G3722112496","display_name":null,"funder_award_id":"682315","funder_id":"https://openalex.org/F4320338352","funder_display_name":"FP7 Ideas: European Research Council"}],"funders":[{"id":"https://openalex.org/F4320338352","display_name":"FP7 Ideas: European Research Council","ror":"https://ror.org/0472cxd90"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1513902353","https://openalex.org/W1521472623","https://openalex.org/W2007074710","https://openalex.org/W2025969711","https://openalex.org/W2033229728","https://openalex.org/W2059267851","https://openalex.org/W2088675571","https://openalex.org/W2100220081","https://openalex.org/W2130872776","https://openalex.org/W2942963474","https://openalex.org/W4299855426","https://openalex.org/W6785574799"],"related_works":[],"abstract_inverted_index":{"The":[0],"conservativity":[1,80],"theorem":[2],"for":[3,63,87,145],"nested":[4,188],"relational":[5,41],"calculus":[6,119],"implies":[7],"that":[8,89,171,181],"query":[9,22],"expressions":[10],"can":[11,49,162],"freely":[12],"use":[13],"nesting":[14],"and":[15,81,92,111,123,135,149,187,193],"unnesting,":[16],"yet":[17],"as":[18,20,100],"long":[19],"the":[21,72,77,109,182],"result":[23,61],"type":[24],"is":[25],"a":[26,55,118,139,155],"flat":[27,40,186],"relation,":[28],"these":[29],"capabilities":[30],"do":[31,172],"not":[32,84,173],"lead":[33],"to":[34,52,71,133,165,176,178],"an":[35,151,197],"increase":[36],"in":[37],"expressiveness":[38,184],"over":[39,65],"queries.":[42],"Moreover,":[43],"Wong":[44],"showed":[45],"how":[46],"such":[47,99,147],"queries":[48,64,88,158,189],"be":[50,163],"translated":[51,164],"SQL":[53],"via":[54],"constructive":[56],"rewriting":[57],"algorithm.":[58],"While":[59],"this":[60,105],"holds":[62],"either":[66],"set":[67,91,122,140,156,192],"or":[68,95],"multiset":[69,124,194],"semantics,":[70],"best":[73],"of":[74,79,141,154,157,185],"our":[75],"knowledge,":[76],"questions":[78],"ormalization":[82],"have":[83],"been":[85],"studied":[86],"mix":[90],"bag":[93],"collections,":[94],"provide":[96],"duplicate-elimination":[97],"operations":[98],"SQL's":[101],"SELECT":[102],"DISTINCT.":[103],"In":[104],"paper":[106],"we":[107,116],"formalize":[108],"problem,":[110],"present":[112,138],"partial":[113],"progress:":[114],"specifically,":[115],"introduce":[117],"with":[120,128,190],"both":[121],"collection":[125],"types,":[126],"along":[127],"natural":[129],"mappings":[130],"from":[131],"sets":[132],"bags":[134],"vice":[136],"versa,":[137],"valid":[142],"rewrite":[143],"rules":[144],"normalizing":[146],"queries,":[148],"give":[150],"inductive":[152],"characterization":[153],"whose":[159],"normal":[160],"forms":[161],"SQL.":[166],"We":[167],"also":[168],"consider":[169],"examples":[170],"appear":[174],"straightforward":[175],"translate":[177],"SQL,":[179],"illustrating":[180],"relative":[183],"mixed":[191],"semantics":[195],"remains":[196],"open":[198],"question.":[199]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2}],"updated_date":"2026-04-09T08:11:56.329763","created_date":"2019-05-09T00:00:00"}