CerFix: A System for Cleaning Data with Certain Fixes

Wenfei Fan, Jianzhong Li, Shuai Ma, Nan Tang, Wenyuan Yu

Research output: Contribution to journalArticlepeer-review

Abstract / Description of output

We present CerFix, a data cleaning system that finds certain fixes for tuples at the point of data entry, i.e., fixes that are guaranteed correct. It is based on master data, editing rules and certain regions. Given some attributes of an in-
put tuple that are validated (assured correct), editing rules tell us what other attributes to x and how to correct them with master data. A certain region is a set of attributes that, if validated, warrant a certain x for the entire tuple. We demonstrate the following facilities provided by Cer-Fix: (1) a region finder to identify certain regions; (2) a data monitor to find certain fixes for input tuples, by guiding users to validate a minimal number of attributes; and
(3) an auditing module to show what attributes are fixed and where the correct values come from.
Original languageEnglish
Pages (from-to)1375-1378
Number of pages4
JournalProceedings of the VLDB Endowment (PVLDB)
Issue number12
Publication statusPublished - 2011


Dive into the research topics of 'CerFix: A System for Cleaning Data with Certain Fixes'. Together they form a unique fingerprint.

Cite this