A relational model for XML structural joins and their size estimations

被引:0
|
作者
Cheng Luo
Zhewei Jiang
Wen-Chi Hou
Feng Yan
Qiang Zhu
机构
[1] Southern Illinois University Carbondale,Department of Computer Science
[2] University of Michigan-Dearborn,Department of Computer and Information Science
来源
关键词
Semi-structured databases; XML databases; Query optimization; Selectivity estimation;
D O I
暂无
中图分类号
学科分类号
摘要
XML structural joins, which evaluate the containment (ancestor-descendant) relationships between XML elements, are important operations of XML query processing. Estimating structural join size accurately and quickly is crucial to the success of XML query plan selection and the query optimization. XML structural joins are essentially complex θ-joins, which render well-known estimation techniques for relational equijoins, such as discrete cosine transform, wavelet transform, and sketch, not applicable. In this paper, we model structural joins from a relational point of view and convert the complex θ-joins to equijoins so that those well-known estimation techniques become applicable to structural join size estimation. Theoretical analyses and extensive experiments have been performed on these estimation methods. It is shown that discrete cosine transform requires the least memory and yields the best estimates among the three techniques. Compared with state-of-the-art method IM-DA-Est, discrete cosine transform is much faster, requires less memory, and yields comparable estimates.
引用
收藏
页码:97 / 127
页数:30
相关论文
共 50 条
  • [1] A relational model for XML structural joins and their size estimations
    Luo, Cheng
    Jiang, Zhewei
    Hou, Wen-Chi
    Yan, Feng
    Zhu, Qiang
    [J]. KNOWLEDGE AND INFORMATION SYSTEMS, 2008, 16 (01) : 97 - 127
  • [2] Worst Case Optimal Joins on Relational and XML data
    Chen, Yuxing
    [J]. SIGMOD'18: PROCEEDINGS OF THE 2018 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2018, : 1833 - 1835
  • [3] Size Bounds and Query Plans for Relational Joins
    Atserias, Albert
    Grohe, Martin
    Marx, Daniel
    [J]. PROCEEDINGS OF THE 49TH ANNUAL IEEE SYMPOSIUM ON FOUNDATIONS OF COMPUTER SCIENCE, 2008, : 739 - +
  • [4] SIZE BOUNDS AND QUERY PLANS FOR RELATIONAL JOINS
    Atserias, Albert
    Grohe, Martin
    Marx, Daniel
    [J]. SIAM JOURNAL ON COMPUTING, 2013, 42 (04) : 1737 - 1767
  • [5] Using Structural Joins and Holistic Twig Joins for Native XML Query Optimization
    Weiner, Andreas M.
    Haerder, Theo
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, PROCEEDINGS, 2009, 5739 : 149 - 163
  • [6] Structural joins: A primitive for efficient XML query pattern matching
    Al-Khalifa, S
    Jagadish, HV
    Koudas, N
    Patel, JM
    Srivastava, D
    Wu, YQ
    [J]. 18TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2002, : 141 - 152
  • [7] Mapping XML to object relational model
    Nishioka, S
    Onizuka, M
    [J]. IC'2001: PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON INTERNET COMPUTING, VOLS I AND II, 2001, : 178 - 184
  • [8] Labeling scheme and structural joins for graph-structured XML data
    Wang, HZ
    Wang, W
    Lin, XM
    Li, JZ
    [J]. WEB TECHNOLOGIES RESEARCH AND DEVELOPMENT - APWEB 2005, 2005, 3399 : 277 - 289
  • [9] XR-tree: Indexing XML data for efficient structural joins
    Jiang, HF
    Lu, HJ
    Wang, W
    Ooi, BC
    [J]. 19TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2003, : 253 - 264
  • [10] A GENERALIZATION OF RELATIONAL JOINS
    KARPOV, AO
    [J]. PROGRAMMING AND COMPUTER SOFTWARE, 1989, 15 (02) : 64 - 70