Cost-Sensitive Reordering of Navigational Primitives

We present a method to evaluate path queries based on the novel concept of partial path instances. Our method (1) maximizes performance by means of sequential scans or asynchronous I/O, (2) does not require a special storage format, (3) relies on simple navigational primitives on trees, and (4) can be complemented by existing logical and physical optimizations such as duplicate elimination, duplicate prevention and path rewriting. We use a physical algebra which separates those navigation operations that require I/O from those that do not. All I/O operations necessary for the evaluation of a path are isolated in a single operator, which may employ efficient I/O scheduling strategies such as sequential scans or asynchronous I/O. Performance results for queries from the XMark benchmark show that reordering the navigation operations can increase performance up to a factor of four.

• Type: Conference
• Year: 2005
• Where: SIGMOD
• Authors: Carl-Christian Kanne, Matthias Brantner, Guido Moerkotte
• Keywords: Asynchronous I/o, Database, Efficient I/o Scheduling, I/O Operations, SIGMOD 2005