A data cleaning method for heterogeneous attribute fusion and record linkage. (5th August 2019)

• Record Type: Journal Article
• Authors: Zhu, Hui-Juan; Jiang, Tong-Hai; Wang, Yi; Cheng, Li; Ma, Bo; Zhao, Fan
• Is Part Of: International journal of computational science and engineering. Volume 19:Number 3(2019)
• Page Start: 311
• Page End: 324
• Publication Date: 2019-08-05
• Subjects: big data -- varying window -- data cleaning -- record linkage -- record similarity -- SNM -- type-based blocking; Computer science -- Mathematics -- Periodicals; Computer simulation -- Mathematical aspects -- Periodicals; Computational intelligence -- Periodicals; 004.015105
• Languages: English
• ISSNs: 1742-7185

Abstract

In big data era, massive heterogeneous data are generated from various data sources, the cleaning of dirty data is critical for reliable data analysis. Existing rule-based methods are generally developed in single data source environment, issues like data standardisation and duplication detection for different data type attributes, are not fully studied. In order to address these challenges, we introduce a method based on dynamic configurable rules which can integrate data detection, modification and transformation together. Secondly, we propose a type-based blocking and a varying window size selection mechanism based on classic sorted-neighbourhood algorithm. We present a reference implementation of our method in a real-life data fusion system and validate its effectiveness and efficiency using recall and precision metrics. Experimental results indicate that our method is suitable in the scenario of multiple data sources with heterogeneous attribute properties.