Dependable cardinality forecasts for XQuery

Jens Teubner, Torsten Grust, Sebastian Maneth, Sherif Sakr

Research output: Contribution to journalArticlepeer-review

Abstract

Though inevitable for effective cost-based query rewriting, the derivation of meaningful cardinality estimates has remained a notoriously hard problem in the context of XQuery. By basing the estimation on a relational representation of
the XQuery syntax, we show how existing cardinality estimation techniques for XPath and proven relational estimation machinery can play together to yield dependable forecasts for arbitrary XQuery (sub)expressions. Our approach
benefits from a light-weight form of data flow analysis. Abstract domain identifiers guide our query analyzer through the estimation process and allow for informed decisions even in case of deeply nested XQuery expressions. A variant of projection paths [15] provides a versatile interface into which existing techniques for XPath cardinality estimation can be plugged in seamlessly. We demonstrate an implementation of this interface based on data guides. Experiments show how our approach can equally cope with both, structureand
value-based queries. It is robust with respect to intermediate estimation errors, from which we typically found our implementation to recover gracefully.
Original languageEnglish
Pages (from-to)463-477
Number of pages15
JournalProceedings of the VLDB Endowment (PVLDB)
Volume1
Issue number1
Publication statusPublished - 2008

Fingerprint

Dive into the research topics of 'Dependable cardinality forecasts for XQuery'. Together they form a unique fingerprint.

Cite this