- ホーム
- > 洋書
- > 英文書
- > Computer / Languages
Full Description
DB2 pureXML CookbookMaster the Power of the IBM Hybrid Data ServerHands-On Solutions and Best Practices for Developing and Managing XML Database Applications with DB2More and more database developers and DBAs are being asked to develop applications and manage databases that involve XML data. Many are utilizing the highly praised DB2 pureXML technology from IBM. In the DB2 pureXML Cookbook, two leading experts from IBM offer the practical solutions and proven code samples that database professionals need to build better XML solutions faster. Organized by task, this book is packed with more than 700 easy-to-adapt "recipe-style" examples covering the entire application lifecycle-from planning and design through coding, optimization, and troubleshooting. This extraordinary library of recipes includes more than 250 XQuery and SQL/XML queries. With the authors' hands-on guidance, you'll learn how to combine pureXML "ingredients" to efficiently perform virtually any XML data management task, from the simplest to the most advanced.Coverage includespureXML in DB2 9 for z/OS and DB2 9.1, 9.5, and 9.7 for Linux, UNIX, and Windows Best practices for designing XML data, applications, and storage objects Importing, exporting, loading, replicating, and federating XML data Querying XML data, from start to finish: XPath and XQuery data model and languages, SQL/XML, stored procedures, UDFs, and much more Avoiding common errors and inefficient XML queries Converting relational data to XML and vice versa Updating and transforming XML documents Defining and working with XML indexes Monitoring and optimizing the performance of XML queries and other operations Using XML Schemas to constrain and validate XML documents XML application development-including code samples for Java, .NET, C, COBOL,PL/1, PHP, and Perl
Contents
Chapter 1 Introduction 11.1 Anatomy of an XML Document 21.2 Differences Between XML and Relational Data 41.3 Overview of DB2 pureXML 71.4 Benefits of DB2 pureXML over Alternative Storage Options for XML Data 101.5 XML Solutions to Relational Data Model Problems 111.5.1 When the Schema Is Volatile 121.5.2 When Data Is Inherently Hierarchical in Nature 121.5.3 When Data Represents Business Objects 121.5.4 When Objects Have Sparse Attributes 131.5.5 When Data Needs to be Exchanged 131.6 Summary 13Chapter 2 Designing XML Data and Applications 152.1 Choosing Between XML Elements and XML Attributes 152.2 XML Tags versus Values 192.3 Choosing the Right Document Granularity 222.4 Using a Hybrid XML/Relational Approach 242.5 Summary 25Chapter 3 Designing and Managing XML Storage Objects 273.1 Understanding XML Document Trees 283.2 Understanding pureXML Storage 303.3 XML Storage in DB2 for Linux, UNIX, and Windows 333.3.1 Storage Objects for XML Data 333.3.2 Defining Columns,Tables, and Table Spaces for XML Data 363.3.3 Dropping XML Columns 403.3.4 Improved XML Storage Format in DB2 9.7 403.4 Using XML Base Table Row Storage (Inlining) 413.4.1 Monitoring and Configuring XML Inlining 433.4.2 Potential Benefits and Drawbacks of XML Inlining 473.5 Compressing XML Data 483.6 Examining XML Storage Space Consumption 513.7 Reorganizing XML Data and Indexes 533.8 Understanding XML Space Management: A Comprehensive Example 543.9 XML in Range Partitioned Tables and MDC Tables 573.9.1 XML and Range Partitioning 573.9.2 XML and Multidimensional Clustering 583.10 XML in a Partitioned Database (DPF) 593.11 XML Storage in DB2 for z/OS 603.11.1 Storage Objects for XML Data 613.11.2 Characteristics of XML Table Spaces 633.11.3 Tables with Multiple XML Columns 643.11.4 Naming and Storage Conventions 643.12 Utilities for XML Objects in DB2 for z/OS 653.12.1 REPORT TABLESPACESET for XML 673.12.2 Reorganizing XML Data in DB2 for z/OS 683.12.3 CHECK DATA for XML 693.13 XML Parsing and Memory Consumption in DB2 for z/OS 713.13.1 Controlling the Memory Consumption of XML Operations 713.13.2 Redirecting XML Parsing to zIIP and zAAP 723.14 Summary 73Chapter 4 Inserting and Retrieving XML Data 754.1 Inserting XML Documents 764.1.1 Simple Insert Statements 764.1.2 Reading XML Documents from Files or URLs 794.2 Deleting XML Documents 824.3 Retrieving XML Documents 834.4 Handling Documents with XML Declarations 854.5 Copying Full XML Documents 864.6 Dealing with XML Special Characters 874.7 Understanding XML Whitespace and Document Storage 894.7.1 Preserving XML Whitespace 914.7.2 Changing the Whitespace Default from "Strip" to "Preserve" 934.7.3 Storing XML Documents for Compliance 944.8 Summary 95Chapter 5 Moving XML Data 975.1 Exporting XML Data in DB2 for Linux, UNIX, and Windows 985.1.1 Exporting XML Documents to a Single File 985.1.2 Exporting XML Documents as Individual Files 1005.1.3 Exporting XML Documents as Individual Files with Non-Default Names 1025.1.4 Exporting XML Documents to One or Multiple Dedicated Directories 1025.1.5 Exporting Fragments of XML Documents 1045.1.6 Exporting XML Data with XML Schema Information 1055.2 Importing XML Data in DB2 for Linux, UNIX, and Windows 1065.2.1 IMPORT Command and Input Files 1075.2.2 Import/Insert Performance Tips 1085.3 Loading XML Data in DB2 for Linux, UNIX, and Windows 1095.4 Unloading XML Data in DB2 for z/OS 1115.5 Loading XML Data in DB2 for z/OS 1145.6 Validating XML Documents during Load and Insert Operations 1165.7 Splitting Large XML Documents into Smaller Documents 1165.8 Replicating and Publishing XML Data 1185.9 Federating XML Data 1205.10 Managing XML Data with HADR 1215.11 Handling XML Data in db2look and db2move 1225.12 Summary 123Chapter 6 Querying XML Data: Introduction and XPath 1256.1 An Overview of Querying XML Data 1266.2 Understanding the XQuery and XPath Data Model 1286.2.1 Sequences 1286.2.2 Sequence in, Sequence out 1306.3 Sample Data for XPath, SQL/XML, and XQuery 1316.4 Introduction to XPath 1326.4.1 Analogy Between XPath and Navigating a File System 1336.4.2 Simple XPath Queries 1336.5 How to Execute XPath in DB2 1376.6 Wildcards and Double Slashes 1406.7 XPath Predicates 1426.8 Existential Semantics 1476.9 Logical Expressions with and, or, not() 1486.10 The Current Context and the Parent Step 1516.11 Positional Predicates 1536.12 Union and Construction of Sequences 1546.13 XPath Functions 1556.14 General and Value Comparisons 1566.15 XPath Axes and Unabbreviated Syntax 1576.16 Summary 157Chapter 7 Querying XML Data with SQL/XML 1597.1 Overview of SQL/XML 1607.2 Retrieving XML Documents or Document Fragments with XMLQUERY 1617.2.1 Referencing XML Columns in SQL/XML Functions 1627.2.2 Retrieving Element Values Without XML Tags 1637.2.3 Retrieving Repeating Elements with XMLQUERY 1647.3 Retrieving XML Values in Relational Format with XMLTABLE 1657.3.1 Generating Rows and Columns from XML Data 1657.3.2 Dealing with Missing Elements 1677.3.3 Avoiding Type Errors 1687.3.4 Retrieving Repeating Elements with XMLTABLE 1697.3.5 Numbering XMLTABLE Rows Based on Repeating Elements 1737.3.6 Retrieving Multiple Repeating Elements at Different Levels 1747.4 Using XPath Predicates in SQL/XML with XMLEXISTS 1777.5 Common Mistakes with SQL/XML Predicates 1817.6 Using Parameter Markers or Host Variables 1837.7 XML Queries with Dynamically Computed XPath Expressions 1857.8 Ordering a Query Result Set Based on XML Values 1867.9 Converting XML Values to Binary SQL Types 1877.10 Summary 188Chapter 8 Querying XML Data with XQuery 1898.1 XQuery Overview 1908.2 Processing XML Data with FLWOR Expressions 1918.2.1 Anatomy of a FLWOR Expression 1918.2.2 Understanding the for and let Clauses 1938.2.3 Understanding the where and order by Clauses 1948.2.4 FLWOR Expressions with Multiple for and let Clauses 1958.3 Comparing FLWOR Expressions, XPath Expressions, and SQL/XML 1978.3.1 Traversing XML Documents 1978.3.2 Using XML Predicates 1988.3.3 Result Set Cardinalities in XQuery and SQL/XML 2008.3.4 Using FLWOR Expressions in SQL/XML 2018.4 Constructing XML Data 2028.4.1 Constructing Elements with Computed Values 2028.4.2 Constructing XML Data with Predicates and Conditions 2048.4.3 Constructing Documents with Multiple Levels of Nesting 2068.4.4 Constructing Documents with XML Aggregation in SQL/XML Queries 2078.5 Data Types, Cast Expressions, and Type Errors 2088.6 Arithmetic Expressions 2128.7 XQuery Functions 2148.7.1 String Functions 2158.7.2 Number and Aggregation Functions 2188.7.3 Sequence Functions 2208.7.4 Namespace and Node Functions 2228.7.5 Date and Time Functions 2248.7.6 Boolean Functions 2268.8 Embedding SQL in XQuery 2278.9 Using SQL Functions and User-Defined Functions in XQuery 2298.10 Summary 230Chapter 9 Querying XML Data:Advanced Queries & Troubleshooting 2339.1 Aggregation and Grouping of XML Data 2339.1.1 Aggregation and Grouping Queries with XMLTABLE 2349.1.2 Aggregation of Values within and across XML Documents 2369.1.3 Grouping Queries in SQL/XML versus XQuery 2379.2 Join Queries with XML Data 2399.2.1 XQuery Joins between XML Columns 2409.2.2 SQL/XML Joins between XML Columns 2429.2.3 Joins between XML and Relational Columns 2489.2.4 Outer Joins between XML Columns 2509.3 Case-Insensitive XML Queries 2529.4 How to Avoid "Bad" Queries 2539.4.1 Construction of Excessively Large Documents 2539.4.2 "Between" Predicates on XML Data 2549.4.3 Large Global Sequences 2569.4.4 Multilevel Nesting SQL and XQuery 2579.5 Common Errors and How to Avoid Them 2589.5.1 SQL16001N 2599.5.2 SQL16002N 2599.5.3 SQL16003N 2609.5.4 SQL16005N 2619.5.5 SQL16015N 2629.5.6 SQL16011N 2639.5.7 SQL16061N 2639.5.8 SQL16075N 2649.6 Summary 264Chapter 10 Producing XML from Relational Data 26710.1 SQL/XML Publishing Functions 26810.1.1 Constructing XML Elements from Relational Data 26910.1.2 NULL Values, Missing Elements, and Empty Elements 27410.1.3 Constructing XML Attributes from Relational Data 27510.1.4 Constructing XML Documents from Multiple Relational Rows 27710.1.5 Constructing XML Documents from Multiple Relational Tables 28110.1.6 Comparing XMLAGG,XMLCONCAT, and XMLFOREST 28410.1.7 Conditional Element Construction 28410.1.8 Leading Zeros in Constructed Elements and Attributes 28510.1.9 Default Tagging of Relational Data with XMLROW and XMLGROUP 28610.1.10 GUI-Based Definition of SQL/XML Publishing Queries 28910.1.11 Constructing Comments, Processing Instructions, and Text Nodes 29010.1.12 Legacy Functions 29010.2 Using XQuery Constructors with Relational Input 29010.3 XML Declarations for Constructed XML Data 29210.4 Inserting Constructed XML Data into XML Columns 29410.5 Summary 295Chapter 11 Converting XML to Relational Data 29711.1 Advantages and Disadvantages of Shredding 29711.2 Shredding with the XMLTABLE Function 30111.2.1 Hybrid XML Storage 30311.2.2 Relational Views over XML Data 30511.3 Shredding with Annotated XML Schemas 30611.3.1 Annotating an XML Schema 30611.3.2 Defining Schema Annotations Visually in IBM Data Studio 31111.3.3 Registering an Annotated Schema 31111.3.4 Decomposing One XML Document at a Time 31211.3.5 Decomposing XML Documents in Bulk 31511.4 Summary 318Chapter 12 Updating and Transforming XML Documents 32112.1 Replacing a Full XML Document 32212.2 Modifying Documents with XQuery Updates 32412.3 Updating the Value of an XML Node in a Document 32612.3.1 Replacing an Element Value 32612.3.2 Replacing an Attribute Value 32712.3.3 Replacing a Value Using a Parameter Marker 32812.3.4 Replacing Multiple Values in a Document 32812.3.5 Replacing an Existing Value with a Computed Value 32912.4 Replacing XML Nodes in a Document 33112.5 Deleting XML Nodes from a Document 33312.6 Renaming Elements or Atttributes in a Document 33412.7 Inserting XML Nodes into a Document 33512.7.1 Defining the Position of Inserted Elements 33512.7.2 Defining the Position of Inserted Attributes 33612.7.3 Insert Examples 33712.8 Handling Repeating and Missing Nodes 34012.9 Modifying Multiple XML Nodes in the Same Document 34312.9.1 Snapshot Semantics and Conflict Situations 34312.9.2 Converting Elements to Attributes and Vice Versa 34512.10 Modifying XML Documents in Queries 34612.11 Modifying XML Documents in Insert Operations 34912.12 Modifying XML Documents in Update Cursors 35012.13 XML Updates in DB2 for z/OS 35112.14 Transforming XML Documents with XSLT 35212.14.1 The XSLTRANSFORM Function 35312.14.2 XML to HTML Transformation 35612.15 Summary 358Chapter 13 Defining and Using XML Indexes 36113.1 Defining XML Indexes 36213.1.1 Unique XML Indexes 36413.1.2 Lean XML Indexes 36513.1.3 Using the DB2 Control Center to Create XML Indexes 36613.2 XML Index Data Types 36713.2.1 VARCHAR(n) 36713.2.2 VARCHAR HASHED 36813.2.3 DOUBLE and DECFLOAT 36913.2.4 DATE and TIMESTAMP 36913.2.5 Choosing a Suitable Index Data Type 36913.2.6 Rejecting Invalid Values 37113.3 Using XML Indexes to Evaluate Query Predicates 37313.3.1 Understanding Index Eligibility 37313.3.2 Data Types in XML Indexes and Query Predicates 37413.3.3 Text Nodes in XML Indexes and Query Predicates 37513.3.4 Wildcards in XML Indexes and Query Predicates 37613.3.5 Using Indexes for Structural Predicates 37713.4 XML Indexes and Join Predicates 37913.5 XML Indexes on Non-Leaf Elements 38313.6 Special Cases Where XML Indexes Cannot be Used 38513.6.1 Special Cases with XMLQUERY 38513.6.2 Parent Steps 38513.6.3 The let and return Clauses 38613.7 XML Index Internals 38713.7.1 XML Index Keys 38713.7.2 Logical and Physical XML Indexes 38913.8 XML Index Statistics 39013.9 Summary 393Chapter 14 XML Performance and Monitoring 39514.1 Explaining XML Queries in DB2 for Linux,UNIX, and Windows 39614.1.1 The Explain Tables in DB2 for Linux, UNIX, and Windows 39614.1.2 Using db2exfmt to Obtain Access Plans 39714.1.3 Using Visual Explain to Display Access Plans 40014.1.4 Access Plan Operators 40114.1.5 Understanding and Analyzing XML Query Execution Plans 40314.2 Explaining XML Queries in DB2 for z/OS 40914.2.1 The Explain Tables in DB2 for z/OS 40914.2.2 Obtaining Access Plan Information in SPUFI 41014.2.3 Using Visual Explain to Display Access Plans 41114.2.4 Access Plan Operators 41314.2.5 Understanding and Analyzing XML Query Execution Plans 41414.3 Statistics Collection for XML Data 41714.3.1 Statistics Collection for XML Data in DB2 for z/OS 41714.3.2 Statistics Collection for XML Data in DB2 for Linux, UNIX, and Windows 41814.3.3 Examining XML Statistics with db2cat 41914.4 Monitoring XML Activity 42414.4.1 Using the Snapshot Monitor in DB2 for Linux, UNIX, and Windows 42414.4.2 Monitoring Database Utilities 42714.5 Best Practices for XML Performance 42814.5.1 XML Document Design 42814.5.2 XML Storage 42914.5.3 XML Queries 43014.5.4 XML Indexes 43214.5.5 XML Updates 43314.5.6 XML Schemas 43414.5.7 XML Applications 43414.6 Summary 435Chapter 15 Managing XML Data with Namespaces 43715.1 Introduction to XML Namespaces 43715.1.1 Namespace Declarations in XML Documents 43915.1.2 Default Namespaces 44215.2 Exploring Namespaces in XML Documents 44415.3 Querying XML Data with Namespaces 44715.3.1 Declaring Namespaces in XML Queries 44815.3.2 Using Namespace Declarations in SQL/XML Queries 45115.3.3 Using Namespaces in the XMLTABLE Function 45215.3.4 Dealing with Multiple Namespaces per Document 45415.4 Creating Indexes for XML Data with Namespaces 45615.5 Constructing XML Data with Namespaces 46015.5.1 SQL/XML Publishing Functions and Namespaces 46015.5.2 XQuery Constructors and Namespaces 46215.6 Updating XML Data with Namespaces 46315.6.1 Updating Values in Documents with Namespaces 46415.6.2 Renaming Nodes in Documents with Namespace Prefixes 46515.6.3 Renaming Nodes in Documents with Default Namespaces 46715.6.4 Inserting and Replacing Nodes in Documents with Namespaces 46815.7 Summary 469Chapter 16 Managing XML Schemas 47116.1 Introduction to XML Schemas and Their Usage 47216.1.1 Valid Versus Well-Formed XML Documents 47316.1.2 To Validate or Not to Validate,That Is the Question! 47416.1.3 Custom Versus Industry Standard XML Schemas 47416.2 Anatomy of an XML Schema 47616.3 An XML Schema with Include and Import 47916.4 Registering XML Schemas 48316.4.1 Registering XML Schemas in the DB2 Command Line Processor 48416.4.2 Registering XML Schemas from Applications via Stored Procedures 48616.4.3 Registering XML Schemas from Java Applications via JDBC 48816.4.4 Two XML Schemas Sharing a Common Schema Document 48916.4.5 Error Situations and How to Resolve Them 49016.5 Removing XML Schemas from the Schema Repository 49216.6 XML Schema Evolution 49316.6.1 Schema Evolution Without Document Validation 49416.6.2 Generic Schema Evolution with Document Validation 49416.6.3 Compatible Schema Evolution with the UPDATE XMLSCHEMA Command 49516.7 Granting and Revoking XML Schema Usage Privileges 49916.8 Document Type Definitions (DTDs) and External Entities 50116.9 Browsing the XML Schema Repository (XSR) 50216.9.1 Tables and Views of the XML Schema Repository 50316.9.2 Queries against the XML Schema Repository 50816.10 XML Schema Considerations in DB2 for z/OS 51016.11 Summary 512Chapter 17 Validating XML Documents against XML Schemas 51317.1 Document Validation Upon Insert 51417.2 Document Validation Upon Update 51817.3 Validation without Rejecting Invalid Documents 51917.4 Enforcing Validation with Check Constraints 52017.5 Automatic Validation with Triggers 52317.6 Diagnosing Validation and Parsing Errors 52517.7 Validation during Load and Import Operations 53017.7.1 Validation against a Single XML Schema 53017.7.2 Validation against Multiple XML Schemas 53117.7.3 Using a Default XML Schema 53217.7.4 Overriding XML Schema References 53217.7.5 Validation Based on schemaLocation Attributes 53417.8 Checking Whether an Existing Document Has Been Validated 53417.9 Validating Existing Documents in a Table 53517.10 Finding the XML Schema for a Validated Document 53817.11 How to Undo Document Validation 54017.12 Considerations for Validation in DB2 for z/OS 54017.12.1 Document Validation Upon Insert 54117.12.2 Document Validation Upon Update 54217.12.3 Validating Existing Documents in a Table 54317.12.4 Summary of Platform Similarities and Differences 54317.13 Summary 544Chapter 18 Using XML in Stored Procedures, UDFs, and Triggers 54718.1 Manipulating XML in SQL Stored Procedures 54818.1.1 Basic XML Manipulation in Stored Procedures 54818.1.2 A Stored Procedure to Store XML in a Hybrid Manner 55018.1.3 Loops and Cursors 55318.1.4 A Stored Procedure to Update a Selected XML Element or Attribute 55418.1.5 Three Tips for Testing Stored Procedures 55518.2 Manipulating XML in User-Defined Functions 55618.2.1 A UDF to Extract an Element or Attribute Value 55718.2.2 A UDF to Extract the Values of a Repeating Element 55718.2.3 A UDF to Shred XML Data to a Relational Table 55818.2.4 A UDF to Modify an XML Document 55918.3 Manipulating XML Data with Triggers 56118.3.1 Insert Triggers on Tables with XML Columns 56218.3.2 Delete Triggers on Tables with XML Columns 56318.3.3 Update Triggers on XML Columns 56418.4 Summary 564Chapter 19 Performing Full-Text Search 56719.1 Overview of Text Search in DB2 56819.2 Sample Table and Data 57019.3 Enabling a Database for the DB2 Net Search Extender 57119.4 Managing Full-Text Indexes with the DB2 Net Search Extender 57219.4.1 Creating Basic Text Indexes 57219.4.2 Creating Text Indexes with Specific Storage Paths 57319.4.3 Creating Text Indexes with a Periodic Update Schedule 57419.4.4 Creating Text Indexes for Specific Parts of Each Document 57619.4.5 Creating Text Indexes with Advanced Options 57819.4.6 Updating and Reorganizing Text Indexes 57919.4.7 Altering Text Indexes 58019.5 Performing XML Full-Text Search with the DB2 Net Search Extender 58119.5.1 Full-Text Search in SQL and XQuery 58119.5.2 Full-Text Search with Boolean Operators 58319.5.3 Full-Text Search with Custom Document Models 58519.5.4 Advanced Search with Proximity, Fuzzy, and Stemming Options 58619.5.5 Finding the Correct Match within an XML Document 58719.5.6 Search Conditions on Sibling Branches of an XML Document 58819.5.7 Text Search in the Presence of Namespaces 58819.6 DB2 Text Search 59019.6.1 Enabling a Database for DB2 Text Search 59019.6.2 Creating and Maintaining Full-Text Indexes for DB2 Text Search 59119.6.3 Writing DB2 Text Search Queries for XML Data 59219.6.4 Full-Text Search with XPath Expressions 59319.6.5 Full-Text Search with Wildcards 59419.7 Summary of Text Search Administration Commands 59419.8 XML Full-Text Search in DB2 for z/OS 59619.9 Summary 596Chapter 20 Understanding XML Data Encoding 59720.1 Understanding Internal and External XML Encoding 59920.1.1 Internally Encoded XML Data 59920.1.2 Externally Encoded XML Data 60020.2 Avoiding Code Page Conversions 60120.3 Using Non-Unicode Databases for XML 60120.4 Examples of Code Page Issues 60220.4.1 Example 1: Chinese Characters in a Non-Unicode Code Page ISO-8859-1 60220.4.2 Example 2: Fetching Data from a Non-Unicode Code Database into a Character Type Application Variable 60320.4.3 Example 3: Encoding Issues with XMLTABLE and XMLCAST 60420.4.4 Example 4: Japanese Literal Values in a Non-Unicode Database 60520.4.5 Example 5: Data Expansion and Shrinkage Due to Code Page Conversion 60520.5 Avoiding Data Loss and Encoding Errors in Non-Unicode Databases 60620.6 Summary 606Chapter 21 Developing XML Applications with DB2 60921.1 The Value of DB2 pureXML for Application Development 61021.1.1 Avoid XML Parsing in the Application Layer 61021.1.2 Storing Business Objects in an Intuitive Format 61221.1.3 Rapid Prototyping 61221.1.4 Responding Quickly to Changing Business Needs 61321.2 Using Parameter Markers or Host Variables 61321.3 Java Applications 61521.3.1 XML Support in JDBC 3.0 61521.3.2 XML Support in JDBC 4.0 61921.3.3 Comprehensive Example of Manipulating XML Data with JDBC 4.0 62121.3.4 Creating XML Documents from Application Data 62721.3.5 Binding XML Data to Java Objects 62921.3.6 IBM pureQuery 62921.4 .NET Applications 63121.4.1 Querying XML Data in .NET Applications 63221.4.2 Manipulating XML Data in .NET Applications 63321.4.3 Inserting XML Data from .NET Applications 63521.4.4 XML Schema and DTD Handling in .NET Applications 63621.5 CLI Applications 63621.6 Embedded SQL Applications 63921.6.1 COBOL Applications with Embedded SQL 64021.6.2 PL/1 Applications with Embedded SQL 64321.6.3 C Applications with Embedded SQL 64521.7 PHP Applications 64721.8 Perl Applications 65021.9 XML Application Development Tools 65121.9.1 IBM Data Studio Developer 65221.9.2 IBM Database Add-ins for Visual Studio 65621.9.3 Altova XML Tools 65621.9.4 65821.9.5 Stylus Studio 65921.10 Summary 659Chapter 22 Exploring XML Information in the DB2 Catalog 66122.1 XML-Related Catalog Information in DB2 for Linux, UNIX, and Windows 66122.1.1 Catalog Information for XML Columns 66122.1.2 The XML Strings and Paths Tables 66222.1.3 The Internal XML Regions and Path Indexes 66322.1.4 Catalog Information for User-Defined XML Indexes 66422.1.5 Catalog Information for XML Schemas 66722.2 XML-Related Catalog Information in DB2 for z/OS 66722.2.1 Catalog Information for XML Storage Objects 66722.2.2 Catalog Information for XML Indexes 67122.2.3 Catalog Information for XML Schemas 67222.3 Summary 673Chapter 23 Test Your Knowledge-The DB2 pureXML Quiz 67523.1 Designing XML Data and Applications 67523.2 Designing and Managing Storage Objects for XML 67723.3 Inserting and Retrieving XML Data 68023.4 Moving XML Data 68123.5 Querying XML 68223.6 Producing XML from Relational Data 68623.7 Converting XML to Relational Data 68723.8 Updating and Transforming XML Documents 68823.9 Defining and Using XML Indexes 68923.10 XML Performance and Monitoring 69223.11 Managing XML Data with Namespaces 69323.12 XML Schemas and Validation 69423.13 Performing Full-Text Search 69623.14 XML Application Development 69723.15 Answers 700Appendix A Getting Started with DB2 pureXML 703A.1 Exploring the Structure of XML Documents 703A.1.1 Exploring XML Documents in the DB2 Control Center 703A.1.2 Exploring XML Documents in the CLP 704A.1.3 Exploring XML Documents in SPUFI 705A.2 Tips for Running XML Operations in the CLP 706Appendix B The XML Sample Database 709B.1 XML Sample Database on DB2 for Linux, UNIX, and Windows 709B.2 XML Sample Tables on DB2 for z/OS 710B.3 Table customer-Column info 710B.4 Table product-Column description 712B.5 Table purchaseorder-Column porder 713Appendix C Further Reading 717C.1 General Resources for All Chapters 717C.2 Chapter-Specific Resources 718C.3 Resources on the Integration of DB2 pureXML with Other Products 726Index 727
