Skip to main content

Using the Model of Continuous Dynamical System with Viscous Resistance Forces for Improving Distribution Prediction Based on Evolution of Quantiles

  • Conference paper
Beyond Databases, Architectures, and Structures (BDAS 2014)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 424))

Abstract

The paper considers the problem of prediction of a probability distribution. We take into account an extrapolation model based on evolution of quantiles. We may use any concrete model which allows to track and extrapolate boundaries of buckets of an equi-height histogram. This histogram with pā€‰+ā€‰1 boundaries is equivalent to p-quantiles. Using such baseline extrapolation model we may obtain lines of locations of bucket boundaries that may intersect in future. To avoid intersections and to extend (in time) correctness of the results, we propose to use a model of continuous dynamical system with viscous resistance forces for obtaining improved lines of locations. The proposed model allows to obtain lines with unchanged shapes or very similar ones (comparing to the results from the baseline extrapolation model) but without any intersections. This approach will be helpful when a previously used baseline extrapolation model is too much time limited. The work was inspired by the problem of prediction of an attribute value distribution used for query selectivity estimation. However, the proposed method may be applied not only in query optimization problem.

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 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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. Augustyn, D.R.: Zastosowanie predykcji rozkładu wartości atrybutu w celu poprawy dokładności estymacji selektywności zapytań. Studia InformaticaĀ 34, 23ā€“42 (2013)

    Google ScholarĀ 

  2. Augustyn, D.R.: Applying advanced methods of query selectivity estimation in oracle DBMS. In: Cyran, K.A., Kozielski, S., Peters, J.F., Stańczyk, U., Wakulicz-Deja, A. (eds.) Man-Machine Interactions. AISC, vol.Ā 59, pp. 585ā€“593. Springer, Heidelberg (2009)

    ChapterĀ  Google ScholarĀ 

  3. Buck, B.: Maximum Entropy in Action: A Collection of Expository Essays. Oxford science publications, Clarendon Press (1992)

    Google ScholarĀ 

  4. Dormand, J., Prince, P.: A family of embedded runge-kutta formulae. Journal of Computational and Applied MathematicsĀ 6(1), 19ā€“26 (1980)

    ArticleĀ  MATHĀ  MathSciNetĀ  Google ScholarĀ 

  5. Eickhoff, M., McNickle, D., Pawlikowski, K.: Analysis of the time evolution of quantiles in simulation. Int. J. on Simulation: Systems, Science & TechnologyĀ 7, 44ā€“55 (2006)

    Google ScholarĀ 

  6. Haber, R., Keviczky, L.: Nonlinear system identification. In: Mathematical Modelling. Kluwer Academic Publishers (1999)

    Google ScholarĀ 

  7. Ioannidis, Y.: The history of histograms (abridged). In: Proceedings of the 29th International Conference on Very Large Data Bases, VLDB 2003, vol.Ā 29, pp. 19ā€“30. VLDB Endowment (2003)

    Google ScholarĀ 

  8. MathWorksĀ®: Cubic spline interpolation ā€“ MATLAB csapi (2013), http://www.mathworks.com/help/curvefit/csapi.html

  9. MathWorksĀ®: Find minimum of unconstrained multivariable function using derivative-free method ā€“ MATLAB (2013), http://www.mathworks.com/help/matlab/ref/fminsearch.html

  10. MathWorksĀ®: Solve nonstiff differential equations; medium order method ā€“ MATLAB ode45 (2013), http://www.mathworks.com/help/matlab/ref/ode45.html

  11. OracleĀ®Corporation: Using Extensible Optimizer, (July 10, 2005), http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28425/ext_optimizer.htm

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Dariusz Rafal Augustyn .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

Ā© 2014 Springer International Publishing Switzerland

About this paper

Cite this paper

Augustyn, D.R. (2014). Using the Model of Continuous Dynamical System with Viscous Resistance Forces for Improving Distribution Prediction Based on Evolution of Quantiles. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures, and Structures. BDAS 2014. Communications in Computer and Information Science, vol 424. Springer, Cham. https://doi.org/10.1007/978-3-319-06932-6_1

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-06932-6_1

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-06931-9

  • Online ISBN: 978-3-319-06932-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics