File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DTD->SQL" Watch "DTD->SQL" New topic
Author

DTD->SQL

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 ,
J
jay vas
Ranch Hand

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

Joined: May 26, 2003
Posts: 30506
    
150

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.
cheers
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18564
    
    8

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: http://aspose.com/file-tools
 
subject: DTD->SQL