Instance-based attribute identification in database integration

Authors: 
Chua, CEH; Chiang, RHL; Lim, EP
Author: 
Chua, C
Chiang, R
Lim, E
Year: 
2003
Venue: 
The VLDB Journal The International Journal on Very Large
URL: 
http://www.springerlink.com/content/D05NL2A1LYK59HCW/fulltext.pdf
Citations: 
36
Citations range: 
10 - 49
AttachmentSize
Chua2003Instancebasedattributeidentificationindatabaseintegration.pdf213.54 KB

Abstract.Most research on attribute identification in database integration has focused on integrating attributes using schema and summary information derived from the attribute values. No research has attempted to fully explore the use of attribute values to perform attribute identification. We propose an attribute identification method that employs schema and summary instance information as well as properties of attributes derived from their instances. Unlike other attribute identification methods that match only single attributes, our method matches attribute groups for integration. Because our attribute identification method fully explores data instances, it can identify corresponding attributes to be integrated even when schema information is misleading. Three experiments were performed to validate our attribute identification method. In the first experiment, the heuristic rules derived for attribute classification were evaluated on 119 attributes from nine public domain data sets. The second was a controlled experiment validating the robustness of the proposed attribute identification method by introducing erroneous data. The third experiment evaluated the proposed attribute identification method on five data sets extracted from online music stores. The results demonstrated the viability of the proposed method.