Web lists-archives.com

Re: Xml data import




----- Original Message -----
> From: "Sayth Renshaw" <flebber.crue@xxxxxxxxx>
> Subject: Xml data import
> 
> I have an xml data feed with xsd, it's complex in elements not size. Wray
> are the best way to get data into mysql, do I have to hack with xquery?

That's going to depend on the complexity of your XML and how much of that complexity you want preserved. There's definitely libraries out there that can map XML (tree) structures onto relational structures; although it's been so long since I played with XML that I really couldn't tell you which ones.

> My goal is to be able create queries and send csv files out for analysis in
> R and plots in ggplot2. Also render done other off the initial days to the
> Web usually xslt from xml.

I suppose that worstcase you could use XSLT to transform into a flatter structure, maybe even CSV?


-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql