W3C home > Mailing lists > Public > xmlschema-dev@w3.org > April 2008

Re: Database schema from standards xsd

From: Mansour Al Akeel <mansour.alakeel@gmail.com>
Date: Tue, 22 Apr 2008 10:09:33 -0300
Message-ID: <480DE38D.6090303@gmail.com>
To: Daniel Marcus <dmarcus@npg.wustl.edu>
CC: "xmlschema-dev@w3.org" <xmlschema-dev@w3.org>

Thank you everyone for all these ideas. I will look deeper into each 
approach and report the results.

Daniel Marcus wrote:
> 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 package available at http://www.xnat.org.  I can't claim that it's comprehensive or bulletproof, as this turns out to be quite a difficult task.  To facilitate the process, we typically add some extra tags in the annotation section of the schema to provide some additional guidance to XFT.
> Also, you might look at Shrex (http://www.cs.utah.edu/~juliana/projects/ShreX/).
> Regards,
> Dan Marcus
> -----Original Message-----
> From: xmlschema-dev-request@w3.org [mailto:xmlschema-dev-request@w3.org] On Behalf Of Mansour Al Akeel
> Sent: Wednesday, April 02, 2008 11:56 AM
> To: xmlschema-dev@w3.org
> 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.
Received on Tuesday, 22 April 2008 13:12:24 UTC

This archive was generated by hypermail 2.3.1 : Wednesday, 7 January 2015 14:56:14 UTC