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

RE: Database schema from standards xsd

From: Daniel Marcus <dmarcus@npg.wustl.edu>
Date: Thu, 3 Apr 2008 09:55:21 -0500
To: Mansour Al Akeel <mansour.alakeel@gmail.com>, "xmlschema-dev@w3.org" <xmlschema-dev@w3.org>
Message-ID: <4476B37DB8F5D248AE7C349966A22A04032C5F1B24@nilex07.neuroimage.wustl.edu>

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/).

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 Thursday, 3 April 2008 14:58:52 UTC

This archive was generated by hypermail 2.4.0 : Friday, 17 January 2020 23:15:46 UTC