Authors: Lim Ee-Peng, Roger H. L. Chiang, Veda C. Storey
Tags: 2000, conceptual modeling
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. Moreover, most integration tasks must be performed manually. 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 from the federated database approach for global query implementation and instance integration, and (4) provide a systematic classification of knowledge useful for database integration. This classification will facilitate the design of appropriate techniques to acquire and utilize database integration knowledge.Read the full paper here: https://dl.acm.org/newsletter/sigmis
