From: Alex Young <alex@...>
Date: 2007-08-10T18:51:56+09:00
Subject: Re: converting xml to MYSQL that reflects the "tag's embedding"?

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