{"id":"https://openalex.org/W2022110761","doi":"https://doi.org/10.1145/2463676.2463711","title":"Query containment in entity SQL","display_name":"Query containment in entity SQL","publication_year":2013,"publication_date":"2013-06-22","ids":{"openalex":"https://openalex.org/W2022110761","doi":"https://doi.org/10.1145/2463676.2463711","mag":"2022110761"},"language":"en","primary_location":{"id":"doi:10.1145/2463676.2463711","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463676.2463711","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://hdl.handle.net/2117/20268","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086321939","display_name":"Guillem Rull","orcid":null},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":true,"raw_author_name":"Guillem Rull","raw_affiliation_strings":["Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108676493","display_name":"Philip A. Bernstein","orcid":"https://orcid.org/0000-0001-5781-1558"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Philip A. Bernstein","raw_affiliation_strings":["Microsoft Research, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003504974","display_name":"Ivo Santos","orcid":"https://orcid.org/0000-0001-5148-0233"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]},{"id":"https://openalex.org/I4210087053","display_name":"Microsoft (Germany)","ror":"https://ror.org/001dd4s60","country_code":"DE","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210087053"]}],"countries":["DE","US"],"is_corresponding":false,"raw_author_name":"Ivo Garcia dos Santos","raw_affiliation_strings":["European Microsoft Innovation Center, Aachen, Germany","European Microsoft Innovation Center, , Aachen, Germany#TAB#"],"affiliations":[{"raw_affiliation_string":"European Microsoft Innovation Center, Aachen, Germany","institution_ids":["https://openalex.org/I4210087053"]},{"raw_affiliation_string":"European Microsoft Innovation Center, , Aachen, Germany#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006509575","display_name":"Yannis Katsis","orcid":"https://orcid.org/0000-0002-1733-6227"},"institutions":[{"id":"https://openalex.org/I36258959","display_name":"University of California, San Diego","ror":"https://ror.org/0168r3w48","country_code":"US","type":"education","lineage":["https://openalex.org/I36258959"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yannis Katsis","raw_affiliation_strings":["University of California, San Diego, La Jolla, CA, USA","University of California - San Diego, La Jolla, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California, San Diego, La Jolla, CA, USA","institution_ids":["https://openalex.org/I36258959"]},{"raw_affiliation_string":"University of California - San Diego, La Jolla, CA, USA","institution_ids":["https://openalex.org/I36258959"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109208641","display_name":"Sergey Melnik","orcid":null},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sergey Melnik","raw_affiliation_strings":["Google, Kirkland, WA, USA","Google, Kirkland, WA, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Google, Kirkland, WA, USA","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"Google, Kirkland, WA, USA#TAB#","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085687963","display_name":"Ernest Teniente","orcid":"https://orcid.org/0000-0001-8890-9638"},"institutions":[{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Ernest Teniente","raw_affiliation_strings":["Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya, Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5086321939"],"corresponding_institution_ids":["https://openalex.org/I9617848"],"apc_list":null,"apc_paid":null,"fwci":0.38,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.66046663,"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":"1169","last_page":"1172"},"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.9965000152587891,"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/T11106","display_name":"Data Management and Algorithms","score":0.9922999739646912,"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.8493612408638},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6093146204948425},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5386978983879089},{"id":"https://openalex.org/keywords/containment","display_name":"Containment (computer programming)","score":0.5145518183708191},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4770340621471405},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.42378705739974976},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.419118732213974},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.41748762130737305},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.36826062202453613},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.2911343574523926},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.28716909885406494}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8493612408638},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6093146204948425},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5386978983879089},{"id":"https://openalex.org/C2777019822","wikidata":"https://www.wikidata.org/wiki/Q390066","display_name":"Containment (computer programming)","level":2,"score":0.5145518183708191},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4770340621471405},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.42378705739974976},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.419118732213974},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.41748762130737305},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36826062202453613},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2911343574523926},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.28716909885406494},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"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/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2463676.2463711","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2463676.2463711","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:upcommons.upc.edu:2117/20268","is_oa":true,"landing_page_url":"https://hdl.handle.net/2117/20268","pdf_url":null,"source":{"id":"https://openalex.org/S4210207057","display_name":"QRU Quaderns de Recerca en Urbanisme","issn_l":"2014-9689","issn":["2014-9689","2385-6777"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310322448","host_organization_name":"Q71272178","host_organization_lineage":["https://openalex.org/P4310322448"],"host_organization_lineage_names":["Q71272178"],"type":"journal"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"Conference lecture"}],"best_oa_location":{"id":"pmh:oai:upcommons.upc.edu:2117/20268","is_oa":true,"landing_page_url":"https://hdl.handle.net/2117/20268","pdf_url":null,"source":{"id":"https://openalex.org/S4210207057","display_name":"QRU Quaderns de Recerca en Urbanisme","issn_l":"2014-9689","issn":["2014-9689","2385-6777"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310322448","host_organization_name":"Q71272178","host_organization_lineage":["https://openalex.org/P4310322448"],"host_organization_lineage_names":["Q71272178"],"type":"journal"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"Conference lecture"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1505230898","https://openalex.org/W1542052436","https://openalex.org/W1979514837","https://openalex.org/W2002711156","https://openalex.org/W2005032394","https://openalex.org/W2028864278","https://openalex.org/W2043283603","https://openalex.org/W2056660085","https://openalex.org/W2096470974","https://openalex.org/W2108930340","https://openalex.org/W2137382312","https://openalex.org/W2142005881","https://openalex.org/W2153670461","https://openalex.org/W6630086687"],"related_works":["https://openalex.org/W2383619981","https://openalex.org/W4390861444","https://openalex.org/W4206687279","https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W1639806124","https://openalex.org/W4366145086","https://openalex.org/W2902831276","https://openalex.org/W2540682188","https://openalex.org/W4385834214"],"abstract_inverted_index":{"We":[0],"describe":[1],"a":[2,9,102],"software":[3,96],"architecture":[4],"we":[5,84],"have":[6,55,70],"developed":[7],"for":[8,37],"constructive":[10],"containment":[11],"checker":[12],"of":[13,30,34,66],"Entity":[14,25,40],"SQL":[15],"queries":[16],"defined":[17],"over":[18],"extended":[19],"ER":[20],"schemas":[21],"expressed":[22],"in":[23,59,88,111],"Microsoft's":[24,38],"Data":[26],"Model.":[27],"Our":[28],"application":[29],"interest":[31],"is":[32],"compilation":[33],"object-to-relational":[35],"mappings":[36],"ADO.NET":[39],"Framework,":[41],"which":[42,54],"has":[43],"been":[44,56,72],"shipping":[45],"since":[46],"2007.":[47],"The":[48],"supported":[49],"language":[50],"includes":[51],"several":[52],"features":[53],"individually":[57],"addressed":[58,73],"the":[60,64,89,95],"past":[61],"but,":[62],"to":[63,93,101],"best":[65],"our":[67,109],"knowledge,":[68],"they":[69],"not":[71],"all":[74],"at":[75],"once":[76],"before.":[77],"Moreover,":[78],"when":[79],"embarking":[80],"on":[81,91,108],"an":[82],"implementation,":[83],"found":[85],"no":[86],"guidance":[87],"literature":[90],"how":[92],"modularize":[94],"or":[97],"apply":[98],"published":[99],"algorithms":[100],"commercially-supported":[103],"language.":[104],"This":[105],"paper":[106],"reports":[107],"experience":[110],"addressing":[112],"these":[113],"real-world":[114],"challenges.":[115]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2016,"cited_by_count":1}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2016-06-24T00:00:00"}