{"id":"https://openalex.org/W2612661634","doi":"https://doi.org/10.1145/3034786.3056107","title":"Counting and Enumerating (Preferred) Database Repairs","display_name":"Counting and Enumerating (Preferred) Database Repairs","publication_year":2017,"publication_date":"2017-05-09","ids":{"openalex":"https://openalex.org/W2612661634","doi":"https://doi.org/10.1145/3034786.3056107","mag":"2612661634"},"language":"en","primary_location":{"id":"doi:10.1145/3034786.3056107","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3034786.3056107","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 36th 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/A5076186858","display_name":"Ester Livshits","orcid":"https://orcid.org/0000-0003-3485-9887"},"institutions":[{"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":true,"raw_author_name":"Ester Livshits","raw_affiliation_strings":["Technion -- Israel Institute of Technology, Haifa, Israel"],"affiliations":[{"raw_affiliation_string":"Technion -- Israel Institute of Technology, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5006706357","display_name":"Benny Kimelfeld","orcid":"https://orcid.org/0000-0002-7156-1572"},"institutions":[{"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 Institute of Technology, Haifa, Israel"],"affiliations":[{"raw_affiliation_string":"Technion -- Israel Institute of Technology, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5076186858"],"corresponding_institution_ids":["https://openalex.org/I174306211"],"apc_list":null,"apc_paid":null,"fwci":3.7663,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.93210506,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"289","last_page":"301"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"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/T11719","display_name":"Data Quality and Management","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"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.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.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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7040747404098511},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6485632658004761},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5650224089622498},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.5642337799072266},{"id":"https://openalex.org/keywords/ambiguity","display_name":"Ambiguity","score":0.5401661992073059},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.512626588344574},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.4843234121799469},{"id":"https://openalex.org/keywords/enumeration","display_name":"Enumeration","score":0.45446673035621643},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4357357323169708},{"id":"https://openalex.org/keywords/reliability","display_name":"Reliability (semiconductor)","score":0.416850209236145},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.38693422079086304},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.36181432008743286},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35411784052848816},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.23681050539016724},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2178637683391571},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15695971250534058},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.13926097750663757}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7040747404098511},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6485632658004761},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5650224089622498},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5642337799072266},{"id":"https://openalex.org/C2780522230","wikidata":"https://www.wikidata.org/wiki/Q1140419","display_name":"Ambiguity","level":2,"score":0.5401661992073059},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.512626588344574},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.4843234121799469},{"id":"https://openalex.org/C156340839","wikidata":"https://www.wikidata.org/wiki/Q2704791","display_name":"Enumeration","level":2,"score":0.45446673035621643},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4357357323169708},{"id":"https://openalex.org/C43214815","wikidata":"https://www.wikidata.org/wiki/Q7310987","display_name":"Reliability (semiconductor)","level":3,"score":0.416850209236145},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.38693422079086304},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36181432008743286},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35411784052848816},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.23681050539016724},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2178637683391571},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15695971250534058},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.13926097750663757},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3034786.3056107","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3034786.3056107","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 36th 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":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":38,"referenced_works":["https://openalex.org/W1504741831","https://openalex.org/W1545910533","https://openalex.org/W1565029141","https://openalex.org/W1967693793","https://openalex.org/W1969595233","https://openalex.org/W1972004026","https://openalex.org/W1978460233","https://openalex.org/W1985239372","https://openalex.org/W1998076865","https://openalex.org/W2007940874","https://openalex.org/W2012041962","https://openalex.org/W2012644520","https://openalex.org/W2021002502","https://openalex.org/W2028775537","https://openalex.org/W2036118854","https://openalex.org/W2038993620","https://openalex.org/W2045054164","https://openalex.org/W2066176625","https://openalex.org/W2077518845","https://openalex.org/W2078501237","https://openalex.org/W2081186682","https://openalex.org/W2082424685","https://openalex.org/W2092770599","https://openalex.org/W2098720114","https://openalex.org/W2103775650","https://openalex.org/W2109865382","https://openalex.org/W2116548113","https://openalex.org/W2129143099","https://openalex.org/W2133328255","https://openalex.org/W2153531471","https://openalex.org/W2163600218","https://openalex.org/W2165676867","https://openalex.org/W2168066775","https://openalex.org/W2172834723","https://openalex.org/W2301828863","https://openalex.org/W2399922604","https://openalex.org/W2405916311","https://openalex.org/W2440178963"],"related_works":["https://openalex.org/W2116767780","https://openalex.org/W165346131","https://openalex.org/W1594511838","https://openalex.org/W4285259755","https://openalex.org/W119841348","https://openalex.org/W2171948294","https://openalex.org/W2039445786","https://openalex.org/W2185054849","https://openalex.org/W316061934","https://openalex.org/W2936448214"],"abstract_inverted_index":{"In":[0,82],"the":[1,54,68,87,104,124,143,154],"traditional":[2],"sense,":[3],"a":[4,13,33],"subset":[5,15,107],"repair":[6,67],"of":[7,16,28,35,48,56,96,102,106,127,135,139],"an":[8],"inconsistent":[9],"database":[10,69],"refers":[11],"to":[12,31,61,66,89],"consistent":[14],"facts":[17,29],"(tuples)":[18],"that":[19,101,138],"is":[20,77,100,137],"maximal":[21],"under":[22],"set":[23,34],"containment.":[24],"Preferences":[25],"between":[26,156],"pairs":[27],"allow":[30],"distinguish":[32],"preferred":[36,80,110,144],"repairs":[37],"based":[38],"on":[39,153],"relative":[40],"reliability":[41],"(source":[42],"credibility,":[43],"extraction":[44],"quality,":[45],"recency,":[46],"etc.)":[47],"data":[49,121],"items.":[50],"Previous":[51],"studies":[52],"explored":[53],"problem":[55],"categoricity,":[57],"where":[58],"one":[59,79],"aims":[60],"determine":[62],"whether":[63,75],"preferences":[64],"suffice":[65],"unambiguously,":[70],"or":[71,167],"in":[72,120],"other":[73],"words,":[74],"there":[76],"precisely":[78],"repair.":[81],"this":[83],"paper":[84],"we":[85],"study":[86],"ability":[88],"quantify":[90],"ambiguity,":[91],"by":[92],"investigating":[93],"two":[94],"classes":[95],"problems.":[97],"The":[98,132],"first":[99],"counting":[103],"number":[105],"repairs,":[108,158],"both":[109],"(under":[111],"various":[112],"common":[113],"semantics)":[114],"and":[115],"traditional.":[116],"We":[117,146],"establish":[118],"dichotomies":[119],"complexity":[122],"for":[123,160],"entire":[125],"space":[126],"(sets":[128],"of)":[129],"functional":[130],"dependencies.":[131],"second":[133],"class":[134],"problems":[136],"enumerating":[140],"(i.e.,":[141],"generating)":[142],"repairs.":[145],"devise":[147],"enumeration":[148],"algorithms":[149],"with":[150],"efficiency":[151],"guarantees":[152],"delay":[155],"generated":[157],"even":[159],"constraints":[161],"represented":[162],"as":[163],"general":[164],"conflict":[165],"graphs":[166],"hypergraphs.":[168]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":1}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}