Extending XQuery for Grouping, Duplicate Elimination, and Outer Joins
XML version
HTML version
PDF version
SVG versionTrack: Core Technologies, Storing XML
Audience Level: Technical View
Time: Tuesday, November 16 at 16:45
Keywords: XML, Query, XQuery, SQL, Group By, Distinct, Outer Join
Abstract:
XQuery is the W3C’s emerging language standard for querying and transforming XML. XQuery is a powerful, flexible language designed to query the many kinds of structured and unstructured data that XML can represent. Despite its power, certain familiar SQL query operations, such as grouping, duplicate elimination, and outer-joins, are either difficult or impossible to express “reasonably” in XQuery. These primitives are important for data-oriented applications of XML, particularly applications that have a need for reporting (e.g., for OLAP and statistical querying).
This paper presents a small set of XQuery extensions to enable grouping, duplicate elimination, and outer-join queries all to be expressed neatly within the XQuery language. The proposal does minimal “damage” to the XQuery standard; it generalizes the current FLWOR expression syntax of XQuery and requires no changes to the underlying XQuery data model. The extensions are slated to appear in the next major revision of the BEA XQuery engine and its encompassing products.
