Storing XML

[Tom]

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]

Tom wrote:

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