Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Part 1 Overview -- Chapter 1. XML and databases -- 1.1 Why use XML with a database? -- 1.2 A common misconception -- 1.3 How is XML used with databases? -- 1.4 XML-enabled database: using XML to exchange data -- 1.4.1 XML as a data exchange format -- 1.4.2 Mapping a database schema to an XML schema -- 1.5 Native XML DB: managing documents and semi-structured data -- 1.5.1 Use cases -- 1.5.2 Technical definition of a native XML database -- 1.6 Summary -- Chapter 2. XML services in DB2 and DB2 Information Integrator -- 2.1 SQL/XML -- 2.1.1 XML data type -- 2.1.2 SQL/XML functions -- 2.1.3 XML2CLOB function -- 2.2 DB2 XML Extender -- 2.2.1 XML collections -- 2.2.2 XML columns -- 2.3 Net Search Extender -- 2.3.1 Creating indexes -- 2.3.2 Full-text searches -- 2.3.3 Structural queries -- 2.4 XML wrapper -- 2.4.1 Registering a wrapper and server -- 2.4.2 Mapping an XML schema -- 2.4.3 Identifying an XML document -- 2.4.4 Querying an XML document through the XML Wrapper -- 2.4.5 Shredding an XML document using the XML Wrapper -- 2.5 WebSphere MQ -- 2.6 WebSphere Studio -- 2.7 What products should I use? -- 2.7.1 XML-enabled storage or native XML storage? -- 2.7.2 Products for XML-enabled storage -- 2.7.3 Products for native XML storage -- Chapter 3. Designing XML and database schemas -- 3.1 Local and global XML schemas -- 3.2 What schemas do you need to design? -- 3.2.1 On using industry-standard XML schemas -- 3.2.2 You have a database schema -- 3.2.3 You have an XML schema -- 3.2.4 You have both database and XML schemas -- 3.3 Does my XML schema match my database schema? -- 3.4 Creating an XML schema from a database schema -- 3.4.1 The algorithm.

3.4.2 Using the generated XML schema with DB2 XML Extender -- 3.5 Creating a database schema from an XML schema -- 3.5.1 Creating a local XML schema from a global XML schema -- 3.5.2 Creating a database schema from a local XML schema -- 3.6 Designing XML schemas -- 3.6.1 Who will use the XML schema? -- 3.6.2 What XML schema language should you use? -- 3.6.3 General guidelines for designing XML schemas -- 3.6.4 Normalizing your XML schema -- 3.6.5 XML schema styles to avoid -- 3.6.6 Unsupported XML schema structures by DB2 products -- Part 2 Processing XML documents -- Chapter 4. Storing whole XML documents -- 4.1 Storing outside of DB2 in the file system -- 4.1.1 File system storage considerations -- 4.1.2 Accessing data stored in the file system -- 4.2 Storing XML in DB2 without using XML columns -- 4.2.1 Using DB2 data types without XML Extender functions -- 4.2.2 Using XML Extender UDFs to insert XML documents into a normal DB2 column -- 4.3 DB2 XML Extender storage methods -- 4.4 Storing intact XML documents with XML Extender -- 4.4.1 Using the XML Extender data type -- 4.4.2 When to use an XML column to store data -- 4.4.3 Building the DAD file -- 4.4.4 Creating the table that will contain the XML column -- 4.4.5 Inserting the DTD into the DTD_REF table -- 4.4.6 Enabling the XML column -- 4.4.7 Creating indexes on the side tables -- 4.4.8 Using XML Extender UDFs to insert XML documents -- Chapter 5. Working with XML documents stored in XML columns -- 5.1 Retrieving, extracting, updating, and deleting XML columns -- 5.2 Retrieving XML documents stored in XML columns -- 5.2.1 Retrieving the entire XML document -- 5.2.2 Retrieving elements and attributes from XML documents -- 5.2.3 Retrieving fragments from data stored in an XML column -- 5.2.4 Filtering the XML documents you want to retrieve -- 5.3 Retrieving XML columns using an XML wrapper.

5.4 Updating XML documents stored in an XML column -- 5.4.1 Using the SQL UPDATE statement -- 5.4.2 Using the Update() UDF -- 5.5 Deleting XML documents stored in an XML column -- 5.6 Best practices -- 5.6.1 Use side tables as much as possible -- 5.6.2 Where to filter -- 5.6.3 Using location path expressions -- Chapter 6. Shredding XML into relational tables -- 6.1 Shredding overview -- 6.1.1 What is shredding? -- 6.1.2 When should you use shredding? -- 6.2 Shredding using DB2 XML Extender -- 6.2.1 Shredding - planning and design -- 6.2.2 Planning and design: hints and tips -- 6.2.3 Shredding: configuration and execution -- 6.3 Alternatives to shredding with DB2 XML Extender -- 6.3.1 Using the XML wrapper -- 6.3.2 Writing your own code -- 6.4 Shredding with XML Extender: a step-by-step example -- 6.4.1 Step 1 - XML enabling of your database -- 6.4.2 Step 2 - Creating the DAD file -- 6.4.3 Step 3 - Enablement of the XML collection -- 6.4.4 Step 4 - Decomposing the XML data into relational tables -- 6.4.5 Step 5 - Checking the result using the SELECT statement -- Chapter 7. Bulk processing of XML documents -- 7.1 An XML cutter to process repetitive documents -- 7.1.1 The SAXCutter sample tool -- 7.1.2 The CutterTester sample application -- 7.1.3 Writing your own application -- 7.2 Using XSLT for bulk inserts -- 7.2.1 Flattening XML documents -- 7.2.2 Converting from XML to the DB2 load format -- 7.2.3 The XSLT stylesheet -- 7.2.4 Cutting the flattened document -- 7.2.5 Importing or loading the data -- Chapter 8. Publishing data as XML -- 8.1 Publishing data using SQL/XML -- 8.1.1 Constructing elements and attributes -- 8.1.2 A more complex example -- 8.1.3 Behind the scenes: the XML data type -- 8.2 Publishing data with XML Extender -- 8.2.1 DAD files -- 8.2.2 Publishing XML documents using a DAD file.

