Examples of mappings in annotated XML schema decomposition - IBM DB2 9.7 for Linux, UNIX, and Windows

rowSets in annotated XML schema decomposition
db2-xdb:rowSet identifies the target table into which a value is decomposed. This annotation can be set either to a table name or a rowSet name.

Decomposition annotation example: Mapping to an XML column
In annotated XML schema decomposition, you can map an XML fragment to a column defined using the XML data type.

Decomposition annotation example: A value mapped to a single table that yields a single row
Mapping a value from an XML document to a single table and column pair is a simple form of mapping in annotated XML schema decomposition. This example shows the simpler case of a one to one relationship between values in a rowSet.

Decomposition annotation example: A value mapped to a single table that yields multiple rows
Mapping a value from an XML document to a single table and column pair is a simple form of mapping in annotated XML schema decomposition. This example shows the more complex case of a one to many relationship between values in a rowSet.

Decomposition annotation example: A value mapped to multiple tables
A single value from an XML document can be mapped to multiple tables. This example shows how to annotate an XML schema document to map a single value to two tables.

Decomposition annotation example: Grouping multiple values mapped to a single table
In annotated XML schema decomposition, you can map multiple values from unrelated elements to the same table, while preserving the relationship between logically-related values. This is possible by declaring multiple rowSets, which are used to group related items to form a row, as shown in this example.

Decomposition annotation example: Multiple values from different contexts mapped to a single table
In annotated XML schema decomposition, you can map multiple values to the same table and column, such that a single column can contain values that have come from different parts of a document. This is possible by declaring multiple rowSets, as shown in this example.