Use DB2 native XML with PHP

Leverage DB2 native XML functionality and PHP to simplify apps using XML data

From the developerWorks archives

Hardeep Singh and Amir Malik

Date archived: January 11, 2017 | First published: October 27, 2005

Learn about the effectiveness of using the native XML capabilities coming in the next version of DB2® Universal Database™ for Linux®, UNIX®, and Windows® to simplify application code and the relational schemas. This article looks at the impact of schema evolution on the application and walks the reader through a usage scenario to illustrate the ease of setting up a PHP environment; the ease of integrating DB2 native XML functionality with PHP applications, including Web services written in PHP and XQuery; and the benefit of pushing the business logic and data transformations into the database, using XQuery, stored procedures, and views. To highlight the impact of using DB2 native XML support on PHP application code and relational schema design, the scenario creates a parallel environment using a database that does not have any XML capabilities (for example, MySQL). We show the difference in the application code, database queries, and the relational schemas for the two environments.

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.

Zone=Information Management, XML, SOA and web services
ArticleTitle=Use DB2 native XML with PHP