Materialized view selection for XQuery workloads

  • Authors:
  • Asterios Katsifodimos;Ioana Manolescu;Vasilis Vassalos

  • Affiliations:
  • INRIA Saclay & Université Paris-Sud, Saclay, Île-de-France, France;INRIA Saclay & Université Paris-Sud, Saclay, Île-de-France, France;Athens University of Economics and Business, Athens, Greece

  • Venue:
  • SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

The efficient processing of XQuery still poses significant challenges. A particularly effective technique to improve XQuery processing performance consists of using materialized views to answer queries. In this work, we consider the problem of choosing the best views to materialize within a given space budget in order to improve the performance of a query workload. The paper is the first to address the view selection problem for queries and views with value joins and multiple return nodes. The challenges we face stem from the expressive power and features of both the query and view languages and from the size of the search space of candidate views to materialize. While the general problem has prohibitive complexity, we propose and study a heuristic algorithm and demonstrate its superior performance compared to the state of the art.