How to query XML data? Move data to MySQL or xQuery?

[akristof]

OK since my post was moved to a new thread let me add some context :)

I was asking about help with figuring out how to go about implementing xQuery or mySQL to analyze large datasets.

At this point I am very good at data management using XML and manipulation using PHP (and then displaying the data back to the user using the XMLHttpRequest object in Javascript).

While XML was super intuitive and easy to learn it has obvious limitations. I am now working on something where I need to run some queries on my datasets. From looking around the web I can tell this will either have something to do with xQuery and/or mySQL.. but of course no one is able to dumb it down to human speak for someone who has never used these before. Given that my data is now in XML, xQuery seems like a logical option but something tells me that mySQL is more robust for large datasets and lot of users and might therefore be preferable. That said I have no idea where to get started with either one. Any help you can provide or resources you can suggest would be extremely helpful.

Thanks much.

[johny10151981]

Not only mysql, there is other option too. if you want to start with mysql not a bad choice. But if you want to use mysql then you would have to think a way to convert your xml file into mysql database system. interesting thing is you can use XML engine in mysql. that is your data will be stored in xml format in database server.

But as far I know xml database would take much more physical memory than other database engine.

you have lots of choice though..