首页>
外国专利>
Optimization of queries using relational algebraic theta-semijoin operator
Optimization of queries using relational algebraic theta-semijoin operator
展开▼
机译:使用关系代数theta-semijoin运算符的查询优化
展开▼
页面导航
摘要
著录项
相似文献
摘要
A collection of equivalence rules involving the multiset version of the relational algebraic theta-semijoin operator is used to generate relational algebraic expressions equivalent to a computer programming language query. These expressions may be employed as a search space which is utilized by, for example, optimizing software or software that determines the equivalency of queries. Cost formulas for the multiset version of the theta-semijoin operator may be used in computing cost estimates for the generated expressions. Based on these computed cost estimates, the least costly implementation of a complex query is determined. Thus, queries are cost-based optimized on both a local and global basis by use of the relational algebraic theta-semijoin operator.
展开▼