XML for DB2 information integration /
In many organizations, relational databases are the backbone for data storage and retrieval. Over the last couple of years, XML has become the de facto standard to exchange information between organizations, as well as between departments or applications within the same organization. Since data tend...
Saved in:
| Other Authors: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
[White Plains, N.Y.] :
IBM,
©2004.
|
| Subjects: | |
| Online Access: |
Full text (MFA users only) |
| ISBN: | 9780738490038 0738490032 |
| Local Note: | ProQuest Ebook Central |
Table of Contents:
- 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.