text.skipToContent text.skipToNavigation
  1. Home
  2. Computer Science & IT
  3. DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server

DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server, 1st edition

  • Matthias Nicola
  • Pav Kumar-Chatterjee

Published by IBM Press (August 10th 2009) - Copyright © 2010

1st edition

DB2 pureXML Cookbook: Master the Power of the IBM Hybrid Data Server

ISBN-13: 9780138150471

Includes: Hardcover
Free delivery
$54.99

Permanently unavailable

What's included

  • Hardcover

    You'll get a bound printed text.

Overview

Table of contents

Chapter 1 Introduction 1

1.1 Anatomy of an XML Document 2

1.2 Differences Between XML and Relational Data 4

1.3 Overview of DB2 pureXML 7

1.4 Benefits of DB2 pureXML over Alternative Storage Options for XML Data 10

1.5 XML Solutions to Relational Data Model Problems 11

1.5.1 When the Schema Is Volatile 12

1.5.2 When Data Is Inherently Hierarchical in Nature 12

1.5.3 When Data Represents Business Objects 12

1.5.4 When Objects Have Sparse Attributes 13

1.5.5 When Data Needs to be Exchanged 13

1.6 Summary 13

Chapter 2 Designing XML Data and Applications 15

2.1 Choosing Between XML Elements and XML Attributes 15

2.2 XML Tags versus Values 19

2.3 Choosing the Right Document Granularity 22

2.4 Using a Hybrid XML/Relational Approach 24

2.5 Summary 25

Chapter 3 Designing and Managing XML Storage Objects 27

3.1 Understanding XML Document Trees 28

3.2 Understanding pureXML Storage 30

3.3 XML Storage in DB2 for Linux, UNIX, and Windows 33

3.3.1 Storage Objects for XML Data 33

3.3.2 Defining Columns,Tables, and Table Spaces for XML Data 36

3.3.3 Dropping XML Columns 40

3.3.4 Improved XML Storage Format in DB2 9.7 40

3.4 Using XML Base Table Row Storage (Inlining) 41

3.4.1 Monitoring and Configuring XML Inlining 43

3.4.2 Potential Benefits and Drawbacks of XML Inlining 47

3.5 Compressing XML Data 48

3.6 Examining XML Storage Space Consumption 51

3.7 Reorganizing XML Data and Indexes 53

3.8 Understanding XML Space Management: A Comprehensive Example 54

3.9 XML in Range Partitioned Tables and MDC Tables 57

3.9.1 XML and Range Partitioning 57

3.9.2 XML and Multidimensional Clustering 58

3.10 XML in a Partitioned Database (DPF) 59

3.11 XML Storage in DB2 for z/OS 60

3.11.1 Storage Objects for XML Data 61

3.11.2 Characteristics of XML Table Spaces 63

3.11.3 Tables with Multiple XML Columns 64

3.11.4 Naming and Storage Conventions 64

3.12 Utilities for XML Objects in DB2 for z/OS 65

3.12.1 REPORT TABLESPACESET for XML 67

3.12.2 Reorganizing XML Data in DB2 for z/OS 68

3.12.3 CHECK DATA for XML 69

3.13 XML Parsing and Memory Consumption in DB2 for z/OS 71

3.13.1 Controlling the Memory Consumption of XML Operations 71

3.13.2 Redirecting XML Parsing to zIIP and zAAP 72

3.14 Summary 73

Chapter 4 Inserting and Retrieving XML Data 75

4.1 Inserting XML Documents 76

4.1.1 Simple Insert Statements 76

4.1.2 Reading XML Documents from Files or URLs 79

4.2 Deleting XML Documents 82

4.3 Retrieving

For teachers

All the material you need to teach your courses.

Discover teaching material