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.
database integration, federated database systems (FDBS), data warehouse, database reverse engineering, database integration knowledge and process
Databases and Information Systems
Data Management and Analytics
Data Base for Advances in Information Systems
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. Research Collection School Of Information Systems.
Available at: http://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 License.