Recommending XMLTable Views for XQuery Workloads

  • Authors:
  • Iman Elghandour;Ashraf Aboulnaga;Daniel C. Zilio;Calisto Zuzarte

  • Affiliations:
  • University of Waterloo,;University of Waterloo,;IBM Toronto Lab,;IBM Toronto Lab,

  • Venue:
  • XSym '09 Proceedings of the 6th International XML Database Symposium on Database and XML Technologies
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

Physical structures, for example indexes and materialized views, can improve query execution performance by orders of magnitude. Hence, it is important to choose the right configuration of these physical structures for a given database. In this paper, we discuss the types of materialized views that are suitable for an XML database. We then focus on XMLTable materialized views and present a procedure to recommend them given an XML database and a workload of XQuery queries. We have implemented our XMLTable View Advisor in a prototype version based on IBM® DB2® V9.7, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor's recommendations.