Publication Type
Journal Article
Version
publishedVersion
Publication Date
3-2000
Abstract
Database integration research has traditionally focused on understanding integration issues from the schema and instance perspectives. As a result, database integration approaches tend to rely on a direct comparison of schema and instance elements. However, when the integration of heterogeneous databases is performed without considering the domain semantics and knowledge of local databases such as context information and requirement specifications, an incorrect integrated database may be produced. In this research, a framework for carrying out database integration tasks using the above knowledge is proposed. The framework provides a thorough foundation to: 1. analyze database integration issues from a broad scope, 2. discuss the implications of database reverse engineering on database integration, 3. distinguish the data warehousing approach for global query implementation and instance integration, and 4. provide a systematic classification of knowledge useful for database integration.
Keywords
Database integration, Federated database systems (FDBS), Data warehouse, Database reverse engineering, Database Integration knowledge and process
Discipline
Databases and Information Systems
Publication
Data Base for Advances in Information Systems
Volume
31
Issue
2
First Page
46
Last Page
64
ISSN
1532-0936
Publisher
ACM
Citation
CHIANG, Roger Hsiang-Li; LIM, Ee Peng; and STOREY, Veda C..
A framework for acquiring domain semantics and knowledge for database integration. (2000). Data Base for Advances in Information Systems. 31, (2), 46-64.
Available at: https://ink.library.smu.edu.sg/sis_research/160
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.