Skip to main navigation Skip to search Skip to main content

Query selectivity estimation based on improved V-optimal histogram by introducing information about distribution of boundaries of range query conditions

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

1 Citation (Scopus)

Abstract

Selectivity estimation is a parameter used by a query optimizer for early estimation of the size of data that satisfies query condition. Selectivity is calculated using an estimator of distribution of attribute values of attribute involved in a processed query condition. Histograms built on attributes values from a database may be such representation of the distribution. The paper introduces a new querydistribution- aware V-optimal histogram which is useful in selectivity estimation for a range query. It takes into account either a 1-D distribution of attribute values or a 2-D distribution of boundaries of already processed queries. The advantages of qda-V-optimal histogram appears when it is applied for selectivity estimation of range query conditions that form so-called hot regions. To obtain the proposed error-optimal histogram we use dynamic programming method, Fuzzy C-Means clustering of a set of range boundaries.

Original languageEnglish
Title of host publicationComputer Information Systems and Industrial Management - 13th IFIP TC8 International Conference, CISIM 2014, Proceedings
EditorsKhalid Saeed, Khalid Saeed, Václav Snášel
PublisherSpringer Verlag
Pages151-164
Number of pages14
ISBN (Electronic)9783662452363
DOIs
Publication statusPublished - 2014
Event13th IFIP TC8 International Conference on Computer Information Systems and Industrial Management, CISIM 2014 - Ho Chi Minh City, Viet Nam
Duration: 5 Nov 20147 Nov 2014

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume8838
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference13th IFIP TC8 International Conference on Computer Information Systems and Industrial Management, CISIM 2014
Country/TerritoryViet Nam
CityHo Chi Minh City
Period5/11/147/11/14

Keywords

  • Data clustering
  • Distribution of range query conditions
  • Dynamic programming
  • Query selectivity estimation
  • V-optimal histogram

ASJC Scopus subject areas

  • Theoretical Computer Science
  • General Computer Science

Fingerprint

Dive into the research topics of 'Query selectivity estimation based on improved V-optimal histogram by introducing information about distribution of boundaries of range query conditions'. Together they form a unique fingerprint.

Cite this