|
English
|
正體中文
|
简体中文
|
Post-Print筆數 : 27 |
Items with full text/Total items : 113648/144635 (79%)
Visitors : 51571323
Online Users : 701
|
|
|
Loading...
|
Please use this identifier to cite or link to this item:
https://nccur.lib.nccu.edu.tw/handle/140.119/69370
|
Title: | A Localized Approach to Query Optimization in Heterogeneous Database System |
Authors: | 陳良弼 Tsai,Pauray S. M.;Chen,Arbee L. P. |
Contributors: | 資科系 |
Keywords: | heterogeneous databases;localized query processing;entity join;neighborhood join;constraint relaxation |
Date: | 1993-12 |
Issue Date: | 2014-08-28 10:08:18 (UTC+8) |
Abstract: | Heterogeneities exist in multiple databases. 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 develop an entity join operator named EJ operator, which can be used to join two relations on their compatible/incompatible keys. By using this join, if an entity is represented in both relations, all its properties given in relations can be obtained. Furthermore, a neighborhood join operator named NJ operator is introduced, which joins relations allowing some degree of value uncertainty on the join attributes. The EJ operator, NJ operator and the previously proposed extended relational operators can be combined to support a more powerful set of operations on heterogeneous databases. Since the EJ operator "integrates" tuples from relations, whose attribute values may have conflicts, a natural way to process the operator is to transmit both relations to a site, resolve the conflicts and process the join, which is very costly. An approach which transforms a global query into local subqueries to process queries with EJs in multiple sites is, thus, proposed in an attempt to lower the query processing cost. |
Relation: | Journal of Inforamtion Science and Engineering,9(4),605-623 |
Data Type: | article |
Appears in Collections: | [資訊科學系] 期刊論文
|
Files in This Item:
File |
Description |
Size | Format | |
index.html | | 0Kb | HTML2 | 1243 | View/Open |
|
All items in 政大典藏 are protected by copyright, with all rights reserved.
|
著作權政策宣告 Copyright Announcement1.本網站之數位內容為國立政治大學所收錄之機構典藏,無償提供學術研究與公眾教育等公益性使用,惟仍請適度,合理使用本網站之內容,以尊重著作權人之權益。商業上之利用,則請先取得著作權人之授權。
The digital content of this website is part of National Chengchi University Institutional Repository. It provides free access to academic research and public education for non-commercial use. Please utilize it in a proper and reasonable manner and respect the rights of copyright owners. For commercial use, please obtain authorization from the copyright owner in advance.
2.本網站之製作,已盡力防止侵害著作權人之權益,如仍發現本網站之數位內容有侵害著作權人權益情事者,請權利人通知本網站維護人員(
nccur@nccu.edu.tw),維護人員將立即採取移除該數位著作等補救措施。
NCCU Institutional Repository is made to protect the interests of copyright owners. If you believe that any material on the website infringes copyright, please contact our staff(
nccur@nccu.edu.tw). We will remove the work from the repository and investigate your claim.