Storing XML

[Tom (archive)]

Hi,

I'm designing a website where all the articles/news will be stored in XML. (I will use PHP to parse the XML.) Should I store the XML in separate .xml files or should I store the XML in a MySQL database? Which would be faster?

Best regards,

Tom

 

[Saqib Ali]

I'm designing a website where all the articles/news will be stored in

XML. (I will use PHP to parse the XML.) Should I store the XML in separate .xml files or should I store the XML in a MySQL database? Which would be faster?

I have lots of XML documents on my server @ http://validate.sf.net . I m using Apach Xindice ( http://xml.apache.org/xindice/ ) to store some of the document. It works very nicely. Xindice is open source.

Using a Object/Relational DB (including Oracle) is NOT a good idea, to store XML. Unless your XML schema is flat, it will not be easy to map to a Relational DB. If you *MUST* use a Relational DB, look into http://www.intsysr.com/odbc2xml.htm

If your application requires storing a large amount of data and faster querying, look into http://www.objectivity.com/ . Objectivity is a pure Object Oriented DB, which will map to XML schema better.

In Peace,
Saqib Ali
http://validate.sf.net

 

[Sebastian Bossung]

Hi,

I'm designing a website where all the articles/news will be stored in XML. (I will use PHP to parse the XML.) Should I store the XML in separate .xml files or should I store the XML in a MySQL database? Which would be faster?

You probably should consider using a native XML database like eXist (http://www.exist-db.org/). It allows you to store XML documents and also query them using the structure of your XML. eXist implements the query language XQuery for that.

Sebastian