Pattern Tree Algebras: Sets or Sequences?

XML and XQuery semantics are very sensitive to the order of the produced output. Although pattern-tree based algebraic approaches are becoming more and more popular for evaluating XML, there is no universally accepted technique which can guarantee both a correct output order and a choice of efficient alternative plans. We address the problem using hybrid collections of trees that can be either sets or sequences or something in between. Each such collection is coupled with an Ordering Specification that describes how the trees are sorted (full, partial or no order). This provides us with a formal basis for developing a query plan having parts that maintain no order and parts with partial or full order. It turns out that duplicate elimination introduces some of the same issues as order maintenance: it is expensive and a single collection type does not always provide all the flexibility required to optimize this properly. To solve this problem we associate with each hybrid collection ...

• Type: Conference
• Year: 2005
• Where: VLDB
• Authors: Stelios Paparizos, H. V. Jagadish
• Keywords: Correct Output Order, Database, Efficient Alternative Plans, Hybrid Collection, VLDB 2005