7.5. Providing Relational Views over XML
In many cases, data will be sent to the database server in the form of an XML message that needs to be integrated with the relational data after optionally performing some business logic over the data inside a stored procedure on the server. This requires programmatic access to the XML data from within a stored procedure. Unfortunately, neither the DOM nor SAX provides a well-suited surface API for dealing with XML data in a relational context. Instead the new API needs to provide a relational view over the XML data—that is, it needs to allow the SQL programmer to shred an XML message into different relational views.
SQL Server 2000 provides such a rowset mechanism over XML by means of the OpenXML rowset ...
Get XML Data Management: Native XML and XML-Enabled Database Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
