Get an XML View of Relational Tables -- XML for Tables from IBM alphaWorks provides an XML view of DB2 relational tables and lets you query those views as if they were XML documents. ++ Tags: Database, Database Development, Database Management, Developme

Comment on this topic

IBM alphaWorks is offering a Java-based tool for download that gives you an XML view of DB2 relational tables and lets you query those views as if they were XML documents.

XML for Tables runs on Windows and UNIX and lets you publish XML documents from relational data. IBM says the benefit of the technology is it connects Internet applications and other XML-based applications with relational database technology and current storage of business data.

As the company explains, SQL language is typically used to query relational tables. XML for Tables lets you query SQL data (stored in the relational tables) in a new language, XQuery, currently undergoing W3C approval (see http://www.w3.org/TR/xquery). It includes functions for creating XML views of relational tables in such a way that SQL data is treated like virtual XML documents that can be queried in XQuery.

Here's how the process works:

XML for Tables translates XQuery into SQL and pushes down SQL to DB2.
The SQL queries produce output.
XML for Tables tags that output into XML so the XQuery results are in an XML document.

XML for Tables is wrapped as DB2 stored procedures. You submit queries by calling the stored procedures.

To use the tool, you need DB2 8 and Java Development Kit (JDK) 1.3 or above

In addition, you must have the DB2Admin authority to perform the tasks and your DB2PATH must be set to the following /home/db2/sqllib on UNIX or C:\sqllib on Windows.

You can download the software free of charge at http://www.alphaworks.ibm.com/tech/xtable.

TECH NEWS

Get an XML View of Relational Tables

XML for Tables from IBM alphaWorks provides an XML view of DB2 relational tables and lets you query those views as if they were XML documents.

Get an XML View of Relational Tables

No reader comments ... yet.

What do YOU think about this topic? Share your advice and thoughts using this form.

Your Name

REQUIRED : PUBLIC

Your E-Mail

REQUIRED : PRIVATE

Job, Company

OPTIONAL : PUBLIC

City, State, Country

OPTIONAL : PUBLIC

Your Web Site

OPTIONAL : PUBLIC

Your Comment

Please help everyone by keeping your comments on-topic, using clean language, and not defaming or making personal attacks.

Your e-mail address is required, but it will not be displayed to the public or given to anyone. See our Privacy Policy. Comments become visible after they pass our spam filter, and spammers and abusers are permanently blocked. Please report spam or abuse.

ARTICLE INFO

Web Edition: 2003.04.28, Doc #12292

FREE ACCESS

MORE ADVISOR