Publication Type
Journal Article
Version
publishedVersion
Publication Date
2003
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.
Discipline
Databases and Information Systems | Numerical Analysis and Scientific Computing
Publication
VLDB Journal
Volume
3
Issue
3
First Page
228
Last Page
243
ISSN
1066-8888
Identifier
10.1007/s00778-003-0088-y
Publisher
Springer Verlag
Citation
LIM, Ee Peng; CHUA, Cecil; and CHIANG, Roger Hsiang-Li.
Instance Based Attribute Identification in Database Integration. (2003). VLDB Journal. 3, (3), 228-243.
Available at: https://ink.library.smu.edu.sg/sis_research/18
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.
Additional URL
http://doi.org/10.1007/s00778-003-0088-y
Included in
Databases and Information Systems Commons, Numerical Analysis and Scientific Computing Commons