Articles & Content
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
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
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.