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 条
  • [21] Estimation of small failure probabilities using the Accelerated Weight Histogram method
    Lidmar, Jack
    Edelbro, Catrin
    Vatcher, Jessa
    Spross, Johan
    PROBABILISTIC ENGINEERING MECHANICS, 2023, 74
  • [22] COMPARISON BETWEEN A MICROMETHOD AND A CONVENTIONAL METHOD FOR ESTIMATION OF SALIVARY STREPTOCOCCUS MUTANS
    KOHLER, B
    EMILSON, CG
    SCANDINAVIAN JOURNAL OF DENTAL RESEARCH, 1987, 95 (02): : 132 - 135
  • [23] An Image Orientation Estimation Method Based on Gradient Histogram and Point Matching
    Cheng, Zhonghao
    Chai, Senchun
    2019 CHINESE AUTOMATION CONGRESS (CAC2019), 2019, : 4896 - 4900
  • [24] A Robust Method for Head Orientation Estimation Using Histogram of Oriented Gradients
    Dinh Tuan Tran
    Lee, Joo-Ho
    SIGNAL PROCESSING, IMAGE PROCESSING AND PATTERN RECOGNITION, 2011, 260 : 391 - 400
  • [25] Estimation and Comparison of Cortical Thickness Index and Canal-to-Calcar Ratio Using Manual Method and Deep Learning Method
    Yoon, Sun-Jung
    Kim, Minwoo
    Oh, Il-Seok
    Kim, Kyungho
    Han, Kap-Soo
    JOURNAL OF ELECTRICAL ENGINEERING & TECHNOLOGY, 2020, 15 (03) : 1399 - 1404
  • [26] Estimation and Comparison of Cortical Thickness Index and Canal-to-Calcar Ratio Using Manual Method and Deep Learning Method
    Sun-Jung Yoon
    Minwoo Kim
    Il-Seok Oh
    Kyungho Kim
    Kap-Soo Han
    Journal of Electrical Engineering & Technology, 2020, 15 : 1399 - 1404
  • [27] Comparison between the Hamiltonian Monte Carlo method and the Metropolis–Hastings method for coseismic fault model estimation
    Taisuke Yamada
    Keitaro Ohno
    Yusaku Ohta
    Earth, Planets and Space, 74
  • [28] Spread histogram - A method for calculating spatial relations between objects
    Kwasnicka, H
    Paradowski, M
    Computer Recognition Systems, Proceedings, 2005, : 249 - 256
  • [29] Spatial selectivity estimation using cumulative density wavelet histogram
    Cho, Byung Kyu
    ADVANCED INTELLIGENT COMPUTING THEORIES AND APPLICATIONS, PROCEEDINGS: WITH ASPECTS OF ARTIFICIAL INTELLIGENCE, 2007, 4682 : 493 - 504
  • [30] Selectivity estimation with density-model-based multidimensional histogram
    Zhang, Meifan
    Wang, Hongzhi
    KNOWLEDGE AND INFORMATION SYSTEMS, 2021, 63 (04) : 971 - 992