Skip to main content

KNN Based Evolutionary Techniques for Updating Query Cost Models

  • Conference paper
Fuzzy Systems and Knowledge Discovery (FSKD 2005)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 3614))

Included in the following conference series:

Abstract

Data integration system usually runs on unpredictable and volatile environments. Query cost model should be update with the changes of the environment. In this paper, we tackle this problem by evolving the cost model so that it can adapt to the environment change and keep up-to-date. Firstly, the factors causing the system environment to change are analyzed and different methods are proposed to deal with these changes. Then an architecture for evolving a cost model in dynamic environment is proposed. Our experimental results show the architecture of evolving a cost model in dynamic environment can well capture changes of environment and keep cost models up-to-date.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight 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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Adali, S., Candan, K.S., Papakonstantinou, Y., Subrahmanian, V.S.: Query Caching and Optimization in Distributed Mediator Systems. In: Proc. of ACM SIGMOD, pp. 137–148 (1996)

    Google Scholar 

  2. Chatterjee, S., Price, B.: Regression Analysis by Example, 2nd edn. John Wiley & Sons. Inc., Chichester (1991)

    Google Scholar 

  3. Du, W., Krishnamurthy, R., Shan, M.C.: Query Optimization in Heterogeneous DBMS. In: Proc. of VLDB, pp. 277–291 (1992)

    Google Scholar 

  4. Gruser, J.R., Raschid, L., Zadorozhny, V., Zhan, T.: Learning Response Time for Web-Sources Using Query Feedback and Application in Query Optimization. VLDB Journal 9(1), 18–37 (2000)

    Article  Google Scholar 

  5. Liao, Z., Wang, H., Glass, D., Guo, G.: KNN-based Approach to Cost Model Updating (2005) (to appear)

    Google Scholar 

  6. Ling, Y., Sun, W.: A Supplement to Sampling-based Methods for Query Size Estimation in a Database System. SIGMOD Record 21(4), 12–15 (1992)

    Article  Google Scholar 

  7. Liu, W., Liao, Z., Hong, J., Liao, Z.F.: Query Cost Estimation through Remote Server Analysis Over the Internet. In: Proc. Of WI, pp. 345–355 (2003)

    Google Scholar 

  8. Roth, M.T., Ozcan, F., Haas, L.M.: Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System. In: Proc. of VLDB, pp. 599–610 (1999)

    Google Scholar 

  9. Wang, H.: K-nearest Neighbours by Counting (to appear)

    Google Scholar 

  10. Zadorozhny, V., Raschid, L., Zhan, T., Bright, L.: Validating an Access Cost Model for Wide Area Applications. Cooperative Information Systems 9, 371–385 (2001)

    Article  Google Scholar 

  11. Zhu, Q., Motheramgari, S., Sun, Y.: Developing Cost Models with Qualitative Variables for dynamic Multidatabase Environments. In: Proc. of ICDE (2000)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Liao, Z., Wang, H., Glass, D., Guo, G. (2005). KNN Based Evolutionary Techniques for Updating Query Cost Models. In: Wang, L., Jin, Y. (eds) Fuzzy Systems and Knowledge Discovery. FSKD 2005. Lecture Notes in Computer Science(), vol 3614. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11540007_99

Download citation

  • DOI: https://doi.org/10.1007/11540007_99

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-28331-7

  • Online ISBN: 978-3-540-31828-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics