학술논문

Processing queries with expensive predicates by filtering
Document Type
Conference
Source
Proceedings. Twenty-Third Annual International Computer Software and Applications Conference (Cat. No.99CB37032) Computer software and applications Computer Software and Applications Conference, 1999. COMPSAC '99. Proceedings. The Twenty-Third Annual International. :350-356 1999
Subject
Computing and Processing
Communication, Networking and Broadcast Technologies
Costs
Spatial databases
Geographic Information Systems
Filtering
Query processing
Chemical technology
Chemical processes
Filters
Iterative algorithms
Geography
Language
ISSN
0730-3157
Abstract
There has been increasing interest in the application of abstract data types (ADT) in database technology to other fields. However, processing queries including ADT is always computationally expensive. We formalize a query processing scheme for selection operation which involves a computationally expensive predicate. Our approach is based on "filtering". In the method, an expensive predicate is decomposed into simpler ones and successively evaluated. Each of these simpler predicates is either a necessary or a sufficient condition of the initial predicate, and is used to reject or accept an object as the answer to the query without evaluating the initial predicate. Iterative reduction of an operand set of objects can significantly lessen the total cost of estimation of the initial predicate. A cost model is provided and an algorithm is proposed to determine an optimal query evaluation plan. Experiments on spatial queries illustrate the effect.