Re: Database schema

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