{"id":"https://openalex.org/W2953951489","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/W2953951489","doi":"https://doi.org/10.1145/3375395.3387647","mag":"2953951489"},"language":"en","primary_location":{"id":"doi:10.1145/3375395.3387647","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3375395.3387647","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref","datacite"],"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":true,"raw_author_name":"Cibele Freire","raw_affiliation_strings":["Wellesley College, Wellesley, MA, USA","Wellesley College, Wellesley, MA USA"],"affiliations":[{"raw_affiliation_string":"Wellesley College, Wellesley, MA, USA","institution_ids":["https://openalex.org/I189731429"]},{"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","Northeastern University , Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]},{"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","Univ. of Massachusetts Amherst, Amherst, MA, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]},{"raw_affiliation_string":"Univ. of Massachusetts Amherst, Amherst, MA, USA#TAB#","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","Univ. of Massachusetts Amherst, Amherst, MA, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Massachusetts Amherst, Amherst, MA, USA","institution_ids":["https://openalex.org/I24603500"]},{"raw_affiliation_string":"Univ. of Massachusetts Amherst, Amherst, MA, USA#TAB#","institution_ids":["https://openalex.org/I24603500"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5088824742"],"corresponding_institution_ids":["https://openalex.org/I189731429"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.00613457,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"271","last_page":"284"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9969000220298767,"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"}},"topics":[{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9969000220298767,"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/T12072","display_name":"Machine Learning and Algorithms","score":0.9955000281333923,"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/T12029","display_name":"DNA and Biological Computing","score":0.9922999739646912,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.796427845954895},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.6810998916625977},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6354023218154907},{"id":"https://openalex.org/keywords/arity","display_name":"Arity","score":0.583849310874939},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5147961974143982},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4965739846229553},{"id":"https://openalex.org/keywords/binary-relation","display_name":"Binary relation","score":0.4568397104740143},{"id":"https://openalex.org/keywords/binary-number","display_name":"Binary number","score":0.45354902744293213},{"id":"https://openalex.org/keywords/resilience","display_name":"Resilience (materials science)","score":0.436473548412323},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.312224805355072},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.3103366792201996},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.2795898914337158},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2099764347076416},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.16187170147895813},{"id":"https://openalex.org/keywords/arithmetic","display_name":"Arithmetic","score":0.09428220987319946}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.796427845954895},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.6810998916625977},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6354023218154907},{"id":"https://openalex.org/C110546421","wikidata":"https://www.wikidata.org/wiki/Q1315869","display_name":"Arity","level":2,"score":0.583849310874939},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5147961974143982},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4965739846229553},{"id":"https://openalex.org/C65180967","wikidata":"https://www.wikidata.org/wiki/Q130901","display_name":"Binary relation","level":2,"score":0.4568397104740143},{"id":"https://openalex.org/C48372109","wikidata":"https://www.wikidata.org/wiki/Q3913","display_name":"Binary number","level":2,"score":0.45354902744293213},{"id":"https://openalex.org/C2779585090","wikidata":"https://www.wikidata.org/wiki/Q3457762","display_name":"Resilience (materials science)","level":2,"score":0.436473548412323},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.312224805355072},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.3103366792201996},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.2795898914337158},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2099764347076416},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.16187170147895813},{"id":"https://openalex.org/C94375191","wikidata":"https://www.wikidata.org/wiki/Q11205","display_name":"Arithmetic","level":1,"score":0.09428220987319946},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C97355855","wikidata":"https://www.wikidata.org/wiki/Q11473","display_name":"Thermodynamics","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/3375395.3387647","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3375395.3387647","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1907.01129","is_oa":true,"landing_page_url":"http://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":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"mag:2953951489","is_oa":true,"landing_page_url":"https://arxiv.org/pdf/1907.01129","pdf_url":null,"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":"arXiv (Cornell University)","raw_type":null},{"id":"doi:10.48550/arxiv.1907.01129","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.1907.01129","pdf_url":null,"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":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1907.01129","is_oa":true,"landing_page_url":"http://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":[],"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":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2953951489.pdf","grobid_xml":"https://content.openalex.org/works/W2953951489.grobid-xml"},"referenced_works_count":39,"referenced_works":["https://openalex.org/W1552694902","https://openalex.org/W1595443289","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/W2047182010","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/W2137819283","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/W2951251320","https://openalex.org/W2963412070","https://openalex.org/W3013082216","https://openalex.org/W3105181319","https://openalex.org/W4246215794"],"related_works":["https://openalex.org/W1754725800","https://openalex.org/W2914595612","https://openalex.org/W3166830313","https://openalex.org/W2165864074","https://openalex.org/W1939132863","https://openalex.org/W2527061537","https://openalex.org/W3047081115","https://openalex.org/W3170665465","https://openalex.org/W3160706494","https://openalex.org/W2026745535","https://openalex.org/W2401514316","https://openalex.org/W2120436863","https://openalex.org/W12202036","https://openalex.org/W2763683134","https://openalex.org/W2127795772","https://openalex.org/W2779119908","https://openalex.org/W2110051204","https://openalex.org/W2150813055","https://openalex.org/W1974688422","https://openalex.org/W2752966494"],"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]},"counts_by_year":[],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}