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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date