Converting xml to MYSQL that reflects the "tag's embedding"?

Ruby
1

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> and the like.

What I need, is a database that somehow reflects the embedding. Can
this be done?

Kind regards,
Robert.

2

Axel E. wrote:

The finding of the brackets can be done using regular expressions.

Should one use a XML parser for this?

http://www.ruby-doc.org/stdlib/libdoc/rexml/rdoc/index.html

This doesn’t solve the problem of how to map a tree onto relational
database tables, of course.

Lutz

3

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

4

On Aug 10, 11:51 am, Alex Y. [email protected] wrote:

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.

5

Kind regards,
Robert.

Dear Robert,

I think what you need is to identify “brackets of text” starting with
something like and ending with etc., then pass
these brackets to some variable in Mysql.

For Ruby and MySql, see here:
http://www.kitebird.com/articles/ruby-mysql.html

The finding of the brackets can be done using regular expressions.
I’ve written some code below.
You’d still need to choose some convenient variable name for the
different
types of brackets (sentence,word etc…)

Best regards,

Axel

class String
def find_positions(opening,closing)
open_p=[]
closing_p=[]
temp=self.dup
while opening.match(temp)
ref=opening.match(temp)
open_p<<temp.index(ref[0])
temp.sub!(ref[0],’ ‘*ref[0].length)
end
temp=self.dup
while closing.match(temp)
ref=closing.match(temp)
closing_p<<temp.index(ref[0])
temp.sub!(ref[0],’ '*ref[0].length)
end

# correctly associate opening and closing "brackets"
# check again, especially for nested brackets

brackets=[]
closing_p.each{|clb|
  temp=open_p.dup
  opb=(temp.delete_if{|y| y>clb}).max
  open_p=open_p-[opb]
  brackets<<[opb,clb]
}
return brackets.sort{|x,y|  x[0]<=>y[0]}

end
def find_brackets_text(opening,closing)
pos_array=self.find_positions(opening,closing)
text=[]
p ‘positions of brackets in the text’
p pos_array
pos_array.each{|op,cl|
p ‘opcl’
p op
p cl
text<<self[op…cl]
}
return text
end
end
a=“blablabla”
c=a.find_brackets_text(//,/</s>/)
p c