Issue No.08 - August (2010 vol.22)
Ying Zhang , Centrum Wiskunde & Informatica, Amsterdam
Nan Tang , Centrum Wiskunde & Informatica, Amsterdam
Peter Boncz , Centrum Wiskunde & Informatica, Amsterdam
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/TKDE.2010.62
We investigate techniques to automatically decompose any XQuery query—including updating queries specified by the XQuery Update Facility (XQUF)—into subqueries, that can be executed near their data sources, i.e., function-shipping. The main challenge addressed here is to ensure that the decomposed queries properly respect XML node identity and preserve structural properties, when (parts of) XML nodes are sent over the network, effectively copying them. We start by precisely characterizing the conditions, under which pass-by-value parameter passing causes semantic differences between remote execution of an XQuery expression and its local execution. We then formulate a conservative strategy that effectively avoids decomposition in such cases. To broaden the possibilities of query distribution, we extend the pass-by-value semantics to a pass-by-fragment semantics, which keeps better track of node identities and structural properties. The pass-by-fragment semantics is subsequently refined to a pass-by-projection semantics by means of a novel runtime XML projection technique, which safely eliminates most semantic differences between the local and remote execution of an XQuery expression, and strongly reduces message sizes. Finally, we discuss how these techniques can be used for updating queries, both under the standard W3C XQUF specification, as well as under an extended semantics that allows to update remote documents. The proposed techniques are implemented in XRPC, a simple yet efficient XQuery extension that enables function-shipping by adding a Remote Procedure Call mechanism to XQuery. Experiments on MonetDB/XQuery establish the performance potential of our XQuery decomposition techniques.
Distributed databases, XQuery decomposition.
Ying Zhang, Nan Tang, Peter Boncz, "Projective Distribution of XQuery with Updates", IEEE Transactions on Knowledge & Data Engineering, vol.22, no. 8, pp. 1059-1076, August 2010, doi:10.1109/TKDE.2010.62