Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Oct 25, 2002

XML Wrapper Generator for IBM DB2

By DatabaseJournal.com Staff

The XML Wrapper Generator is a graphical tool that enables rapid and automatic integration of XML data sources into a DB2 database using the XML Wrapper. This tool loads XML schema files, "shreds" them to a relational schema, and generates appropriate NICKNAME and VIEW statements.

The XML Wrapper Generator is a stand-alone Java application with a graphical interface. Upon loading an XML schema, the tree structure of this schema can be seen. At the push of a button, the schema is transformed to a set of tables, seen as a second tree-like structure. Arrows pointing from elements of the XML schema to elements of the relational schema show which parts of the XML schema were transformed to which parts of the relational schema. At this point, this relational schema can be modified by adding and removing attributes and tables, by changing data types, etc.

Once a satisfactory result is obtained, the XML Wrapper Generator automatically generates data definiton statements for DB2. These CREATE NICKNAME and CREATE VIEW statements can be excuted in DB2 and thereafter allow users to pose standard SQL queries against any kind of XML document that conforms to the original XML schema.

Additional information and a free trial download of the XML Wrapper Generator is available at http://www.alphaWorks.ibm.com/tech/wrappergenerator?open&l=TS102402,t=awfl.

Back to Database Journal Home

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM