Integration of relations with conflicting schema structures in heterogeneous database systems

檔案

日期

1998-09-01

類型

期刊名稱

DATA & KNOWLEDGE ENGINEERING

卷期與頁次

第 27 卷第 2 期,頁 231–248

ISSN

0169-023X

語言

英文

摘要

Schema integration is an important discipline for constructing a heterogeneous database system, since there exists various semantic discrepancies among local schemas. However, prior works rarely address the problems of integrating local relations with conflicts of different schema structures. In this paper, we propose an approach for the integration of local relations with such conflicts. In our approach, we define some auxiliary data called metadata for local schemas. The relations can be classified into some classes according to the metadata. The local relations with conflicts of different schema structures are respectively transformed to new relations with the same structure. Finally, we integrate these new relations. We also explore the query decomposition process for global queries. A global query is decomposed into many local queries according to the local schemas' structures. The results of the local queries will be sent to the global site. Finally, the global site integrates the local results into a new one and poses the global query on the integrated result again to get the final result. Since this process filters out unnecessary data in each local site, it can also be regarded as an important work for global query optimization.

所屬典藏

期刊論文
顯示完整詮釋資料 統計資料

引用此條目

Tseng, F., Chiang, J., & Yang, W. (1998). Integration of relations with conflicting schema structures in heterogeneous database systems. DATA & KNOWLEDGE ENGINEERING, 27(2), 231–248. https://ir.lib.nycu.edu.tw/handle/11536/32414

BibTeX RIS

引用文字依 APA 第 7 版格式自動產生,使用前請再核對。

分享

永久網址:https://ir.lib.nycu.edu.tw/handle/11536/32414