Logo image
Optimizing entity join queries when data transmission cost dominates
期刊文章

Optimizing entity join queries when data transmission cost dominates

Pauray S.M. TsaiArbee L.P. Chen
Data and Knowledge Engineering, 卷.22(3), 頁碼.283-308
1997

摘要

Entity join Extended semijoin Inconsistent data Local processing Multidatabase Query optimization Query transformation Selectivity Information Systems and Management
Heterogeneities exist in a multidatabase environment. For example, a real world entity may be differently represented in relations of different databases. In particular, keys of these relations may be incompatible. In this paper, we consider processing entity join queries when data transmission cost dominates. An entity join operation 'integrates' tuples representing the same entities from different relations in which inconsistent data may exist. A natural way to process the entity join is to transmit both relations to a site, resolve the possible conflicts between corresponding attributes and process the join, which is very costly. In this paper, an approach is proposed to correctly transform a global query into local subqueries to preprocess entity join queries in multiple sites with an attempt to lower the cost of data transmission. Besides, an extension of the traditional semijoin, named extended semijoin, is proposed to further reduce the cost of data transmission for entity join query processing.

相關連結

指標

1 檢視次數

詳細資料

Logo image