Recommending XMLTable Views for XQuery Workloads

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 R DB2 R V9.7, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor’s recommendations.

• Type: Conference
• Year: 2009
• Where: XSYM
• Authors: Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Calisto Zuzarte
• Keywords: Database, Materialized Views, Physical Structures, XML Database, XSYM 2009