Improving Query Performance Using Materialized XML Views: A Learning-Based Approach

We consider the problem of improving the efficiency of query processing on an XML interface of a relational database, for predefined query workloads. The main contribution of this paper is to show that selective materialization of data as XML views reduces query-execution costs in relatively static databases. Our learning-based approach precomputes and stores (materializes) parts of the answers to the workload queries as clustered XML views. In addition, the data in the materialized XML clusters are periodically incrementally refreshed and rearranged, to respond to the changes in the query workload. Our experiments show that the approach can significantly reduce processing costs for frequent and important queries on relational databases with XML interfaces.

• Type: Conference
• Year: 2003
• Where: ER
• Authors: Ashish Shah, Rada Chirkova
• Keywords: ER 2003, Query Workload, Xml Interfaces, XML Views