Skip to main content

Multi step Query Processing

  • Reference work entry
  • First Online:
  • 16 Accesses

Synonyms

Filter/refinement query processing

Definition

A query on a database reports those objects which fulfill a given query predicate. A query processor has to evaluate the query predicate for each object in the database which is a candidate for the result set. Multi-step query processing (filter/refinement query processing) is a technique to speed up queries specifying query predicates that are complex and costly to evaluate. The idea is to save the costs of the evaluation of the complex query predicate by reducing the candidate set for which the query predicate has to be evaluated applying one or more filter steps. The aim of each filter step is to identify as many true hits (objects that truly fulfill the complex query predicate) and as many true drops (objects that truly do not fulfill the query predicate) as possible by applying a less costly query predicate. The remaining candidates that are not pruned as drops or reported as hits in one of the filter steps need to be tested...

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD   6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Recommended Reading

  1. Agrawal R, Faloutsos C, Swami A. Efficient similarity search in sequence databases. In: Proceedings of the 4th International Conference on Foundations of Data Organization and Algorithms; 1993. p. 69–80.

    Chapter  Google Scholar 

  2. Brinkhoff T, Horn H, Kriegel H-P, Schneider R. A storage and access architecture for efficient query processing in spatial database systems. In: Proceedings of the 3rd International Symposium on Advances in Spatial Databases; 1993. p. 357–76.

    Chapter  Google Scholar 

  3. Faloutsos C, Ranganathan M, Manolopoulos Y. Fast subsequence matching in time series database. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1994. p. 419.

    Article  Google Scholar 

  4. Korn F, Sidiropoulos N, Faloutsos C, Siegel E, Protopapas Z. Fast nearest neighbor search in medical image databases. In: Proceedings of the 22nd International Conference on Very Large Data Bases; 1996.p. 215–26.

    Google Scholar 

  5. Kriegel H-P, Kröger P, Kunath P, Renz M. Generalizing the optimality of multi-step k-nearest neighbor query processing. In: Proceedings of the 10th International Symposium on Advances in Spatial and Temporal Databases; 2007. p. 75–9.

    Google Scholar 

  6. Orenstein J, Manola F. Probe spatial data modelling and query processing in an image database application. IEEE Trans Softw Eng. 1998;14(5):611–29.

    Article  Google Scholar 

  7. Seidl T, Kriegel H-P. Optimal multi-step k-nearest neighbor search. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1998. p. 154–16.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Peer Kröger .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Kröger, P., Renz, M. (2018). Multi step Query Processing. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_227

Download citation

Publish with us

Policies and ethics