Publication Type
Journal Article
Version
publishedVersion
Publication Date
2000
Abstract
In the process of integrating legacy databases, one has to resolve inter-database conflicts at both the schema and instance levels. In this paper, we discuss relationship conflicts as a special type of conflicts to be resolved during the database integration. Relationships are properties that relate real world objects. So far, most inter-database relationship conflicts are addressed at the schema-level by various schema integration techniques. However, instance-level relationship conflicts are largely neglected. This paper therefore investigates the causes of instance-level relationship conflicts and proposes a taxonomy for classifying instance-level relationship conflicts. In addition, we develop a systematic process to resolve instance-level relationship conflicts and incorporate the resolution steps into the overall database integration process. Instance-level relationship conflict detection algorithms have also been developed to aid the resolution process. This research should facilitate database integration work for both multidatabase and data warehousing approaches. Most importantly, it should improve the data quality of the integrated databases.
Discipline
Databases and Information Systems
Publication
Decision Support Systems
Volume
29
Issue
2
First Page
153
Last Page
167
ISSN
0167-9236
Identifier
10.1016/S0167-9236(00)00070-1
Publisher
Elsevier
Citation
LIM, Ee Peng and CHIANG, Roger Hsiang-Li.
The Integration of Relationship Instances from Heterogeneous Databases. (2000). Decision Support Systems. 29, (2), 153-167.
Available at: https://ink.library.smu.edu.sg/sis_research/56
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.
Additional URL
http://dx.doi.org/10.1016/S0167-9236(00)00070-1