{"id":"https://openalex.org/W3202852140","doi":"https://doi.org/10.1145/3472391","title":"Bag Query Containment and Information Theory","display_name":"Bag Query Containment and Information Theory","publication_year":2021,"publication_date":"2021-09-28","ids":{"openalex":"https://openalex.org/W3202852140","doi":"https://doi.org/10.1145/3472391","mag":"3202852140"},"language":"en","primary_location":{"id":"doi:10.1145/3472391","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3472391","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"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,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-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/A5034538466","display_name":"Mahmoud Abo Khamis","orcid":"https://orcid.org/0000-0003-3894-6494"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Mahmoud Abo Khamis","raw_affiliation_strings":["relationalAI, Berkeley, USA"],"affiliations":[{"raw_affiliation_string":"relationalAI, Berkeley, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041825861","display_name":"Phokion G. Kolaitis","orcid":"https://orcid.org/0000-0002-8407-8563"},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Phokion G. Kolaitis","raw_affiliation_strings":["University of California, Santa Cruz, USA"],"affiliations":[{"raw_affiliation_string":"University of California, Santa Cruz, USA","institution_ids":["https://openalex.org/I185103710"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062573204","display_name":"Hung Q. Ngo","orcid":"https://orcid.org/0000-0001-8246-8392"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hung Q. Ngo","raw_affiliation_strings":["relationalAI, Berkeley, USA"],"affiliations":[{"raw_affiliation_string":"relationalAI, Berkeley, USA","institution_ids":[]}]},{"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, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5034538466"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.9169,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.76413395,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"46","issue":"3","first_page":"1","last_page":"39"},"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.9986000061035156,"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.9986000061035156,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9976000189781189,"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.9976000189781189,"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/conjunctive-query","display_name":"Conjunctive query","score":0.8084679841995239},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7235418558120728},{"id":"https://openalex.org/keywords/containment","display_name":"Containment (computer programming)","score":0.6670101881027222},{"id":"https://openalex.org/keywords/undecidable-problem","display_name":"Undecidable problem","score":0.6555567979812622},{"id":"https://openalex.org/keywords/decidability","display_name":"Decidability","score":0.6490874290466309},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5445364713668823},{"id":"https://openalex.org/keywords/boolean-conjunctive-query","display_name":"Boolean conjunctive query","score":0.506639301776886},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4805174767971039},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4754312336444855},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3675386905670166},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.31334614753723145},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.28077465295791626},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2229604423046112},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.2177111804485321},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20833271741867065}],"concepts":[{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.8084679841995239},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7235418558120728},{"id":"https://openalex.org/C2777019822","wikidata":"https://www.wikidata.org/wiki/Q390066","display_name":"Containment (computer programming)","level":2,"score":0.6670101881027222},{"id":"https://openalex.org/C192034797","wikidata":"https://www.wikidata.org/wiki/Q3502995","display_name":"Undecidable problem","level":3,"score":0.6555567979812622},{"id":"https://openalex.org/C153269930","wikidata":"https://www.wikidata.org/wiki/Q430001","display_name":"Decidability","level":2,"score":0.6490874290466309},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5445364713668823},{"id":"https://openalex.org/C24755975","wikidata":"https://www.wikidata.org/wiki/Q4943354","display_name":"Boolean conjunctive query","level":5,"score":0.506639301776886},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4805174767971039},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4754312336444855},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3675386905670166},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.31334614753723145},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.28077465295791626},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2229604423046112},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.2177111804485321},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20833271741867065},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3472391","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3472391","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"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,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Reduced inequalities","score":0.6299999952316284,"id":"https://metadata.un.org/sdg/10"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W1515040589","https://openalex.org/W1643498562","https://openalex.org/W1979514837","https://openalex.org/W1981077868","https://openalex.org/W1983607987","https://openalex.org/W2013026082","https://openalex.org/W2028511489","https://openalex.org/W2028864278","https://openalex.org/W2031639195","https://openalex.org/W2038254774","https://openalex.org/W2041961594","https://openalex.org/W2048531653","https://openalex.org/W2056660085","https://openalex.org/W2062088877","https://openalex.org/W2104498537","https://openalex.org/W2113940092","https://openalex.org/W2140678653","https://openalex.org/W2147681281","https://openalex.org/W2156717879","https://openalex.org/W2158763191","https://openalex.org/W2161024633","https://openalex.org/W2163491591","https://openalex.org/W2169998163","https://openalex.org/W2171094216","https://openalex.org/W2563772499","https://openalex.org/W2585424461","https://openalex.org/W2624220145","https://openalex.org/W2948028381","https://openalex.org/W2962730682","https://openalex.org/W3030422499","https://openalex.org/W4293052541"],"related_works":["https://openalex.org/W2258149899","https://openalex.org/W4387929624","https://openalex.org/W3125756434","https://openalex.org/W1600092754","https://openalex.org/W1977383094","https://openalex.org/W2110954374","https://openalex.org/W2159977448","https://openalex.org/W2005570102","https://openalex.org/W2353549560","https://openalex.org/W1990513922"],"abstract_inverted_index":{"The":[0],"query":[1,43,61,107,113,139,153,161],"containment":[2,44,62,108,140,154],"problem":[3,8,14,45,141],"is":[4,15,22,33,49,98,114,162],"a":[5,34,93,132,166],"fundamental":[6],"algorithmic":[7],"in":[9,109],"data":[10],"management.":[11],"While":[12],"this":[13],"well":[16],"understood":[17,26],"under":[18,27,46,63,142,155],"set":[19],"semantics,":[20,157],"it":[21,32],"by":[23],"far":[24],"less":[25],"bag":[28,47,64,143,156],"semantics.":[29,65,144],"In":[30],"particular,":[31],"long-standing":[35],"open":[36],"question":[37],"whether":[38],"or":[39,123],"not":[40],"the":[41,59,78,90,102,111,137,159],"conjunctive":[42,60,106,138,152],"semantics":[48],"decidable.":[50],"We":[51],"unveil":[52],"tight":[53],"connections":[54,67],"between":[55],"information":[56,71,81,96],"theory":[57],"and":[58,164],"These":[66],"are":[68,74,121,125],"established":[69],"using":[70],"inequalities,":[72],"which":[73,110],"considered":[75],"to":[76,101],"be":[77],"laws":[79],"of":[80,92,95,105,136],"theory.":[82],"Our":[83,127],"first":[84],"main":[85,129],"result":[86,130],"asserts":[87],"that":[88],"deciding":[89],"validity":[91],"generalization":[94],"inequalities":[97],"many-one":[99],"equivalent":[100],"restricted":[103],"case":[104,135],"containing":[112,160],"acyclic;":[115],"thus,":[116],"either":[117],"both":[118,124],"these":[119],"problems":[120],"decidable":[122,134],"undecidable.":[126],"second":[128],"identifies":[131],"new":[133],"Specifically,":[145],"we":[146],"give":[147],"an":[148],"exponential-time":[149],"algorithm":[150],"for":[151],"provided":[158],"chordal":[163],"admits":[165],"simple":[167],"junction":[168],"tree.":[169]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}