The VLDB Journal

, Volume 21, Issue 2, pp 213–238

Towards certain fixes with editing rules and master data

Special Issue Paper

DOI: 10.1007/s00778-011-0253-7

Cite this article as:
Fan, W., Li, J., Ma, S. et al. The VLDB Journal (2012) 21: 213. doi:10.1007/s00778-011-0253-7


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 correct by the users. Given a certain region and master data, editing rules tell us what attributes to fix and how to update them. 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 the certain regions is correct. We experimentally verify the effectiveness and scalability of the algorithm.


Certain fix Editing rule Master data Data cleaning Data quality 

Supplementary material

778_2011_253_MOESM1_ESM.pdf (62 kb)
ESM 1 (PDF 63 kb)

Copyright information

© Springer-Verlag 2011

Authors and Affiliations

  1. 1.University of EdinburghEdinburghUK
  2. 2.Harbin Institute of TechnologyHarbinChina
  3. 3.Beihang UniversityBeijingChina

Personalised recommendations