Kurs informasjon: Manage XML data with DB2 9 - SPVC

This is the Self-paced Virtual version of Classroom course Manage XML data with DB2 9 (CL141NO), Instructor-led Online course Manage XML data with DB2 9 - Instructor-Led Online (3L141NO) and Web-based course Manage XML data with DB2 9 - Web Based (1L141NO).

This is a self-paced online course. The average amount of time to complete this course is 16 hours. Once you receive your access information, you will have 32 days to complete this course.

Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course.

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 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 self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.

View this course in other countries

Roadmaps:

• XML

Til top

This intermediate 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.

Til top

You 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.

Til top

• 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

Til top

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 IMPORT and EXPORT 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

Til top

HW/SW CONFIGURATION

The minimum hardware and software required to launch the course are:

• Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
• Windows 2000 or XP or Vista
• Computer with soundcard
• Headset or computer speakers
• Internet Explorer 5.01 or later, or Firefox 1.0 or later

Network Speed Test

http://clpext.moppssc.com/index.php?option=com_wrapper&view=wrapper&Itemid=8

User: clp

Pass: ibmeduc

For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be.

High-speed broadband internet access is the recommended configuration for this course.

Keyboard Configuration

If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.

Til top