Articles & Content


Episode 9 - The Return of the Hierarchical Empire (A04)

Topic: 2007 EU

Subtopic: DB2 for z/OS

DATE: 2007-11-6 (09:00 - 10:00)

The integration of XML in DB2 for z/OS V9 is often called the revenge of IMS. There is some truth in this because XML is a hierarchical structure, which is now integrated into the relational model. A few questions are brought up with this, like-How do we access the data in XML structures?-What about indexing to improve performance?-Are there recommendations for database design?In this presentation, I will highlight first experiences with XML integration in DB2 for z/OS. Additionally, I will provide hints and tips on how to improve performance. Last but not least, I will show you why you should recall your old hierarchical "thinking modes" to survive in the new fashionable XML world.

EXP. LEVEL: Beginner,Intermediate


XML in DB2 for z/OS V9 integration

Performance figures

Index design for XML

Design recommendations

Hierarchical vs. relational - or: hierarchical joins relational

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.