loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
19th International Conference on Data Engineering (ICDE'03)
Structural Join Order Selection for XML Query Optimization
Bangalore, India
March 05-March 08
ISBN: 0-7803-7665-X
Yuqing Wu, Univ. of Michigan
Jignesh M. Patel, Univ. of Michigan
H. V. Jagadish, Univ. of Michigan
Structural join operations are central to evaluating queries against XML data, and are typically responsible for consuming a lion?s share of the query processing time. Thus, structural join order selection is at the heart of query optimization in an XML database, just as (value-based) join order selection is central to relational query optimization.
In this paper, we introduce five algorithms for structural join order optimization for XML tree pattern matching and present an extensive experimental evaluation. Our experiments demonstrate that many relational rules of thumb are no longer appropriate: for instance, using dynamic programming style optimization is not efficient; limiting consideration to left-deep plans usually misses the best solution. Our experiments also show that a Dynamic Programming optimization with Pruning (DPP) algorithm can find the optimal solution, with low cost relative to the traditional Dynamic Programming (DP) algorithm; and an optimization technique that only considers Fully Pipelined (FP) plans can very quickly choose a plan that in most cases is close to optimal. Our recommendation is that DPP should be used in XML query optimizers where query execution time is expected to be significant, and that FP should be used where it is important to find a good (but not necessarily the best) plan quickly.
Citation:
Yuqing Wu, Jignesh M. Patel, H. V. Jagadish, "Structural Join Order Selection for XML Query Optimization," icde, pp.443, 19th International Conference on Data Engineering (ICDE'03), 2003
Usage of this product signifies your acceptance of the Terms of Use.