Manage relational data in IBM Visual Studio 2005 .NET using DB2 XML shredding feature
Manage relational data in IBM Visual Studio 2005 .NET using DB2 XML shredding feature
The annotated XML schema decomposition feature introduced in DB2 9, can be used to decompose entire or fragment(s) of XML documents into relational tables. DB2 9 XML shredding technology uses annotations in XML Schema as the mapping language to map information in an XML document to relational tables. The DB2 XML decomposition uses annotated XML Schema to obtain mapping information. Annotations added to the XML schema do not participate in validation of XML documents. So, we can use the same XML schema for both mapping and validation of XML documents. In this article, I’ll show you detailed example of how to use DB2 Visual Studio 2005 add-in to build application that use DB2’s version 9 XML shredding technology, which allows XML to be shredded, stored and validated into relational table.