BibTeX
@TECHREPORT{Godfrey96intensionalquery,
author = {P. Godfrey and J. Gryz},
title = {Intensional Query Optimization},
institution = {},
year = {1996}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
We have introduced a new query optimization framework called intensional query optimization (IQO), which enables existing optimization techniques to be applied to queries that use views. In particular, we consider that view definitions may employ unions. Advanced database technologies and applications---such as federation and mediation over heterogeneous database sources---lead to such complex view definitions, and to the need to handle complex, expensive queries. Query rewriting techniques have been proposed which exploit semantic query caches, materialized views, and semantic knowledge about the database domain to optimize query evaluation. These can augment syntactic optimization to reduce evaluation costs further. Such techniques include semantic query caching, query folding, and semantic query optimization. However, most proposed rewrite techniques ignore views in queries; that is, the views are considered as other tables. The IQO framework enables rewrites to be applied to vario...
Keyphrases
intensional query optimization new query optimization framework query evaluation optimization technique semantic query caching expensive query complex view definition semantic knowledge semantic query optimization evaluation cost advanced database technology query folding semantic query cache rewrite technique view definition database domain iqo framework heterogeneous database source syntactic optimization
