We have written an open source XSD->relational schema tool that we call XFT=
.  It also generates java classes to support storing instance documents to =
the database and querying via xpath. It's part of a neuroimaging database p=
ackage available at http://www.xnat.org.  I can't claim that it's comprehen=
sive or bulletproof, as this turns out to be quite a difficult task.  To fa=
cilitate the process, we typically add some extra tags in the annotation se=
ction of the schema to provide some additional guidance to XFT.

Also, you might look at Shrex (http://www.cs.utah.edu/~juliana/projects/Shr=
eX/).

Regards,
Dan Marcus


-----Original Message-----
From: xmlschema-dev-request@w... [mailto:xmlschema-dev-request@w...] On=
 Behalf Of Mansour Al Akeel
Sent: Wednesday, April 02, 2008 11:56 AM
To: xmlschema-dev@w...
Subject: Database schema from standards xsd


I am not sure if this is the correct place to ask for comments or advice
regarding this issue. If not, please advice me.
I need a database that reflects the structure of the standard schema.
There are lots of these well designed schemas at
http://xml.coverpages.org/xmlApplications.html (for example, Chemical
Markup Language <http://xml.coverpages.org/cml.html>). Is there a way
that I can transform these xml sxhemas to database schema and use an orm
mapping and/or xml binding to process the objects. I believe this can be
a lot of help (if possible). I thought about writing an xslt that will
do this. I would like to hear comments and an advice from someone, if
this is possible, and what would be the downsides.




From noah_mendelsohn@u... Thu Apr 03 22:29:00 2008
Received: from aji.w3.org