The Comparison between Histogram Method and Index Method in Selectivity Estimation

被引:0
|
作者
Zhang, Weiqi [1 ]
Zhang, Kunlong [1 ]
机构
[1] Tianjin Univ, Tianjin, Peoples R China
关键词
RDF (Resources Description Framework); SPARQL Query; Optimization; Histogram; Index; Selectivity Estimation;
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
Today RDF data are proliferating so fast that RDF query engines are faced with very large graphs that contain thousand million of RDF triples. Often there are a lot of joins should be processed when using RDF query language-SPARQL execute queries and the key issue for optimizing SPARQL execution plans is join ordering so selectivity estimation is very important to query cost. Exact estimation could optimize query and reduce query time, in contrast bad estimation could misguide the order of joins and increase query cost. In this paper we introduce two selectivity estimation methods: method based on histogram and method based on Index. We analyze the execute details of each method and compare the two methods then we give the conclusion that which method are better when execute query in large dataset. Finally, our experimental (using these two methods in different queries that have different join times in different size datasets.) testify our viewpoint.
引用
收藏
页码:357 / 362
页数:6
相关论文
共 50 条
  • [31] Selectivity estimation with density-model-based multidimensional histogram
    Meifan Zhang
    Hongzhi Wang
    Knowledge and Information Systems, 2021, 63 : 971 - 992
  • [32] Estimation of capability index based on bootstrap method
    Choi, KC
    Nam, KH
    Park, DH
    MICROELECTRONICS AND RELIABILITY, 1996, 36 (09): : 1141 - 1153
  • [33] A STUDY OF THE JACKKNIFE METHOD IN THE ESTIMATION OF THE EXTREMAL INDEX
    Ferreira, Marta
    SOUTH AFRICAN STATISTICAL JOURNAL, 2016, 50 (02) : 173 - 193
  • [34] Estimation of capability index based on bootstrap method
    Chosun Univ
    Microelectron Reliab, 9 (1141-1153):
  • [35] Comparison between the finite element method, the localized function method and a novel equivalent averaged index method for modelling photonic crystal fibres
    Peyrilloux, A
    Février, S
    Marcou, J
    Berthelot, L
    Pagnoux, D
    Sansonetti, P
    JOURNAL OF OPTICS A-PURE AND APPLIED OPTICS, 2002, 4 (03): : 257 - 262
  • [36] An accurate selectivity estimation method for window queries and an implementation thereof
    Cheng, Changxiu
    Yang, Jing
    Song, Xiaomei
    Yang, Shanli
    Wang, Lijun
    GEO-SPATIAL INFORMATION SCIENCE, 2015, 18 (2-3) : 81 - 89
  • [37] Dental Age Estimation: Comparison of Reliability Between Malay Formula of Demirjian Method and Malay Formula of Cameriere Method
    Alghali, R.
    Kamaruddin, A. F.
    Mokhtar, N.
    TRANSLATIONAL CRANIOFACIAL CONFERENCE 2016, (TCC 2016), 2016, 1791
  • [38] Comparison between the Hamiltonian Monte Carlo method and the Metropolis- Hastings method for coseismic fault model estimation
    Yamada, Taisuke
    Ohno, Keitaro
    Ohta, Yusaku
    EARTH PLANETS AND SPACE, 2022, 74 (01):
  • [39] Debris flow velocity estimation: A comparison between gradient-based method and cross-correlation method
    Uddin, MS
    Inaba, H
    Yoshida, Y
    Itakura, Y
    IMAGE PROCESSING: ALGORITHMS AND SYSTEMS, 2002, 4667 : 130 - 138
  • [40] BIAS IN ADC TERMINAL BASED GAIN AND OFFSET ESTIMATION USING THE HISTOGRAM METHOD
    Alegria, F. Correa
    XIX IMEKO WORLD CONGRESS: FUNDAMENTAL AND APPLIED METROLOGY, PROCEEDINGS, 2009, : 710 - 713