IBM Books

XML Extender Administration and Programming

The tutorial scenario

You have been given the task of taking information in an existing purchase order database, SALES_DB, and extracting key information from it to be stored in XML documents. The service department will then use these XML documents when working with customer requests and complaints. The service department has requested specific data to be included and has provided a recommended structure for the XML documents.

Using existing data, you will compose an XML document, getstart.xml, from data in these tables.

You will also plan and create a DAD file that maps columns from the related tables to an XML document structure that provides a purchase order record. Because this document is composed from multiple tables, you will create an XML collection, associating these tables with an XML structure and a DTD. You use this DTD to define the structure of the XML document. You can also use it to validate the composed XML document in your applications.

The existing database data for the XML document is described in the following tables. The column names in italics are columns that the service department has requested in the XML document structure.

ORDER_TAB

Column name Data type
ORDER_KEY INTEGER
CUSTOMER VARCHAR(16)
CUSTOMER_NAME VARCHAR(16)
CUSTOMER_EMAIL VARCHAR(16)

PART_TAB

Column name Data type
PART_KEY INTEGER
COLOR CHAR(6)
QUANTITY INTEGER
PRICE DECIMAL(10,2)
TAX REAL
ORDER_KEY INTEGER

SHIP_TAB

Column name Data type
DATE DATE
MODE CHAR(6)
COMMENT VARCHAR(128)
PART_KEY INTEGER


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]