{"id":"https://openalex.org/W2948516666","doi":"https://doi.org/10.1145/3294052.3319703","title":"Counting Database Repairs under Primary Keys Revisited","display_name":"Counting Database Repairs under Primary Keys Revisited","publication_year":2019,"publication_date":"2019-06-17","ids":{"openalex":"https://openalex.org/W2948516666","doi":"https://doi.org/10.1145/3294052.3319703","mag":"2948516666"},"language":"en","primary_location":{"id":"doi:10.1145/3294052.3319703","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3294052.3319703","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 38th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://hdl.handle.net/2434/953304","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5066005299","display_name":"Marco Calautti","orcid":"https://orcid.org/0000-0003-0921-4040"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Marco Calautti","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069002162","display_name":"Marco Console","orcid":"https://orcid.org/0009-0004-5526-019X"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Marco Console","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067962748","display_name":"Andr\u00e9as Pieris","orcid":"https://orcid.org/0000-0003-4779-3469"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Andreas Pieris","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5066005299"],"corresponding_institution_ids":["https://openalex.org/I98677209"],"apc_list":null,"apc_paid":null,"fwci":2.0036,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.87151552,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"104","last_page":"118"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9983000159263611,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9983000159263611,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9980000257492065,"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/T11719","display_name":"Data Quality and Management","score":0.996999979019165,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.658096969127655},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.6199578642845154},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5666247010231018},{"id":"https://openalex.org/keywords/counting-problem","display_name":"Counting problem","score":0.5146825909614563},{"id":"https://openalex.org/keywords/time-complexity","display_name":"Time complexity","score":0.4970894157886505},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.48597821593284607},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.43858909606933594},{"id":"https://openalex.org/keywords/turing","display_name":"Turing","score":0.4259496331214905},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38281404972076416},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.22111952304840088},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.17849576473236084},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.16367504000663757}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.658096969127655},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.6199578642845154},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5666247010231018},{"id":"https://openalex.org/C16592021","wikidata":"https://www.wikidata.org/wiki/Q5177154","display_name":"Counting problem","level":2,"score":0.5146825909614563},{"id":"https://openalex.org/C311688","wikidata":"https://www.wikidata.org/wiki/Q2393193","display_name":"Time complexity","level":2,"score":0.4970894157886505},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.48597821593284607},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.43858909606933594},{"id":"https://openalex.org/C9870796","wikidata":"https://www.wikidata.org/wiki/Q490481","display_name":"Turing","level":2,"score":0.4259496331214905},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38281404972076416},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.22111952304840088},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.17849576473236084},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.16367504000663757},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":6,"locations":[{"id":"doi:10.1145/3294052.3319703","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3294052.3319703","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 38th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:air.unimi.it:2434/953304","is_oa":true,"landing_page_url":"https://hdl.handle.net/2434/953304","pdf_url":null,"source":{"id":"https://openalex.org/S4306400516","display_name":"Archivio Istituzionale della Ricerca (Universita Degli Studi Di Milano)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I189158943","host_organization_name":"University of Milan","host_organization_lineage":["https://openalex.org/I189158943"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/bookPart"},{"id":"pmh:oai:iris.uniroma1.it:11573/1501968","is_oa":true,"landing_page_url":"https://hdl.handle.net/11573/1501968","pdf_url":null,"source":{"id":"https://openalex.org/S4377196107","display_name":"IRIS Research product catalog (Sapienza University of Rome)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:iris.unitn.it:11572/260167","is_oa":false,"landing_page_url":"http://hdl.handle.net/11572/260167","pdf_url":null,"source":{"id":"https://openalex.org/S4306401913","display_name":"Institutional Research Information System (Universit\u00e0 degli Studi di Trento)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I193223587","host_organization_name":"University of Trento","host_organization_lineage":["https://openalex.org/I193223587"],"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":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:pure.ed.ac.uk:openaire/e578c5ef-739e-4f2a-b1a8-e24c517373ce","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/e578c5ef-739e-4f2a-b1a8-e24c517373ce","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Calautti, M, Console, M & Pieris, A 2019, Counting Database Repairs under Primary Keys Revisited. in Proceedings of the 38th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems. New York, pp. 104-118, ACM SIGMOD/PODS International Conference on Management of Data (SIGMOD 2019), Amsterdam, Netherlands, 30/06/19. https://doi.org/10.1145/3294052.3319703","raw_type":"contributionToPeriodical"},{"id":"pmh:oai:pure.ed.ac.uk:publications/e578c5ef-739e-4f2a-b1a8-e24c517373ce","is_oa":false,"landing_page_url":"http://hdl.handle.net/20.500.11820/e578c5ef-739e-4f2a-b1a8-e24c517373ce","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""}],"best_oa_location":{"id":"pmh:oai:air.unimi.it:2434/953304","is_oa":true,"landing_page_url":"https://hdl.handle.net/2434/953304","pdf_url":null,"source":{"id":"https://openalex.org/S4306400516","display_name":"Archivio Istituzionale della Ricerca (Universita Degli Studi Di Milano)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I189158943","host_organization_name":"University of Milan","host_organization_lineage":["https://openalex.org/I189158943"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/bookPart"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G2663852107","display_name":"Efficient Querying of Inconsistent Data","funder_award_id":"EP/S003800/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G3829625337","display_name":null,"funder_award_id":"S003800","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G53695486","display_name":null,"funder_award_id":"EP/N023056/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G5458651130","display_name":null,"funder_award_id":"M025268","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G5546818348","display_name":null,"funder_award_id":"EP/S003800/1 EQUID","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G8016896243","display_name":null,"funder_award_id":"EP/M025268/ VADA","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G8400180575","display_name":null,"funder_award_id":"EP/M025268/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G8891597062","display_name":null,"funder_award_id":"EP/M025268/","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"}],"funders":[{"id":"https://openalex.org/F4320334627","display_name":"Engineering and Physical Sciences Research Council","ror":"https://ror.org/0439y7842"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W987035227","https://openalex.org/W1527197079","https://openalex.org/W1556751392","https://openalex.org/W1782691830","https://openalex.org/W1984509356","https://openalex.org/W1998076865","https://openalex.org/W2077518845","https://openalex.org/W2103775650","https://openalex.org/W2109725035","https://openalex.org/W2137407595","https://openalex.org/W2154368191","https://openalex.org/W2405916311","https://openalex.org/W2799040891","https://openalex.org/W4391177866"],"related_works":["https://openalex.org/W4225920954","https://openalex.org/W4308265696","https://openalex.org/W3217593839","https://openalex.org/W1968050632","https://openalex.org/W2914595612","https://openalex.org/W3047081115","https://openalex.org/W2965645196","https://openalex.org/W3203600176","https://openalex.org/W3170346938","https://openalex.org/W2767824041"],"abstract_inverted_index":{"Consistent":[0],"query":[1],"answering":[2],"(CQA)":[3],"aims":[4],"to":[5,45,146,154,178],"deliver":[6],"meaningful":[7],"answers":[8,17],"when":[9],"queries":[10,63],"are":[11,26,97,100],"evaluated":[12],"over":[13],"inconsistent":[14,33],"databases.":[15],"Such":[16],"must":[18],"be":[19,104],"certainly":[20],"true":[21],"in":[22,41,73,90,115],"all":[23],"repairs,":[24],"which":[25,102,147],"consistent":[27],"databases":[28],"whose":[29],"difference":[30],"from":[31],"the":[32,47,53,91,185,189,198],"one":[34],"is":[35,44,71,132,160,177],"somehow":[36],"minimal.":[37],"An":[38],"interesting":[39],"task":[40],"this":[42,175],"context":[43],"count":[46],"number":[48,190],"of":[49,93,144,165,174,187,191],"repairs":[50,192],"that":[51,69,99,156,196],"entail":[52,197],"query.":[54,199],"This":[55],"problem":[56,159,186],"has":[57,86],"been":[58,87],"already":[59,88],"studied":[60],"for":[61,109,142,162,184],"conjunctive":[62],"and":[64],"primary":[65,194],"keys;":[66],"we":[67,134,151],"know":[68],"it":[70,85],"#P-complete":[72],"data":[74],"complexity":[75,139],"under":[76,111,117,167,193],"polynomial-time":[77],"Turing":[78],"reductions":[79,121],"(a.k.a.":[80,122],"Cook":[81],"reductions).":[82,124],"However,":[83],"as":[84],"observed":[89],"literature":[92],"counting":[94,188],"complexity,":[95],"there":[96],"problems":[98],"''hard-to-count-easy-to-decide'',":[101],"cannot":[103],"complete":[105,161],"(under":[106],"reasonable":[107],"assumptions)":[108],"#P":[110,145,166],"weaker":[112],"reductions,":[113],"and,":[114],"particular,":[116],"standard":[118],"many-one":[119,168],"logspace":[120,169],"parsimonious":[123],"For":[125],"such":[126,157,180],"''hard-to-count-easy-to-decide''":[127],"problems,":[128],"a":[129,158,163,181],"crucial":[130],"question":[131],"whether":[133],"can":[135],"determine":[136],"their":[137],"exact":[138],"by":[140],"looking":[141],"subclasses":[143],"they":[148],"belong.":[149],"Ideally,":[150],"would":[152],"like":[153],"show":[155],"subclass":[164],"reductions.":[170],"The":[171],"main":[172],"goal":[173],"work":[176],"perform":[179],"refined":[182],"analysis":[183],"keys":[195]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":4},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":1}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2019-06-14T00:00:00"}