File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
author & internet detective

Joined: May 26, 2003
Posts: 31585

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

[OCA 8 book] [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: 19351

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.
I agree. Here's the link:
subject: DTD->SQL