Level: Intermediate Gerald Leung (gktleung@ca.ibm.com), Database Technology Advocate, IBM
Grant Hutchison (ghutchis@ca.ibm.com), Senior Product and Release Manager, IBM
01 Jun 2006 The DB2 XML evaluation guide is a step-by-step tutorial to introduce the reader to the DB2® Viper data server on Windows® platforms using the XML storage and searching (SQL/XML, XQuery) capabilities available to support next-generation applications.
Prerequisites
This tutorial is written for database administrators who have limited experience with DB2 Viper and have some experience with SQL and some knowledge of XML.
System requirements
To run the examples in this tutorial, you need a Windows 2000 or higher machine with an account having administrator privileges.
Duration
Less than 1 hour
Formats html, pdf
About this tutorial
DB2 Viper is the industry's first hybrid data server for managing data from both relational and pure XML formats. DB2 has been providing high-performance data storage and access for relational data based on SQL standards and data storage optimizations such as data partitioning and advanced indexing and query optimization techniques. Now, DB2 has introduced an optimized data storage engine for XML data alongside the existing relational engine.
Application developers can now store XML data directly inside a DB2 server and reap the benefits of transactions, advanced data resiliency, secure access, and, of course, the ability to search large amounts of XML data using XQuery.
XML data is often used for inter-application data exchange and document management purposes. The flexible and self-describing nature of XML data makes it ideal for many application scenarios.
The ability to query XML data has been quite limited. Recently, a new standards-based XML query language has been published. This query language is known as XQuery Version 1.0.
XQuery Version 1.0 was released in November 2005 and it is an extension of the existing XPath Version 2.0 standard.
| 
