DocumentCode
928807
Title
Cleaning the spurious links in data
Author
Lee, Mong Li ; Hsu, Wynne ; Kothari, Vijay
Author_Institution
Nat. Univ. of Singapore, Singapore
Volume
19
Issue
2
fYear
2004
Firstpage
28
Lastpage
33
Abstract
Data quality problems can arise from abbreviations, data entry mistakes, duplicate records, missing fields, and many other sources. These problems proliferate when you integrate multiple data sources in data warehousing, federated databases, and global information systems. A newly discovered class of erroneous data is spurious links, where a real-world entity has multiple links that might not be properly associated with it. The existence of such spurious links often leads to confusion and misrepresentation in the data records representing the entity. Although the data set is well known for its high-quality bibliographic information, collecting and maintaining the data from diverse sources requires enormous effort. Errors, including spurious links, are inevitable. To solve this problem, we use context information to identify spurious links. First, we identify data records that contain potential spurious links. We then determine the set of attributes that constitute each record´s context. Experiments with three real-world databases have demonstrated that our approach can accurately identify spurious links. Comparing context information between data records can help solve the data quality problem of spurious links-that is, multiple links between data entries and real-world entities.
Keywords
data mining; data warehouses; distributed databases; context information; data quality problem; data warehouse; federated database; global information system; multiple data source; real-world database; real-world entity; spurious link; Bibliographies; Cleaning; Data warehouses; Database systems; Information systems; Intelligent networks; Intelligent systems; Performance analysis; Queueing analysis; Warehousing;
fLanguage
English
Journal_Title
Intelligent Systems, IEEE
Publisher
ieee
ISSN
1541-1672
Type
jour
DOI
10.1109/MIS.2004.1274908
Filename
1274908
Link To Document