Title
Optimizing XML queries: Bitmapped materialized views vs. indexes
Abstract
Optimizing queries using materialized views has not been addressed adequately in the context of XML due to the many limitations associated with the definition and usability of materialized views in traditional XML query evaluation models. In this paper, we address the XML query optimization problem using materialized views in the framework of the inverted lists evaluation model which has been established as the most prominent one for evaluating queries on large persistent XML data. Under this framework, we propose a novel approach which instead of materializing the answer of a view materializes exactly the sublists of the inverted lists that are necessary for computing the answer of the view. A further originality of our approach is that the view materializations are stored as compressed bitmaps. This technique not only minimizes the materialization space but also reduces CPU and I/O costs by translating view materialization processing into bitwise operations. Our approach departs from the traditional approach which identifies a compensating expression that rewrites the query using the materialized views. Instead, it computes the query answer by executing holistic stack-based algorithms on the view materializations. We experimentally compared our approach with recent outstanding structural summary and B-tree based approaches. In order to make the comparison more competitive we also proposed an extension of a structural index approach to resolve combinatorial explosion problems. Our experimental results show that our compressed bitmapped materialized views approach is the most efficient, robust, and stable one for optimizing XML queries. It obtains significant performance savings at a very small space overhead and has negligible optimization time even for a large number of materialized views in the view pool.
Year
DOI
Venue
2013
10.1016/j.is.2013.02.003
Inf. Syst.
Keywords
Field
DocType
large persistent xml data,traditional approach,approach departs,novel approach,xml query optimization problem,optimizing xml query,view materialization,view materialization processing,views approach,view pool,structural index approach,xml
Query optimization,Data mining,Bitwise operation,Information retrieval,XML,Computer science,Usability,Originality,Bitmap,Materialized view,Combinatorial explosion,Database
Journal
Volume
Issue
ISSN
38
6
0306-4379
Citations 
PageRank 
References 
4
0.38
64
Authors
4
Name
Order
Citations
PageRank
Xiaoying Wu117415.05
Dimitri Theodoratos2750130.14
Wendy Hui Wang313313.82
Timos K. Sellis449701255.07