{"id":"https://openalex.org/W3031536178","doi":"https://doi.org/10.1145/3375395.3387647","title":"New Results for the Complexity of Resilience for Binary Conjunctive Queries with Self-Joins","display_name":"New Results for the Complexity of Resilience for Binary Conjunctive Queries with Self-Joins","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3031536178","doi":"https://doi.org/10.1145/3375395.3387647","mag":"3031536178"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3375395.3387647","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1907.01129","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5088824742","display_name":"Cibele Freire","orcid":null},"institutions":[{"id":"https://openalex.org/I189731429","display_name":"Wellesley College","ror":"https://ror.org/01srpnj69","country_code":"US","type":"education","lineage":["https://openalex.org/I189731429"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Cibele Freire","raw_affiliation_strings":["Wellesley College, Wellesley, MA, USA"],"affiliations":[{"raw_affiliation_string":"Wellesley College, Wellesley, MA, USA","institution_ids":["https://openalex.org/I189731429"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086781628","display_name":"Wolfgang Gatterbauer","orcid":"https://orcid.org/0000-0002-9614-0504"},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wolfgang Gatterbauer","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053065200","display_name":"Neil Immerman","orcid":"https://orcid.org/0000-0001-6609-5952"},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Neil Immerman","raw_affiliation_strings":["University of Massachusetts Amherst, Amherst, MA, USA"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5019048013","display_name":"Alexandra Meliou","orcid":"https://orcid.org/0000-0001-7346-6002"},"institutions":[{"id":"https://openalex.org/I24603500","display_name":"University of Massachusetts Amherst","ror":"https://ror.org/0072zz521","country_code":"US","type":"education","lineage":["https://openalex.org/I24603500"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alexandra Meliou","raw_affiliation_strings":["University of Massachusetts Amherst, Amherst, MA, USA"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.196,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.998768,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":84,"max":85},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9982,"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.9982,"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.9922,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9881,"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/conjunctive-query","display_name":"Conjunctive query","score":0.7178761},{"id":"https://openalex.org/keywords/resilience","display_name":"Resilience","score":0.4398484},{"id":"https://openalex.org/keywords/boolean-conjunctive-query","display_name":"Boolean conjunctive query","score":0.42571855}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8041419},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.73062617},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.7178761},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5638872},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.56066024},{"id":"https://openalex.org/C48372109","wikidata":"https://www.wikidata.org/wiki/Q3913","display_name":"Binary number","level":2,"score":0.4915255},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.46599352},{"id":"https://openalex.org/C2779585090","wikidata":"https://www.wikidata.org/wiki/Q3457762","display_name":"Resilience (materials science)","level":2,"score":0.4398484},{"id":"https://openalex.org/C24755975","wikidata":"https://www.wikidata.org/wiki/Q4943354","display_name":"Boolean conjunctive query","level":5,"score":0.42571855},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.30396804},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2566382},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.25254476},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.20307463},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.19626206},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.15125158},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1288839},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.109333634},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10020667},{"id":"https://openalex.org/C94375191","wikidata":"https://www.wikidata.org/wiki/Q11205","display_name":"Arithmetic","level":1,"score":0.09058419},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C97355855","wikidata":"https://www.wikidata.org/wiki/Q11473","display_name":"Thermodynamics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3375395.3387647","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},{"is_oa":true,"landing_page_url":"https://arxiv.org/abs/1907.01129","pdf_url":"https://arxiv.org/pdf/1907.01129","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://arxiv.org/abs/1907.01129","pdf_url":"https://arxiv.org/pdf/1907.01129","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},"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":35,"referenced_works":["https://openalex.org/W1552694902","https://openalex.org/W1754725800","https://openalex.org/W1862784933","https://openalex.org/W1979514837","https://openalex.org/W1983178058","https://openalex.org/W1985223393","https://openalex.org/W1988391412","https://openalex.org/W1994353670","https://openalex.org/W2022171653","https://openalex.org/W2024834471","https://openalex.org/W2036118854","https://openalex.org/W2040293060","https://openalex.org/W2048372226","https://openalex.org/W2111112637","https://openalex.org/W2113582770","https://openalex.org/W2115010808","https://openalex.org/W2117854600","https://openalex.org/W2124026371","https://openalex.org/W2124299249","https://openalex.org/W2125399128","https://openalex.org/W2127795772","https://openalex.org/W2133328255","https://openalex.org/W2165727725","https://openalex.org/W2166709576","https://openalex.org/W2167541073","https://openalex.org/W2293299776","https://openalex.org/W2293940046","https://openalex.org/W2294059532","https://openalex.org/W2604387475","https://openalex.org/W2621561345","https://openalex.org/W2798666526","https://openalex.org/W2953951489","https://openalex.org/W3105181319","https://openalex.org/W4206031975","https://openalex.org/W4246215794"],"related_works":["https://openalex.org/W4282550487","https://openalex.org/W3170346938","https://openalex.org/W3107700780","https://openalex.org/W3092785261","https://openalex.org/W3047081115","https://openalex.org/W2949144621","https://openalex.org/W2910962884","https://openalex.org/W2340557151","https://openalex.org/W1967430536","https://openalex.org/W1505212787"],"abstract_inverted_index":{"The":[0],"resilience":[1,66],"of":[2,13,47,64,84,105,115,159,170],"a":[3,7,39,78],"Boolean":[4],"query":[5,29],"on":[6,61],"database":[8],"is":[9,107],"the":[10,21,28,42,62,65,82,95,99,103,113,157,167,177],"minimum":[11],"number":[12],"tuples":[14],"that":[15,161],"need":[16],"to":[17,26,33,110,129,139,142],"be":[18],"deleted":[19],"from":[20],"input":[22],"tables":[23],"in":[24,94,98,147,176],"order":[25],"make":[27],"false.":[30],"A":[31],"solution":[32,40],"this":[34,54],"problem":[35,46,67,158],"immediately":[36],"translates":[37],"into":[38,156],"for":[41,68,81],"more":[43,74],"widely":[44],"known":[45],"deletion":[48],"propagation":[49],"with":[50,71,88,174],"source-side":[51],"effects.":[52],"In":[53],"paper,":[55],"we":[56,76,162],"give":[57,135],"several":[58],"novel":[59,136],"results":[60,152],"hardness":[63],"conjunctive":[69,172],"queries":[70,87,173],"self-joins,":[72],"and,":[73],"specifically,":[75],"present":[77],"dichotomy":[79],"result":[80],"class":[83],"single-self-join":[85],"binary":[86],"exactly":[89],"two":[90],"repeated":[91],"relations":[92],"occurring":[93],"query.":[96],"Unlike":[97],"self-join":[100],"free":[101],"case,":[102],"concept":[104],"triad":[106],"not":[108],"enough":[109],"fully":[111],"characterize":[112],"complexity":[114],"resilience.":[116],"We":[117,133],"identify":[118],"new":[119],"structural":[120],"properties,":[121],"namely":[122],"chains,":[123],"confluences":[124],"and":[125],"permutations,":[126],"which":[127],"lead":[128],"various":[130],"NP-hardness":[131],"results.":[132],"also":[134],"involved":[137],"reductions":[138],"network":[140],"flow":[141],"show":[143],"certain":[144],"cases":[145],"are":[146],"P.":[148],"Although":[149],"restricted,":[150],"our":[151],"provide":[153],"important":[154],"insights":[155],"self-joins":[160,175],"hope":[163],"can":[164],"help":[165],"solve":[166],"general":[168],"case":[169],"all":[171],"future.":[178]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3031536178","counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2025-01-06T23:38:22.874325","created_date":"2020-06-05"}