Managing Relational Views of XML Data - IBM Database Add-Ins for Visual Studio

When you use an XML schema document to provide a relational view of XML data, you must map the elements and attributes of the XML schema to tables and columns of the database. The rows in a database table or view can map to elements in the XML document. The column values in the database map to elements or attributes in the XML document. An XML schema document that contains mapping information is referred to as an annotated XML schema.

This section provides conceptual information and instructions for defining annotated XML schemas.

In this section:

Annotated XML Schemas: Conceptual information about annotated XML schemas.
Annotating XML Schemas: A summary of the steps for annotating XML schemas.
Selecting XML Schemas to Annotate: Instructions for selecting an XML schema to annotate.
Finding Relationships between Sources and Targets for XML Mapping: Instructions for finding the relationships between elements in the source XML schema and columns in relational tables for creating map links.
Adding Target Tables for XML Mapping: Instructions for selecting target tables in the database to use for creating map links in an annotated XML schema.
Adding Links for XML Mapping: Instructions for defining associations between elements and attributes in an XML schema and columns in database tables.
Finding Nodes, Elements, and Attributes in Source XML Schemas: Instructions for locating a node, element, or attribute in a source XML schema to create a map link.
Specifying Values for XML Map Link Properties: Instructions for specifying values for the properties that are associated with the map links in an annotated XML schema.
Hiding XML Mapping Items: Instructions for hiding target tables and map links to clear the work area in the mapping editor.
Showing Hidden XML Mapping Items: Instructions for redisplaying all hidden target tables and map links in the mapping editor.
Removing XML Mapping Items: Instructions for removing a target table or a map link from the mapping editor.
Reviewing Annotated XML source: Instructions for reviewing the XML source that is associated with the map links and the property values that have been specified in the annotated XML schema.
Saving Annotated XML Schemas: Instructions for saving an annotated XML schema and registering it in the XML Schema Repository.
Testing Annotated XML Schemas: Instructions for testing the annotated XML schema.

Managing Relational Views of XML Data (DB2)

In this section: