Asymmetric notation of a left or right outer join
For the last case of the full outer join, the required XQuery query pattern is demonstrated on the example of the previous section in two…
Formulation of a full outer join
Now, the alternative asymmetric formulation of a left or right outer join shown on the previous page can be used in order to formulate a full outer join in XQuery.…
Grouping and aggregation
Apart from the joins, the groupping with subsequent aggregation represents the central type of transformations on data stocks which have to be described with the help of…
Grouping according to structure
The first step of the grouping means that only one representative from a set of items with equal manifestations with regard to the grouping attribte is taken…
Grouping according to equality of values
The second method of a grouping in XQuery is closer to the relational method to the extent that the group definition is…
Aggregation functions
In XQuery the aggregation is based on the formulation in OQL, whereby the "classic" aggregation functions fn:sum(), fn:avg(), fn:count(), fn:min()…
Grouping via several attributes
If facts are to be designated according to different criteria, a grouping via several attributes is required. Analogous to the relational or…
Group filtering and sorting
The check for existence of an item via which aggregation shall be made in order to eliminate empty grouping combinations essentially corresponds to the construct of…
Multiple grouping
The principle of the multiple grouping is applied if within a single query the original data stock shall be grouped multiple times according to different criteria. Multiple…
Nested grouping
XQuery is provided with an extremely mighty feature based on the principle of the application of aggregation functions on sequences, namely the ability of the nesting with…