Query and Manage XML Data with DB2 9

This course is designed to introduce the students to non-traditional ways of using DB2 to work with native XML data. It is also designed to enable database administrators to manage the DB2 - native XML environment.
The students query XML data stored in DB2 tables and create XML documents from traditional DB2 data. They access XML documents as though the documents were relational tables. This content is addressed in the first three days of class and can be taken by users or other personnel who only need to access XML data stored in DB2 tables.
In the last two days of class, the students store native XML data in DB2 and create XML indexes. They analyze plan information for queries and take steps for improving query execution. The course also teaches how to manage the XML schemas and the techniques available for decomposing the XML documents.
The course can be taken as two separate parts (CL121, CL141), but the first part is required and presumed for the second part. In both parts, IBM Optim Development Studio is used as a GUI environment after the student has learned how to handle the same actions through the basic commands.
Course Materials
The course materials address DB2 9.7 for Linux, UNIX, and Windows.
Training Path
This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.
Určeno pro
This course is for:
• Users
• Database administrators
• Anyone interested in learning how to retrieve native XML data and how to handle native XML data in DB2
This course is appropriate for students using DB2 in a z/Linux environment.
Předpokládané znalosti
The students should have a working knowledge of SQL and DB2 concepts.
It would be helpful to have an introductory knowledge of XML, XML-related concepts - but the course is designed not to assume any prior knowledge of XML and related matters.
Cíl kurzu
• List the primary features of XML documents, XML namespaces, and XML schemas
• Use XQuery to retrieve documents from an XML column
• Use SQL/XML retrieval, publishing, and shredding functions
• Develop simple stored procedures and user-defined functions that handle XML documents
• Query XML documents using advanced query techniques
• Use Optim Development Studio to perform both XQuery and SQL queries using SQL/XML
• Establish the environment to store native XML data in DB2
• Create XML indexes for efficient retrieval of XML data
• Work with compression for XML data and XML indexes
• Analyze query executions and what you can do to improve the query performance
• Validate and register XML schemas using commands
• Annotate XML schemas and decompose XML documents using commands
• Use Optim Development Studio to annotate XML schemas for decomposition, and register XML schemas for validation, decomposition, or both
Klíčová témata
XML basics
• Explain the business value of using XML technology
• Describe why and when XML can be advantageous
• Differentiate between relational data and XML
• Determine whether a given XML document follows the basic XML standards
XML Namespaces
• Explain the need for and importance of namespaces
• List the rules for defining and using namespaces within an XML document
• Use namespaces in common scenarios
XML Schemas
• Describe the alternative approaches to schemas for XML
• Identify the components of a DTD and how they are used
• Define the components and constructs that make up an XML schema
• Identify approaches to using XML schemas for XML document processing
• Create a simple XML schema
• Validate an XML document against an XML schema
Introduction to XPath
• Describe the reasons for using XPath
• Define the components and constructs that make up the XPath language
• Identify abbreviated XPath expressions
• Write simple XPath expressions to navigate through XML documents
Introduction to XQuery
• Describe the XQuery and XPath data model
• Retrieve DB2 data using XQuery functions
• Construct the most often used FLWOR (for, let, where, order by, and return) expression
SQL/XML
• using the SQL/XML built-in functions, Retrieve XML data, Publish XML data, and Shred XML data
Updating and Transforming XML Documents
• List the common methods that can be used to update or transform XML documents
• Describe the reasons for using TRANSFORM
• Use the TRANSFORM clause to COPY, MODIFY, and RETURN results
• Use the TRANSFORM clause to replace values and nodes, to insert nodes, delete nodes, and rename nodes in an existing XML document
• Describe the purpose and functionality of XSLT transformations
Introduction to Programming with XML
• Use IBM Optim Development Studio to develop basic stored procedures, triggers, and user-defined functions that handle XML documents
• Pass XML parameters to stored procedures and user-defined functions
• Compare modes of access to XML data from common programming languages
• List XML features that are available through various programming languages
• List XML capabilities available through Java programming
Advanced queries
• Use conditional (if-then-else) logic
• Include arithmetic calculations
• Join XML data in different tables
• Join relational and XML data
• Embed XQuery inside SQL
• Pass parameters
IBM Optim Development Studio and XML Queries
• Create XML queries (XMLQUERY) using the query builder
• Create queries containing SQL/XML using the query builder
Introduction to XML storage
• Distinguish between transient and persistent XML data types
• Describe how XML data is stored in DB2
• Use different techniques to handle XML data in and out of XML storage
• Use EXPORT, IMPORT, and LOAD utilities with XML data
XML Indexing
• Describe the new index structure
• Create indexes on XML columns
• Explain the DB2 catalog changes to support the new index structure
• Use db2dart tool to format the index
Compression for XML Data and XML Indexes
• Discuss the pros and cons of compressing XML data and XML indexes
• List the mechanisms used to compress the XML data and XML indexes
• Run administrative functions to determine the storage savings achievable or achieved by XML data and XML index compression
Optimization and performance
• Discuss the pros and cons of the different options for querying XML data
• Design XML queries and indexes in a consistent manner so that indexes can be used as much as possible
• Describe other XML performance guidelines, for example, for XML inserts and XML schema validation
XML schema management
• Register XML schema
• Validate XML document using XML schema
• Remove XML schema
• Administer Grant and Revoke privileges
XML decomposition
• Annotate XML schema for a document
• Decompose XML document
• Control what data is inserted
Optim Development Studio and XML Schemas
• Edit user-defined XML schemas
• Annotate XML schemas for decomposition
• Register XML schemas for validation and/or decomposition
Partitioning and Clustering with XML Data
• Describe the possible use of XML in data warehouses
• List the DPF, DP, and MDC environments where XML can be used and the benefits of using these environments
Agenda
Day 1
• Welcome
• Unit 1: XML Basics
• Exercise #1
• Unit 2: XML Namespaces
• Exercise #2
• Unit 3: XML Schemas
• Exercise #3
• Unit 4: Introduction to XPath
• Exercise #4
• Unit 5: Introduction to XQuery
Day 2
• Exercise #5
• Unit 6: SQL/XML
• Exercise #6
• Unit 7: Updating and Transforming XML Documents
• Exercise #7
Day 3
• Unit 8: Introduction to Programming with XML
• Exercise #8
• Unit 9: Advanced Queries
• Exercise #9
• Unit 10: Optim Development Studio and XML Queries
• Exercise #10
Day 4
• Welcome for any students joining for CL141
• Unit 11: Introduction to XML Storage
• Exercise #11
• Unit 12: XML Indexing
• Exercise #12
• Unit 13: Compression for XML Data and XML Indexes
• Exercise #13
• Unit 14: Optimization and Performance
• Exercise #14
Day 5
• Unit 15: XML Schema Management
• Exercise #15
• Unit 16: XML Decomposition
• Exercise #16
• Unit 17: Optim Development Studio and XML Schemas
• Exercise #17
• Unit 18: Partitioning and Clustering with XML Data
• Wrap-up