A framework for acquiring domain semantics and knowledge for database integration

• Main Authors: CHIANG, Roger Hsiang-Li, LIM, Ee Peng, STOREY, Veda C.
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 2000
• Subjects: Database integration; Federated database systems (FDBS); Data warehouse; Database reverse engineering; Database Integration knowledge and process; Databases and Information Systems
• Online Access: https://ink.library.smu.edu.sg/sis_research/160; https://ink.library.smu.edu.sg/context/sis_research/article/1159/viewcontent/FrameworkAcqDomainSemantics_2000.pdf
• Institution: Singapore Management University

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.