Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes DTD->SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DTD->SQL" Watch "DTD->SQL" New topic


jay vas
Ranch Hand

Joined: Aug 30, 2005
Posts: 407
Hi guys : There has to be a tool out there somewhere for converting a well formed XML document to a robust relational schema (preferably MySQL), but I can't find one.

Basically, I want to auto generate tables with relationships from the structure of an XML document, and also auto generate tools for importing data from that document into the database afterwards.

Any ideas ?

Thanks ,
jay vas
Ranch Hand

Joined: Aug 30, 2005
Posts: 407
Anyone hear anything on this one?
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30057

Just so you get a reply, I'm going with "no"

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
gianni ipez
Ranch Hand

Joined: Jan 02, 2007
Posts: 65
This is very interesting.
I'm looking for the same information, if I won't find anything interesting I'll write something myself.
I'll let you know.
Paul Clapham

Joined: Oct 14, 2005
Posts: 18541

XML documents are trees, not tables. So I certainly wouldn't expect to find something which converts arbitrary XML documents into database tables. You would have to severely restrict the contents and structure of the document before you could do that.

So don't hold your breath waiting.
gianni ipez
Ranch Hand

Joined: Jan 02, 2007
Posts: 65
That's true, but both xml and databases contain data.
I'm dealing with a complex environment in which many systems are implied, migrations are frequent and integration has a great relevance.
It is sorta covered in the JavaRanch Style Guide.
subject: DTD->SQL
Similar Threads
Velocity to xml and validate with xsd
Removing XML declaration in XML file
XSD from Xml doc
auto-generate Schema from XML documents?