 | Level: Intermediate Ioana Ursu (ursu@us.ibm.com), Advisory Software Engineer, IBM
Aakash Bordia (bordia@us.ibm.com), Advisory Software Engineer, IBM
Eileen Lin (etlin@us.ibm.com), Senior Technical Staff Member, IBM
15 May 2008 XML Federation in WebSphere® Federation Server Version 9.5 allows you to
seamlessly integrate with remote XML data from XML documents and DB2® for
Linux®, UNIX®, and Windows® (DB2) sources enabled with pureXML technology.
Not only can you use the SQL/XML and XQuery languages to manipulate remote XML data,
you can also perform other operations such as decomposition, schema validation, and
executing XML utilities. In this article, you'll walk through various use cases to help you build your distributed XML applications quickly. Objectives - Take advantage of the XML Federation feature in WebSphere Federation Server
Version 9.5
- Walk through various use cases to demonstrate the use of the SQL/XML and the
XQuery languages to manipulate your remote XML data
- Learn about related XML support, such as IMPORT, EXPORT, XML schema validation, and
decomposition
Prerequisites
You should have prior knowledge and experience working with DB2 and WebSphere
Federation Server.
System requirements
You must have WebSphere Federation Server Version 9.5 installed and running on your
machine. You also need to have a DB2 9.1 instance and database available as a remote
DB2 data source to be accessed in the examples. Alternatively, you can also use another database on the same WebSphere Federation Server Version 9.5 instance as the remote DB2 data source.
Formats html, pdf
Tutorial overview
IBM® WebSphere Federation Server provides real-time, virtualized access to disparate data sources. As a result, you benefit from delivering new projects with a much shorter time to market, extending your warehouse with ad-hoc queries, and producing a unified view for your enterprise data.
With the XML Federation feature, WebSphere Federation Server Version 9.5 provides direct access to remote XML data in DB2 and XML documents. You can create a relational nickname over a remote table or view that contains the XML data type. You can also use the XML wrapper to create a nonrelational nickname that contains the XML data type over XML documents.
You can use these nicknames in the XQuery and SQL languages. The XQuery language is the
primary mechanism for querying XML documents. You can use SQL to perform basic operations, such as selecting XML columns, and inserting, updating, or deleting XML data. You can also integrate SQL and XQuery to create queries for both existing relational data and XML data by using SQL/XML functions and predicates, and XQuery functions.
In addition, you can perform a sub-document update, which allows portions of an XML document to be updated. Also, the federated server can validate remote XML data. XML validation is the process of determining whether the structure, content, and data types of an XML document are valid. Finally, with annotated XML schema decomposition, you can decompose documents in columns of one or more nicknames.
| | | |
