Skip to Main content Skip to Navigation
Conference papers

An Approach Based on Bayesian Networks for Query Selectivity Estimation

Abstract : The efficiency of a query execution plan depends on the accuracy of the selectivity estimates given to the query optimiser by the cost model. The cost model makes simplifying assumptions in order to produce said estimates in a timely manner. These assumptions lead to selectivity estimation errors that have dramatic effects on the quality of the resulting query execution plans. A convenient assumption that is ubiquitous among current cost models is to assume that attributes are independent with each other. However, it ignores potential correlations which can have a huge negative impact on the accuracy of the cost model. In this paper we attempt to relax the attribute value independence assumption without unreasonably deteriorating the accuracy of the cost model. We propose a novel approach based on a particular type of Bayesian networks called Chow-Liu trees to approximate the distribution of attribute values inside each relation of a database. Our results on the TPC-DS benchmark show that our method is an order of magnitude more precise than other approaches whilst remaining reasonably efficient in terms of time and space.
Document type :
Conference papers
Complete list of metadata

Cited literature [39 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-02493882
Contributor : Open Archive Toulouse Archive Ouverte (oatao) <>
Submitted on : Friday, February 28, 2020 - 11:39:42 AM
Last modification on : Friday, June 11, 2021 - 3:16:01 PM
Long-term archiving on: : Friday, May 29, 2020 - 1:20:42 PM

File

halford_24753.pdf
Files produced by the author(s)

Identifiers

  • HAL Id : hal-02493882, version 1
  • OATAO : 24753

Citation

Max Halford, Philippe Saint-Pierre, Franck Morvan. An Approach Based on Bayesian Networks for Query Selectivity Estimation. 24th International Conference on Database Systems for Advanced Applications (DASFAA 2019), Apr 2019, Chiang Mai, Thailand. pp.3-19. ⟨hal-02493882⟩

Share

Metrics

Record views

116

Files downloads

177