Title :
Query folding with inclusion dependencies
Author_Institution :
Dept. of Comput. Sci., York Univ., Toronto, Ont., Canada
Abstract :
Query folding is a technique for determining how a query may be answered using a given set of resources, which may include materialized views, cached results of previous queries or queries answerable by other databases. The power of query folding can be considerably enhanced by taking into account integrity constraints that are known to hold on base relations. This paper describes an extension of query folding that utilizes inclusion dependencies to find foldings of queries that would otherwise be overlooked. We describe a complete strategy for finding foldings in the presence of inclusion dependencies and present a basic algorithm that implements that strategy. We also describe extensions to this algorithm when both inclusion and functional dependencies are considered
Keywords :
data integrity; database theory; query processing; algorithm; base relations; cached results; database resources; functional dependencies; inclusion dependencies; integrity constraints; materialized views; query answering; query folding; Computer science; Databases; History; Identity-based encryption; Magnetic resonance imaging; Network servers; Vents;
Conference_Titel :
Data Engineering, 1998. Proceedings., 14th International Conference on
Conference_Location :
Orlando, FL
Print_ISBN :
0-8186-8289-2
DOI :
10.1109/ICDE.1998.655768