A variety of integrity constraints have been studied for data cleaning. While these constraints
can detect the presence of errors, they fall short of guiding us to correct the errors. Indeed,
data repairing based on these constraints may not find certain fixes that are guaranteed
correct, and worse still, may even introduce new errors when attempting to repair the data.
We propose a method for finding certain fixes, based on master data, a notion of certain
regions, and a class of editing rules. A certain region is a set of attributes that are assured …

… We show how the method can be used in data monitoring and enrichment. We also
develop techniques for reasoning about editing rules, to decide whether they lead to a
unique fix and whether they are able to fix all the attributes in a tuple, relative to master data
and a certain region. Furthermore, we present a framework and an algorithm to find certain
fixes, by interacting with the users to ensure that one of …