Articles & Content

Archives

Informix XML DataBlade Module (I12)

Topic: 2006 EU

Subtopic: Informix



DATE: 2006-10-4 (14:45 - 15:45)
SPEAKERS: Jan Musil (IBM Czech Republic)

The solution was developed to meet a customer requirement. The customer regularygets XML documents and needs to execute SQL select statements that read datafrom database tables and these external XML files without loading the XML files into the database.The solution was developed as an Informix DataBlade module which gives the required transparent SQL interface to these external XML documents. The new XML access method was developed to access of the external XML documents which are mapped to an SQL table. The solutionalso creates and maintains the indices needed for fast indexed queries of the XML documents.The solution includes a basic consistency check.The solution is developed using released and commercially available products, documentation and examples. The current version of the solution was developed in the Linux environment for Informix Dynamic Server 9.x and 10.xbut will work equally well on any supported platform.

EXP. LEVEL: Intermediate

OBJECTIVES:

One of possible method of integration XML support directly to IDS server core functionality

Advantages of open architecture of Informix Dynamic Server for such integration

Virtual table interface (VTI) as suitable method for such soultion

Simple implementation of indexing of XML document

Using of SQL and cost based optimizer for retrieving of data from XML document



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.