 | Level: Introductory Irina Kogan (ikogan@ca.ibm.com), DB2/XML Performance,
IBM
13 Dec 2007 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.
About this article
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.
Target audience
- 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
Download | Description | Name | Size | Download method |
|---|
| Article in PDF format | Altova_with_DB2.pdf | 1.8MB | HTTP |
|---|
Resources Learn
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
About the author | 
| | 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. |
Rate this content
| | | |
