From: le colibri <rvoogdgeert@...>
Date: 2007-08-11T08:09:59+09:00
Subject: Re: converting xml to MYSQL that reflects the "tag's embedding"?

On Aug 10, 11:51 am, Alex Young <a...@blackkettle.org> wrote:
> le colibri wrote:
> > Dear Ruby guru's,
>
> > Can any of you tell me how to convert xml to SQL?
>
> > The tags of the text I need to convert are linguistic in nature. E.g.
> > <sentence><clause><word><morpheme></morpheme></word></clause></
> > sentence> and the like.
>
> > What I need, is a database that somehow reflects the embedding. Can
> > this be done?
>
> I think what you need is a standard nested set structure, with the
> various nodes having tags for their type and content.  There's a good
> explanation here:http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
>
> --
> Alex

Thanks both Axel and Alex, I try out some of the suggestions.


Regards,
Robert.