1 / 8

- Introduce IBM DB2 XML Extender

- Introduce IBM DB2 XML Extender. Enabling DB2 Applications for the Next Generation Web and e-Commerce. Dr. Jane Xu IBM Almaden Research Center jxu@us.ibm.com. DB2 UDB. ERP Data. XML Extender. Extract, Generate, Transform, Shred, Load. B2C, B2B Data. Enterprise Information Portal.

lperrine
Download Presentation

- Introduce IBM DB2 XML Extender

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. - Introduce IBM DB2 XML Extender Enabling DB2 Applications for the Next Generation Web and e-Commerce Dr. Jane Xu IBM Almaden Research Center jxu@us.ibm.com

  2. DB2 UDB ERP Data XML Extender Extract, Generate, Transform, Shred, Load B2C, B2B Data Enterprise Information Portal Purchasing Data DB2 XML is the Key to Leverage DB2 Data for the Next Generation Web Enterprise Information Web Client Enterprise Server Web Server XML XML XML XML Enterprise Data

  3. Your application XML Document DB2 XML Extender DAD DB2 tables DB2 XML Extender Overview Document Access Definition (DAD) specifies how to map XML documents into tables

  4. Feature 1: XML Column • A whole XML document is stored in a table column • The DAD can identify elements and attributes to be indexed (in side tables) for fast access. SQL data type conversion is supported. • You can retrieve the whole document or specific elements/attributes identified by XPath expressions. • Validation on input XML documents is supported. • Appropriate for XML documents that have irregular structure and are not frequently updated. • XML Extender can be used together with Text Extender to provide full-text search (stem-matching, etc.) for XML documents. <?xml version="1.0"?> <!--DOCTYPE Order SYSTEM "Order.dtd"--> <Order key="1"> <Part key="1"> <Customer>37</Customer> <Status>O</Status> <Price>131251.81</Price> <Date>1996-01-02</Date> <Priority>5-LOW</Priority> <Clerk>Clerk#000000951</Clerk> <ShipPriority>0</ShipPriority> <Comment>first part</Comment> </Part> </Order> order_tab Order Invoice 356 Example: Select db2xml.extractDouble(order, '/Order/Part/Price) from order_tab where invoice = 356

  5. <?xml version="1.0"?> <!--DOCTYPE Order SYSTEM "Order.dtd"--> <Order key="1"> <Part key="1"> <Customer>37</Customer> <Status>O</Status> <Price>131251.81</Price> <shipment> <Date>1996-01-02</Date> </shipment> <shipment> <Date>1999-11-26</Date> </shipment> </Part> </Order> ship_tab order_tab date part_key Key Order part_tab Status Price Customer Order_key Key • XML document is generated or decomposed from or into a set of tables, linked by primary and foreign keys. • Each table represents a repeating group of elements in the document. • Permits update of individual elements and attributes inside a document. Feature 2: XML Collection

  6. The DAD controls the mapping: • SQL Statement method: an SQL statement generates XML by joining the underlying tables. • RDB-Node method: Each XML node is mapped individually to a table and column. • Documents can be generated or shredded based on specified conditions. • Dynamic override of conditions is supported. • Appropriate for XML documents that have a regular repeating structure. • Also appropriate for presenting an XML view of existing DB2 tables. Feature 2: XML Collection (Con't) Access Method: Stored Procedure calls through JDBC, ODBC, Embedded SQL.

  7. DB2 tables XML Transform XML Document Feature 3: XML Transform • A method of producing XML documents from information stored in a IBM Universal database. • Specifies a language for transforming DB2 database information into XML documents, and a means of invoking transformations at a DB2 server. • The lightweight transform language is similar to XSLT (W3C XSL Transformations), providing specific constructs for retrieving information from DB2 databases. • The language is not intended to be a full transformation language, or a rival to XSLT, but simply a way for IBM customers to generate nontrivial XML documents from their data servers.

  8. Summary • Provides storage, retrieval, and update of XML documents in a single column. • Composes existing DB2 data into XML documents. • Stores XML documents as a collection of DB2 data, in multiple columns and tables. • Manages your DTD repository. • Extracts XML elements and attributes into traditional SQL data types, leveraging DB2 sophisticated indexing and SQL query. • Provides a wizard for easy administration. • Supports international code pages. • Support platforms of AIX, Linux, NUMA-Q, Solaris, UNIX, Windows 2000 and Windows NT, OS/390(V6), AS/400(V5R1). URL: http://www-4.ibm.com/software/data/db2/extenders

More Related