Take the 2-minute tour ×
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.

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 '13 at 15:08
    
I am currently using mysql –  user1714133 Apr 25 '13 at 15:10
    
Is there a way does anyone know? –  user1714133 May 1 '13 at 14:54

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.