New options for XML data integrity and validation in DB2 V9.5

Validation through CHECK constraint, trigger support

From the developerWorks archives

Manoj Sardana and Madhavi Kaza

Date archived: January 11, 2017 | First published: August 27, 2009

IBM® DB2® for Linux®, UNIX®, and Windows® introduced pureXML® technology in Version 9. This technology allows you to store XML data in its native form, maintaining the hierarchical structure and permitting you to query it using SQL/XML and XQuery. Just as with relational data, the ability to ensure the integrity of XML data stored in DB2 is mandatory. The methods and mechanisms for ensuring the integrity of XML data, however, are a bit different than the methods for traditional relational data integrity. In this article, you'll learn about XML data integrity in the context of DB2, and explore the various options you have to guarantee integrity in different scenarios.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, XML
ArticleID=422495
ArticleTitle=New options for XML data integrity and validation in DB2 V9.5
publish-date=08272009