{"title":"Selectivity estimation in web query optimization","authors":"Shashidhar H R, G T Raju, V. Murthy","doi":"10.1145/3018896.3152305","DOIUrl":null,"url":null,"abstract":"Web Query optimization techniques have not scaled up to the quality of classical database optimizers. The main reason is the lack of availability of meta data statistics from local data sources. This leads to enormous errors in the calculation of optimization parameters such as selectivity of an operator which can degrade the query execution performance and result in bloated response time. In this work, the problem of selectivity estimation is addressed through Histogram construction and Probabilistic selectivity estimation. Both these techniques are robust and scalable to any kind of Web Query Engine. Empirical results also demonstrate the superior quality of these techniques.","PeriodicalId":131464,"journal":{"name":"Proceedings of the Second International Conference on Internet of things, Data and Cloud Computing","volume":"44 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2017-03-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the Second International Conference on Internet of things, Data and Cloud Computing","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3018896.3152305","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 1
Abstract
Web Query optimization techniques have not scaled up to the quality of classical database optimizers. The main reason is the lack of availability of meta data statistics from local data sources. This leads to enormous errors in the calculation of optimization parameters such as selectivity of an operator which can degrade the query execution performance and result in bloated response time. In this work, the problem of selectivity estimation is addressed through Histogram construction and Probabilistic selectivity estimation. Both these techniques are robust and scalable to any kind of Web Query Engine. Empirical results also demonstrate the superior quality of these techniques.