Visualizing cost-based XQuery optimization

Abstract— Developing a full-fledged cost-based XQuery optimizer is a fairly complex task. Nowadays, there is little knowledge concerning suitable cost formulae and optimization strategies for exploring and constraining the tremendously large search space. To allow for a fair assessment of different optimization strategies, physical algebra operators, and indexing approaches, we developed an extensible optimization framework. The framework is accompanied by a supportive visual explain tool that enables user interactions to refine the inspection and the comprehension of the query plans proposed. Using this tool, the optimizer can be dynamically reconfigured and the impact of different optimization strategies on the final query execution plan can be immediately visualized.

• Type: Conference
• Year: 2010
• Where: ICDE
• Authors: Andreas M. Weiner, Theo Härder, Renato Oliveira da Silva
• Keywords: Cost-based Xquery Optimizer, Database, Extensible Optimization Framework, ICDE 2010, Optimization Strategies