XML shredding is the process of extracting values from XML documents and using them to update tables in the database. This is done based on a user-defined mapping specification that maps the XML structure to the target tables.
For example, you can perform these typical tasks to shred XML documents:
- Load the XML document to be shredded into an XML column of a staging table.
Define an SQL query that returns a result set with 2 columns:
- An ID column
- The XML column that contains the XML document to be shredded
- Create an annotated schema that maps the XML document structure to the target tables.
- Store the mapping so that it can be easily referenced, for example, in a schema repository table.
Call the AS_SHRED_BATCH stored procedure with the following arguments:
- The SQL query you defined in step 2
- The annotated schema you saved in step 4