DocumentCode
2888040
Title
An algorithm for answering queries efficiently using views
Author
Mitra, Prasenjit
Author_Institution
Infolab, Stanford Univ., CA, USA
fYear
2001
fDate
2001
Firstpage
99
Lastpage
106
Abstract
Algorithms for answering queries using views have been used in query planning in order to answer queries posed to knowledge bases, databases, and information systems. However, these algorithms do not scale well when the number of views increases. Three known algorithms, the bucket algorithm, the inverse-rules algorithm and an algorithm suggested by Leser (1998) have been used to rewrite queries using views before executing the queries. The bucket algorithm, predominantly used to reformulate queries, generates a candidate rewriting to a query using views, and checks that the rewriting is contained in the original query. An exponential conjunctive-query-containment-test needs to be performed to check each candidate rewriting. Using a few extra a buckets (shared-variable-buckets), we show how we can avoid the conjunctive-query-containment-test. This paper presents a scalable query rewriting algorithm-the shared-variable-bucket (SVB) algorithm. Experimental results demonstrate its superiority over other known algorithms
Keywords
database management systems; query processing; SVB algorithm; bucket algorithm; databases; experimental results; exponential conjunctive query containment test; information systems; inverse-rules algorithm; knowledge bases; query planning; query reformulation; scalable query rewriting algorithm; shared variable bucket algorithm; views; Acoustic testing; Databases; Delay; Information systems;
fLanguage
English
Publisher
ieee
Conference_Titel
Database Conference, 2001. ADC 2001. Proceedings. 12th Australasian
Conference_Location
Gold Coast, Qld.
ISSN
1530-0919
Print_ISBN
0-7695-0966-5
Type
conf
DOI
10.1109/ADC.2001.904470
Filename
904470
Link To Document