A consistency cleaning method based on content-related conditional functional dependencies

作者：Du Yue-Feng; Shen De-Rong; Zhang Liang; Yu Ge^*

来源：Journal of Northeastern University, 2016, 37(12): 1683-1687.

DOI：10.3969/j.issn.1005-3026.2016.12.003

• Conditional functional dependencies
• Data cleaning
• Data consistency
• Experimental evaluation
• Inconsistency detection
• Real life datasets
• Reference values
• Repairing costs

Based on conditional functional dependencies, content-related conditional functional dependencies (CCFDs) and the consistency cleaning method were presented based on CCFDs. By analyzing the relationship of the conditional functional dependencies, the related conditional functional dependencies were combined into CCFDs. The CCFDs can not only detect the consistencies under multi-conditional values, but also provide reference values for the consistency repairing. A consistency repairing-cost model was presented. Then the data was corrected to be consistent with the minimal repairing cost according to the actual data. And the repaired results are approved accuracy for both the inconsistency detection and the inconsistency repairing via the experimental evaluation on two real-life datasets.

• 出版日期2016
• 单位东北大学