浏览全部资源
扫码关注微信
国防科技大学计算机学院,长沙,410073
纸质出版:2001
移动端阅览
阳国贵, 吴泉源. 一个有效处理高价选择谓词的查询优化算法[J]. 电子学报, 2001,29(2):182-185.
YANG Guo-gui, WU Quan-yuan. A New Optimization Algorithm for Queries with Expensive Selections[J]. Acta Electronica Sinica, 2001, 29(2): 182-185.
阳国贵, 吴泉源. 一个有效处理高价选择谓词的查询优化算法[J]. 电子学报, 2001,29(2):182-185. DOI:
YANG Guo-gui, WU Quan-yuan. A New Optimization Algorithm for Queries with Expensive Selections[J]. Acta Electronica Sinica, 2001, 29(2): 182-185. DOI:
文中讨论了对象关系数据库查询优化中所面临的新问题之一
即如何对查询中所包含的高价选择谓词进行优化.在经典的关系优化方法中
选择操作的代价较低
对选择操作均采用下推的方式
即让选择操作靠近选择关系
以图缩小参加后续连接运算的关系的规模(元组数).但在对象关系数据库中
由于选择操作本身就十分费时
因此
选择操作下推的前提条件已不成立
需要对此进行专门研究.在介绍了已有解决方法并分析其主要弊端后
文中提出了一个新的查询优化算法Predicate
-
Rolling
Up.
In this paper
one of the new problems encountered in the query optimization of ORDB(object relational data base)
that is
how to optimize the expensive predicates contained in the query
is discussed.In traditional query optimizers
selections have been handled by "pushdown" rules under the assumption that selection can be processed with little time or no time
and selections are processed immediately after the scan of the relation
so as to diminish the size of relations to be joined.In ORDB
however
complex methods can be embedded in selections
thus selections may take significant amount of time
and the assumption for "pushdown" is no longer sound
so attention must be paid on this new problem.Based on the analysis of some solutions
a new algorithm Predicate
_
Up is presented.
0
浏览量
862
下载量
CSCD
关联资源
相关文章
相关作者
相关机构