Abstract
Selectivity estimation is an activity performed during a query optimization process. Selectivity parameter lets estimate the query result size before the query is really executed. This allows to obtain the best query execution plan. For complex queries (where selection condition is based on many attributes) an accurate selectivity estimation requires a multidimensional distribution of attributes values. But often, attribute value independence assumption and usage of only 1-dimensional distributions give a sufficient accuracy of selectivity approximation. The paper describes the method of selectivity estimation for queries with a complex selection condition based on a sum of independent attributes or sub-independent ones. The proposed method operates on 1-dimensional Fourier Transforms of marginal distributions of attributes that are involved in the selection condition.
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.: 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)
Getoor, L., Taskar, B., Koller, D.: Selectivity estimation using probabilistic models. ACM SIGMOD Record 30, 461â472 (2001)
Hamedani, G., Walter, G.: A fixed point theorem and its application to the central limit theorem. Archiv der Mathematik 43(3), 258â264 (1984) (in English)
Hamedani, G.G., Volkmer, H.W., Behboodian, J.: A note on sub-independent random variables and a class of bivariate mixtures. Studia Scientiarum Mathematicarum Hungarica 49(1), 19â25 (2012)
Khachatryan, A., MĂŒller, E., Stier, C., Böhm, K.: Sensitivity of self-tuning histograms: query order affecting accuracy and robustness. In: Ailamaki, A., Bowers, S. (eds.) SSDBM 2012. LNCS, vol. 7338, pp. 334â342. Springer, Heidelberg (2012)
OracleÂź: Using Extensible Optimizer, http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28425/ext_optimizer.htm (accessed July 10, 2005)
Poosala, V., Ioannidis, Y.E.: Selectivity estimation without the attribute value independence assumption. In: Proceedings of the 23rd International Conference on Very Large Data Bases (VLDB 1997), pp. 486â495. Morgan Kaufmann (1997)
Scott, D.W., Sain, S.R.: Multidimensional density estimation. In: Rao, C.R., Wegman, E.J. (eds.) Handbook of Statistics: Data Mining and Data Visualization, vol. 24, pp. 229â261. Elsevier, Amsterdam (2005)
Yan, F., Hou, W.C., Jiang, Z., Luo, C., Zhu, Q.: Selectivity estimation of range queries based on data density approximation via cosine series. Data & Knowledge Engineering 63(3), 855â878 (2007)
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). The Method of Query Selectivity Estimation for Selection Conditions Based on Sum of Sub-Independent Attributes. In: Gruca, D., CzachĂłrski, T., Kozielski, S. (eds) Man-Machine Interactions 3. Advances in Intelligent Systems and Computing, vol 242. Springer, Cham. https://doi.org/10.1007/978-3-319-02309-0_65
Download citation
DOI: https://doi.org/10.1007/978-3-319-02309-0_65
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-02308-3
Online ISBN: 978-3-319-02309-0
eBook Packages: EngineeringEngineering (R0)