![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
IBM and Altova provide deep integration between the world's first multi-structured data server with the industry's premier XML tools. Through this integration, users can query, exchange, transform, and edit their XML artifacts more quickly, easily, and accurately. This article shows a variety of pureXML features in DB2 and demonstrates how the Altova tools can help the user to work with them.
This article demonstrates how to do the following:
- Visualize the database structure and work with the database objects using the GUIs.
- Easily query the database tables using SQL, SQL/XML, and XQuery statements or run other database transactions such as the one creating an XML index.
- Edit and debug XQuery statements with a graphical editor.
- Edit the XML data retrieved from the database, validate it and save it back using a GUI.
- Manage XML Schemas stored in the DB2 Schema Repository.
- Transform the XML data to different formats and use data filtering.
Even though this article is quite detailed, it is not meant to cover all functionality available in the Altova tools for DB2. Only the most important new functionality related to pureXML is demonstrated (using the SAMPLE database with XML extensions that comes with DB2). The material presented is not basic XML. Some knowledge of XML itself and pureXML in DB2 is assumed. The actual support of DB2 pureXML is much richer than what is shown in this article.
- Database developers, administrators and users; data integration specialists; software developers
- People who know DB2 pureXML but lack knowledge of the Altova tools, or vice versa
- People new to XML technologies, pureXML in DB2 and to Altova tools and willing to do a little pre-work to get an understanding of how they can benefit from the IBM/Altova integrated solution when learning these technologies
| Description | Name | Size | Download method |
|---|---|---|---|
| Article in PDF format | Altova_with_DB2.pdf | 1.8MB | HTTP |
Information about download methods Get Adobe® Reader®
Learn
- Read more articles and tutorials and access resources on
Information Management and XML technogy on developerWorks.
- For more information on pureXML with DB2, visit
the DB2 pureXML technology page on ibm.com.
- Learn more about the Altova tools at the
Altova Web site.
-
Visit the developerWorks resource page for DB2 for Linux, UNIX, and Windows to read articles and tutorials and connect to other resources to expand your DB2 skills.
-
Learn about DB2 Express-C, the no-charge version of DB2 Express Edition for the community.
-
Browse the technology bookstore for books on these and other technical topics.
Get products and technologies
-
Download a free trial version of DB2 Enterprise 9.
-
Now you can use DB2 for free. Download DB2 Express-C, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edtion and provides a solid base to build and deploy applications.
-
Download IBM product evaluation versions and get your hands on application development tools and middleware products from DB2, Lotus®, Rational®, Tivoli®, and WebSphere®.
Discuss
- Participate in the discussion forum.
-
Check out developerWorks
blogs and get involved in the developerWorks community.
Irina Kogan is a software engineer at IBM Toronto Lab working on XML performance in DB2 with both developers and customers. Her areas of interest include XML storage and structural updates, XQuery, OLTP and benchmark development. Irina has B.Sc. and M.Sc. in computer science from York University. Her Masters degree focused on semantic integrity and good design principles in databases. Before joining IBM in 2004, she worked on XML and Java development at Siemens in Germany.
