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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
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)
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)
Buck, B.: Maximum Entropy in Action: A Collection of Expository Essays. Oxford science publications, Clarendon Press (1992)
Dormand, J., Prince, P.: A family of embedded runge-kutta formulae. Journal of Computational and Applied MathematicsĀ 6(1), 19ā26 (1980)
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)
Haber, R., Keviczky, L.: Nonlinear system identification. In: Mathematical Modelling. Kluwer Academic Publishers (1999)
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)
MathWorksĀ®: Cubic spline interpolation ā MATLAB csapi (2013), http://www.mathworks.com/help/curvefit/csapi.html
MathWorksĀ®: Find minimum of unconstrained multivariable function using derivative-free method ā MATLAB (2013), http://www.mathworks.com/help/matlab/ref/fminsearch.html
MathWorksĀ®: Solve nonstiff differential equations; medium order method ā MATLAB ode45 (2013), http://www.mathworks.com/help/matlab/ref/ode45.html
OracleĀ®Corporation: Using Extensible Optimizer, (July 10, 2005), http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28425/ext_optimizer.htm
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)