8.2.3 DB2 XML Extender publishing stored procedures -- 8.2.4 Writing your own code to publish data as XML -- 8.3 Best practices -- 8.3.1 SQL/XML -- 8.3.2 XML Extender -- Chapter 9. Additional XML functionality -- 9.1 Transformation -- 9.1.1 XSL, stylesheets and transformation -- 9.1.2 Why transform? -- 9.1.3 Transforming XML documents with SAX -- 9.2 Validation -- 9.2.1 Validating XML documents using UDFs -- 9.2.2 Validating the DAD file -- 9.3 Importing and exporting XML documents using UDF -- 9.3.1 Importing or storing XML documents -- 9.3.2 Exporting or retrieving XML documents -- Chapter 10. Web services in DB2 -- 10.1 Introduction to Web services -- 10.1.1 Motivation -- 10.1.2 Requirements for a service-oriented architecture -- 10.1.3 Service-oriented architecture overview -- 10.1.4 Characteristics of the Web service architecture -- 10.1.5 Web services approach for a SOA architecture -- 10.1.6 Properties of the service-oriented architecture -- 10.1.7 More information -- 10.2 DB2 as Web service provider -- 10.2.1 Web Services Object Runtime Framework -- 10.2.2 Installing WORF on IBM WebSphere Application Server -- 10.2.3 Creating DB2 Web services -- 10.2.4 Deploying the Web application -- 10.2.5 Starting the enterprise application -- 10.2.6 Testing the DB2 Web services -- 10.2.7 DADX and auto-deploy feature of WORF -- 10.2.8 WORF test facility -- 10.3 DB2 as Web service consumer -- 10.3.1 Prerequisites -- 10.3.2 Enabling DB2 Web service consumer UDFs -- 10.3.3 Using the Web service consumer UDFs -- 10.3.4 Web service consumer UDFs -- 10.3.5 From WSDL to Web service consumer function -- 10.3.6 Testing the Web service consumer functions -- 10.3.7 Creating a wrapper UDF to Web services consumer function -- Chapter 11. XML wrapper -- 11.1 Introducing the XML wrapper -- 11.2 XML wrapper explained -- 11.2.1 Using the XML wrapper.

11.2.2 Registering the XML wrapper -- 11.2.3 Creating the server -- 11.2.4 Creating nicknames -- 11.2.5 Accessing non-root nicknames -- 11.2.6 Creating federated views for non-root nicknames -- 11.2.7 Options for specifying the XML data source for nicknames -- 11.2.8 Altering XML nicknames -- 11.3 Working with XML wrapper via DB2 Control Center -- 11.4 Best practices -- Part 3 XML tools for database systems -- Chapter 12. XML and database tools in Application Developer -- 12.1 Application Developer tools overview -- 12.1.1 Perspectives -- 12.1.2 Authoring and generation tools -- 12.1.3 Preparation -- 12.2 XML tools walkthrough -- 12.2.1 Creating a database connection -- 12.2.2 Database editors -- 12.2.3 XML Schema, table DDL, and DDT -- 12.2.4 Creating an SQL statement -- 12.2.5 Creating a user-defined function (UDF) -- 12.2.6 Generating XML from an SQL statement -- 12.2.7 Updating relational tables from XML -- 12.2.8 XSL transformations -- 12.2.9 Mapping the relational table to XML -- 12.2.10 Mapping the SQL query to XML -- 12.2.11 Generating a DAD file -- 12.3 Web services tools -- 12.3.1 Creating a DADX group configuration -- 12.3.2 Creating a DADX file from an SQL statement -- 12.3.3 Creating a Web service from DADX -- Part 4 Worked examples -- Chapter 13. Worked scenario -- 13.1 Scenario introduction -- 13.2 Scenario 1: Insurance quotes -- 13.3 Scenario 2: Processing the insurance policy -- 13.4 Scenario 3: Generating XML documents -- 13.5 Scenario 4: Gathering information for investments -- Chapter 14. Scenario implementation using DB2 functionality -- 14.1 Setting up the system for the scenario -- 14.2 Scenario 1: Web service provider -- 14.2.1 Overview -- 14.2.2 The XML wrapper -- 14.2.3 Context -- 14.2.4 XML wrapper implementation -- 14.3 Scenario 2: storing insurance policies -- 14.3.1 Shredding XML documents into relational tables.

14.3.2 Shredding implementation details.