Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have an XML feed that i need to parse daily, i want to store all of the data from the XML feed in a SQL table so then that data can be queried and manipulated by my clients.

I can currently parse the XML data for select pieces of information for example the price of a product, but the pieces of data need to be user defined. I was wondering would it be possible to compare the XML data to a schema to allow me to find the names of each XML values.

Then i would be able to dynamically store the names of the XML values as attributes and the values of the XML data as a detail to that attribute, is there a way i can do this?

Will it have something to do with the schema that goes with the XML feed?

I would be using PHP to do this aswell

Thanks

James

share|improve this question
Which RDBMS are you using? – Phil Apr 25 at 15:08
I am currently using mysql – user1714133 Apr 25 at 15:10
Is there a way does anyone know? – user1714133 May 1 at 14:54

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.