The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Use an XML database in PHP and Java applications

Understand the benefits of using a native XML database

Tyler Anderson (tyleranderson5@yahoo.com), Freelance writer and developer, Backstop Media

Tyler Anderson has graduated with a degree in computer science in 2004 and a Master of Science degree in computer engineering in December, 2005, both from Brigham Young University. Tyler is currently a freelance writer and developer for Backstop Media.

Summary: Native XML databases have grown in popularity along with XML, because data is stored as native XML, rather than through tables in a traditional database. Using a native XML database means that a change to the schema requires minimal changes to your code and no change to the database. PHP and Java ™developers can benefit greatly from using native XML databases. In this tutorial, you will get quickly up to speed using a native XML database and see how to use it to benefit XML development.

Date: 25 Mar 2008
Level: Intermediate
PDF: A4 and Letter (1511 KB)Get Adobe® Reader®

Activity: 43607 views
Comments:

Resources

Learn

Query DB2 XML Data with SQL (Cynthia Saracco, developerWorks, March 2006): Check out this interesting article for all sorts of things you can do using SQL/XML.
Managing XML for Maximum Return (C. M. Saracco, IBM, November 2005): In this white paper, explore the business benefits of DB2's XML support.
Overview on DB2's XML Capabilities (Cindy Wong, developerWorks, November 2003): See the SQL/XML functions available with DB2 UDB version 8 and the DB2 XML Extender.
XML programming with SQL/XML and XQuery (J. E. Funderburk, S. Malaika, and B. Reinwald; IBM Systems Journal Vol 41, No 4; 2002 ): In this IBM research paper, read about the integrated database architecture that enables SQL apps with XML extensions and XQuery apps to operate on the same data. The architecture allows for a seamless flow from relational data to XML and back.
IBM DB2 pureXML technology: Learn how pureXML revolutionized support for XML data by handling XML as a new data type that is stored in a natural hierarchy. Speed app development through seamless integration of XML with relational data as you improve search performance, and query XML data with SQL and XQuery.
DB2 home page:Transform your data center with industry-leading performance, scale, and reliability on your choice of platform from Linux to z/OS.
Introduction to XML tutorial (Doug Tidwell, developerWorks, August 2002): Need a more basic introduction to XML? Try the this tutorial and other educational offerings, which cover the most fundamental topics.
XML and Java technology: A return to basics (Brett McLaughlin, developerWorks, October 2007): In this article, revisit some XML basics, from document structure to the age-old attributes versus elements issue.
DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java and .NET (Whei-Jen Chen, John Chun, Naomi Ngan, Rakesh Ranjan, and Manoj K. Sardana; August 2006): See this IBM Redbook for more on PHP, Java and other languages, including Ruby on Rails.
XML.com: Visit O'Reilly's XML site, for comprehensive coverage of the XML world.
Reading and writing the XML DOM in PHP (Jack Herrington, developerWorks, December 2005): Explore three methods for reading XML: the DOM library, SAX parser, and regular expressions.
IBM XML certification: Find out how you can become an IBM-Certified Developer in XML and related technologies.
XML technical library: See the developerWorks XML Zone for a wide range of technical articles and tips, tutorials, standards, and IBM Redbooks.
developerWorks XML zone: Learn all about XML.
developerWorks technical events and webcasts: Stay current with technology in these sessions.
The technology bookstore: Browse for books on these and other technical topics.
Podcasts: Tune in and catch up with IBM technical experts.
Open source developer events: Check out upcoming conferences, trade shows, webcasts, and other events around the world that are of interest to IBM open source developers.

Get products and technologies

IBM trial software: Build your next development project with trial software available for download directly from developerWorks.
PHP: Download the latest version of PHP, 5.2.5 at the time of this writing.
Apache2: Download the Apache2 HTTP server, recommended as your HTTP server for PHP.
Java SDK: Download the latest JDK from Sun to run and compile Java. This tutorial uses version Java 6 update 5.
Apache Tomcat: Get Apache Tomcat as the Web server that will host your Java applications. This tutorial uses version 6.0.16.
DB2 Express-C 9.5: Download and try the XML database used for this tutorial.

Discuss

XML zone discussion forums: Participate in any of several XML-related discussions.
developerWorks XML zone: Share your thoughts: After you read this article, post your comments and thoughts in this forum. The XML zone editors moderate the forum and welcome your input.
developerWorks blogs: Check out these blogs and get involved in the developerWorks community.