{"id":"https://openalex.org/W2021002502","doi":"https://doi.org/10.1145/2745754.2745762","title":"Dichotomies in the Complexity of Preferred Repairs","display_name":"Dichotomies in the Complexity of Preferred Repairs","publication_year":2015,"publication_date":"2015-05-20","ids":{"openalex":"https://openalex.org/W2021002502","doi":"https://doi.org/10.1145/2745754.2745762","mag":"2021002502"},"language":"en","primary_location":{"id":"doi:10.1145/2745754.2745762","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2745754.2745762","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 34th ACM SIGMOD-SIGACT-SIGAI  Symposium on Principles of Database Systems","raw_type":"proceedings-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/A5027117465","display_name":"Ronald Fagin","orcid":"https://orcid.org/0000-0002-7374-0347"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ronald Fagin","raw_affiliation_strings":["IBM Research - Almaden, San Jose, CA, USA"],"affiliations":[{"raw_affiliation_string":"IBM Research - Almaden, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006706357","display_name":"Benny Kimelfeld","orcid":"https://orcid.org/0000-0002-7156-1572"},"institutions":[{"id":"https://openalex.org/I458620863","display_name":"Mellanox Technologies (Israel)","ror":"https://ror.org/00gym2132","country_code":"IL","type":"company","lineage":["https://openalex.org/I4210088690","https://openalex.org/I458620863"]},{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Benny Kimelfeld","raw_affiliation_strings":["Technion, Israel and LogicBlox, Inc., Haifa, Israel","Technion, Israel and LogicBlox, Inc., Haifa, Israel#TAB#"],"affiliations":[{"raw_affiliation_string":"Technion, Israel and LogicBlox, Inc., Haifa, Israel","institution_ids":["https://openalex.org/I458620863"]},{"raw_affiliation_string":"Technion, Israel and LogicBlox, Inc., Haifa, Israel#TAB#","institution_ids":["https://openalex.org/I174306211"]}]},{"author_position":"last","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"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Phokion G. Kolaitis","raw_affiliation_strings":["UC Santa Cruz and IBM Research - Almaden, Santa Cruz, CA, USA"],"affiliations":[{"raw_affiliation_string":"UC Santa Cruz and IBM Research - Almaden, Santa Cruz, CA, USA","institution_ids":["https://openalex.org/I4210085935","https://openalex.org/I185103710"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5027117465"],"corresponding_institution_ids":["https://openalex.org/I4210085935"],"apc_list":null,"apc_paid":null,"fwci":6.04,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":{"value":0.9629375,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"3","last_page":"15"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9990000128746033,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9990000128746033,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9973000288009644,"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.9970999956130981,"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/computer-science","display_name":"Computer science","score":0.6886265277862549},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.6139951348304749},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5931009650230408},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.5669084787368774},{"id":"https://openalex.org/keywords/timestamp","display_name":"Timestamp","score":0.5074467062950134},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.45854002237319946},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.44249650835990906},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.34625348448753357},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3270280361175537},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.21154293417930603},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.14701056480407715}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6886265277862549},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.6139951348304749},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5931009650230408},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.5669084787368774},{"id":"https://openalex.org/C113954288","wikidata":"https://www.wikidata.org/wiki/Q186885","display_name":"Timestamp","level":2,"score":0.5074467062950134},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.45854002237319946},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.44249650835990906},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.34625348448753357},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3270280361175537},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.21154293417930603},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.14701056480407715},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2745754.2745762","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2745754.2745762","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 34th ACM SIGMOD-SIGACT-SIGAI  Symposium on Principles of Database Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1754725800","https://openalex.org/W1967693793","https://openalex.org/W1969595233","https://openalex.org/W1978460233","https://openalex.org/W1985239372","https://openalex.org/W1985581502","https://openalex.org/W1986891954","https://openalex.org/W1994353670","https://openalex.org/W2077518845","https://openalex.org/W2080137646","https://openalex.org/W2098720114","https://openalex.org/W2116548113","https://openalex.org/W2133328255","https://openalex.org/W2149799241","https://openalex.org/W2150339067"],"related_works":["https://openalex.org/W2039445786","https://openalex.org/W2185054849","https://openalex.org/W2884840983","https://openalex.org/W2361244046","https://openalex.org/W2007610702","https://openalex.org/W3177130241","https://openalex.org/W2582695666","https://openalex.org/W2201336784","https://openalex.org/W3111672439","https://openalex.org/W1504218574"],"abstract_inverted_index":{"The":[0,133],"framework":[1,40,129,138],"of":[2,17,53,130,136,149,156],"database":[3,20,24,152],"repairs":[4,58],"provides":[5],"a":[6,15,22,32,51,68,108,143,178,182,203],"principled":[7],"approach":[8],"to":[9,84,97,153],"managing":[10],"inconsistencies":[11],"in":[12,31,38,77,168],"databases.":[13],"Informally,":[14],"repair":[16,52,87,180,183],"an":[18,116,150],"inconsistence":[19],"is":[21,41,48,80,95,139,181,198,202,214],"consistent":[23],"that":[25,107,140,184,200],"differs":[26],"from":[27],"the":[28,42,49,54,128,165,169,172],"inconsistent":[29,151],"one":[30,86,92],"\"minimal":[33],"way.\"":[34],"A":[35],"fundamental":[36],"problem":[37],"this":[39,137,160,195],"repair-checking":[43,213],"problem:":[44],"given":[45],"two":[46],"instances,":[47],"second":[50],"first?":[55],"Here,":[56],"all":[57],"are":[59,65,74,174],"taken":[60],"into":[61],"account,":[62],"and":[63,82,125,208],"they":[64],"treated":[66],"on":[67,164],"par":[69],"with":[70,191],"each":[71],"other.":[72],"There":[73],"situations,":[75],"however,":[76],"which":[78],"it":[79,141,197],"natural":[81],"desired":[83],"prefer":[85],"over":[88,115],"another;":[89],"for":[90],"example,":[91],"data":[93],"source":[94],"regarded":[96],"be":[98,113,186],"more":[99,109],"reliable":[100],"than":[101],"another,":[102],"or":[103],"timestamp":[104],"information":[105],"implies":[106],"recent":[110],"fact":[111],"should":[112],"preferred":[114,131,157,192],"earlier":[117],"one.":[118],"Motivated":[119],"by":[120,188],"these":[121],"considerations,":[122],"Staworko,":[123],"Chomicki":[124],"Marcinkowski":[126],"introduced":[127],"repairs.":[132,158],"main":[134],"characteristic":[135],"uses":[142],"priority":[144],"relation":[145],"between":[146],"conflicting":[147],"facts":[148,190],"define":[154],"notions":[155],"In":[159,194],"paper":[161],"we":[162],"focus":[163],"globally-optimal":[166,179,212],"repairs,":[167],"case":[170],"where":[171,211],"constraints":[173],"functional":[175,209],"dependencies.":[176],"Intuitively,":[177],"cannot":[185],"improved":[187],"exchanging":[189],"facts.":[193],"setting,":[196],"known":[199],"there":[201],"fixed":[204],"schema":[205],"(i.e.,":[206],"signature":[207],"dependencies)":[210],"coNP-complete.":[215]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}