ROX: The Robustness of a Run-time XQuery Optimizer Against Correlated Data


Share/Save/Bookmark

Abdel Kader, Riham and Boncz, Peter and Manegold, Stefan and Keulen van, Maurice (2010) ROX: The Robustness of a Run-time XQuery Optimizer Against Correlated Data. In: 26th International Conference on Data Engineering, ICDE 2010, 1-6 March 2010, Long Beach, California, USA. (In Press)

[img]PDF
Restricted to UT campus only
: Request a copy
249Kb
Abstract:We demonstrate ROX, a run-time optimizer of XQueries, that focuses on finding the best execution order of XPath steps and relational joins in an XQuery. The problem of join ordering has been extensively researched, but the proposed techniques are still unsatisfying. These either rely on a cost model which might result in inaccurate estimations, or explore only a restrictive number of plans from the search space. ROX is developed to tackle these problems. ROX does not need any cost model, and defers query optimization to run-time intertwining optimization and execution steps. In every optimization step, sampling techniques are used to estimate the cardinality of unexecuted steps and joins to make a decision which sequence of operators to process next. Consequently, each execution step will provide updated and accurate knowledge about intermediate results, which will be used during the next optimization round. This demonstration will focus on: (i) illustrating the steps that ROX follows and the decisions it makes to choose a good join order, (ii) showing ROX’s robustness in the face of data with different degree of correlation, (iii) comparing the performance of the plan chosen by ROX to different plans picked from the search space, (iv) proving that the run-time overhead needed by ROX is restricted to a small fraction of the execution time.
Item Type:Conference or Workshop Item
Copyright:© 2011 IEEE
Faculty:
Electrical Engineering, Mathematics and Computer Science (EEMCS)
Research Group:
Link to this item:http://purl.utwente.nl/publications/67868
Official URL:http://dx.doi.org/10.1109/ICDE.2010.5447765
Export this item as:BibTeX
EndNote
HTML Citation
Reference Manager

 

Repository Staff Only: item control page

Metis ID: 270690