XML Duplicate Detection Using Sorted Neighborhoods

Authors: 
Puhlmann, Sven; Weis, Melanie; Naumann, Felix
Author: 
Puhlmann, S
Weis, M
Naumann, F
Year: 
2006
Venue: 
Conference on Extending Database Technology (EDBT) 2006
URL: 
http://dx.doi.org/10.1007/11687238_46
DOI: 
http://dx.doi.org/10.1007/11687238_46
Citations: 
36
Citations range: 
10 - 49

Detecting duplicates is a problem with a long tradition in many domains, such as customer relationship management and data warehousing. The problem is twofold: First define a suitable similarity measure, and second efficiently apply the measure to all pairs of objects. With the advent and pervasion of the XML data model, it is necessary to find new similarity measures and to develop efficient methods to detect duplicate elements in nested XML data.

A classical approach to duplicate detection in flat relational data is the sorted neighborhood method, which draws its efficiency from sliding a window over the relation and comparing only tuples within that window. We extend the algorithm to cover not only a single relation but nested XML elements. To compare objects we make use of XML parent and child relationships. For efficiency, we apply the windowing technique in a bottom-up fashion, detecting duplicates at each level of the XML hierarchy. Experiments show a speedup comparable to the original method data and they show the high effectiveness of our algorithm in detecting XML duplicates.