{"id":"https://openalex.org/W2045054164","doi":"https://doi.org/10.1145/1093382.1093385","title":"Database repairing using updates","display_name":"Database repairing using updates","publication_year":2005,"publication_date":"2005-09-01","ids":{"openalex":"https://openalex.org/W2045054164","doi":"https://doi.org/10.1145/1093382.1093385","mag":"2045054164"},"language":"en","primary_location":{"id":"doi:10.1145/1093382.1093385","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1093382.1093385","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://orbi.umons.ac.be/bitstream/20.500.12907/29314/1/wijsen-2005-1-ACMTODS.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5058654623","display_name":"Jef Wijsen","orcid":"https://orcid.org/0000-0001-8216-273X"},"institutions":[{"id":"https://openalex.org/I130929987","display_name":"University of Mons","ror":"https://ror.org/02qnnz951","country_code":"BE","type":"education","lineage":["https://openalex.org/I130929987"]}],"countries":["BE"],"is_corresponding":true,"raw_author_name":"Jef Wijsen","raw_affiliation_strings":["Universit\u00e9 de Mons-Hainaut, Mons, Belgium"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e9 de Mons-Hainaut, Mons, Belgium","institution_ids":["https://openalex.org/I130929987"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5058654623"],"corresponding_institution_ids":["https://openalex.org/I130929987"],"apc_list":null,"apc_paid":null,"fwci":9.8552,"has_fulltext":true,"cited_by_count":213,"citation_normalized_percentile":{"value":0.98132041,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":100},"biblio":{"volume":"30","issue":"3","first_page":"722","last_page":"768"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9993000030517578,"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"}},"topics":[{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9993000030517578,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9990000128746033,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9961000084877014,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8590232133865356},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7964978218078613},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6213544607162476},{"id":"https://openalex.org/keywords/intersection","display_name":"Intersection (aeronautics)","score":0.6121749877929688},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5724977850914001},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.5356471538543701},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.533892810344696},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5313692092895508},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.504414439201355},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.49583157896995544},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.47895175218582153},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.4607279300689697},{"id":"https://openalex.org/keywords/boolean-conjunctive-query","display_name":"Boolean conjunctive query","score":0.4215841591358185},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4112013876438141},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3989229202270508},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3213963806629181},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.22932732105255127},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2287968397140503},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.17750224471092224},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.17612889409065247},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.118033766746521},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.10326159000396729},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08948752284049988},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.0712478756904602}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8590232133865356},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7964978218078613},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6213544607162476},{"id":"https://openalex.org/C64543145","wikidata":"https://www.wikidata.org/wiki/Q162942","display_name":"Intersection (aeronautics)","level":2,"score":0.6121749877929688},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5724977850914001},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.5356471538543701},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.533892810344696},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5313692092895508},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.504414439201355},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49583157896995544},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.47895175218582153},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.4607279300689697},{"id":"https://openalex.org/C24755975","wikidata":"https://www.wikidata.org/wiki/Q4943354","display_name":"Boolean conjunctive query","level":5,"score":0.4215841591358185},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4112013876438141},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3989229202270508},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3213963806629181},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.22932732105255127},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2287968397140503},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.17750224471092224},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.17612889409065247},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.118033766746521},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10326159000396729},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08948752284049988},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0712478756904602},{"id":"https://openalex.org/C146978453","wikidata":"https://www.wikidata.org/wiki/Q3798668","display_name":"Aerospace engineering","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1093382.1093385","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1093382.1093385","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:orbi.umons.ac.be:20.500.12907/29314","is_oa":true,"landing_page_url":"https://orbi.umons.ac.be/handle/20.500.12907/29314","pdf_url":"https://orbi.umons.ac.be/bitstream/20.500.12907/29314/1/wijsen-2005-1-ACMTODS.pdf","source":{"id":"https://openalex.org/S7407055454","display_name":"ORBi UMONS","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":"ACM Transactions on Database Systems, 30 (3), 722-768 (2005-01-01)","raw_type":"peer reviewed"}],"best_oa_location":{"id":"pmh:oai:orbi.umons.ac.be:20.500.12907/29314","is_oa":true,"landing_page_url":"https://orbi.umons.ac.be/handle/20.500.12907/29314","pdf_url":"https://orbi.umons.ac.be/bitstream/20.500.12907/29314/1/wijsen-2005-1-ACMTODS.pdf","source":{"id":"https://openalex.org/S7407055454","display_name":"ORBi UMONS","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":"ACM Transactions on Database Systems, 30 (3), 722-768 (2005-01-01)","raw_type":"peer reviewed"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2045054164.pdf","grobid_xml":"https://content.openalex.org/works/W2045054164.grobid-xml"},"referenced_works_count":42,"referenced_works":["https://openalex.org/W23310411","https://openalex.org/W1487020114","https://openalex.org/W1515520450","https://openalex.org/W1521263018","https://openalex.org/W1541476024","https://openalex.org/W1551808273","https://openalex.org/W1558832481","https://openalex.org/W1585735613","https://openalex.org/W1591856724","https://openalex.org/W1594873272","https://openalex.org/W1596327935","https://openalex.org/W1603863631","https://openalex.org/W1604958321","https://openalex.org/W1607762176","https://openalex.org/W1657296557","https://openalex.org/W1838030265","https://openalex.org/W1854613159","https://openalex.org/W1882711135","https://openalex.org/W2028222220","https://openalex.org/W2062796915","https://openalex.org/W2063356069","https://openalex.org/W2077518845","https://openalex.org/W2091243508","https://openalex.org/W2096289723","https://openalex.org/W2096671561","https://openalex.org/W2102729564","https://openalex.org/W2108658789","https://openalex.org/W2112965492","https://openalex.org/W2117503258","https://openalex.org/W2122278639","https://openalex.org/W2125336114","https://openalex.org/W2144272839","https://openalex.org/W2159686758","https://openalex.org/W2162634476","https://openalex.org/W2163600218","https://openalex.org/W2171288778","https://openalex.org/W2178708778","https://openalex.org/W2616737215","https://openalex.org/W2963177041","https://openalex.org/W4252098605","https://openalex.org/W4300625362","https://openalex.org/W4372267129"],"related_works":["https://openalex.org/W1483388050","https://openalex.org/W2137382312","https://openalex.org/W2004485491","https://openalex.org/W4298325446","https://openalex.org/W1492449180","https://openalex.org/W2964058024","https://openalex.org/W2156776134","https://openalex.org/W1558141798","https://openalex.org/W3125756434","https://openalex.org/W2387635197"],"abstract_inverted_index":{"Repairing":[0],"a":[1,10,22,37,70,78,93,114,122],"database":[2,6,23,116],"means":[3],"bringing":[4],"the":[5,33,42,45,53,58,97,104,110,127,134],"in":[7,27,85,103],"accordance":[8],"with":[9],"given":[11],"set":[12],"of":[13,44,52,65,112,124,136,163],"integrity":[14],"constraints":[15],"by":[16],"applying":[17],"some":[18,160],"minimal":[19],"change.":[20],"If":[21],"can":[24],"be":[25],"repaired":[26,50],"more":[28],"than":[29],"one":[30],"way,":[31],"then":[32],"consistent":[34,101,119],"answer":[35],"to":[36,61,121],"query":[38,46,130,145],"is":[39,83,109,150],"defined":[40],"as":[41,77],"intersection":[43],"answers":[47,120],"on":[48],"all":[49],"versions":[51],"database.Earlier":[54],"approaches":[55],"have":[56],"confined":[57],"repair":[59,79],"work":[60],"deletions":[62],"and":[63,141,147],"insertions":[64],"entire":[66],"tuples.":[67],"We":[68,132],"propose":[69],"theoretical":[71],"framework":[72],"that":[73,86,117],"also":[74,158],"covers":[75],"updates":[76],"primitive.":[80],"Update-based":[81],"repairing":[82],"interesting":[84],"it":[87],"allows":[88],"rectifying":[89],"an":[90],"error":[91],"within":[92],"tuple":[94],"without":[95,126],"deleting":[96],"tuple,":[98],"thereby":[99],"preserving":[100],"values":[102],"tuple.":[105],"Another":[106],"novel":[107],"idea":[108],"construct":[111],"nucleus:":[113],"single":[115],"yields":[118],"class":[123],"queries,":[125],"need":[128],"for":[129,138],"rewriting.":[131],"show":[133,159],"construction":[135],"nuclei":[137,149],"full":[139],"dependencies":[140],"conjunctive":[142],"queries.":[143],"Consistent":[144],"answering":[146],"constructing":[148],"generally":[151],"intractable":[152],"under":[153],"update-based":[154],"repairing.":[155],"Nevertheless,":[156],"we":[157],"tractable":[161],"cases":[162],"practical":[164],"interest.":[165]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":8},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":7},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":10},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":11},{"year":2016,"cited_by_count":13},{"year":2015,"cited_by_count":11},{"year":2014,"cited_by_count":10},{"year":2013,"cited_by_count":17},{"year":2012,"cited_by_count":19}],"updated_date":"2026-05-09T13:55:54.758798","created_date":"2025-10-10T00:00:00"}