W3C home > Mailing lists > Public > xmlschema-dev@w3.org > February 2001

Re: XML versus Relational Database

From: Matt Sergeant <matt@sergeant.org>
Date: Thu, 1 Feb 2001 09:12:41 +0000 (GMT)
To: Dream Catcher <isc70409@leonis.nus.edu.sg>
cc: "'xmlschema-dev@w3.org'" <xmlschema-dev@w3.org>, "xml-dev@lists.xml.org" <xml-dev@lists.xml.org>
Message-ID: <Pine.LNX.4.30.0102010908380.29804-100000@ted.sergeant.org>
On Thu, 1 Feb 2001, Dream Catcher wrote:

> Hello,
>  Although I am developing an application for securing XML data. This
> morning I woke up and came out a general question: Is it really a better
> idear to store data in XML structure instead of relational table? As we
> know to bulid a DOM tree is quite expensive for main memory...Any advice
> and opinion are cherished...:-)

It totally depends on your application needs, and often the size of the
database. For example, on one of my web sites (a news/articles portal) I
store all of the headlines in RSS files. This is good enough, because
there aren't that many articles. And I query them with XPath. But if the
numbers were to extend beyond say 500 records I'd want to think about
archiving some away somehow, because it would become too slow.

Note that there are some really strong reasons not to just use XML files
as a replacement for an RDBMS, most importantly ACID transactions (I get
around this with atomic renames, but its not a great substitute).


    /||    ** Director and CTO **
   //||    **  AxKit.com Ltd   **  ** XML Application Serving **
  // ||    ** http://axkit.org **  ** XSLT, XPathScript, XSP  **
 // \\| // **     Personal Web Site: http://sergeant.org/     **
    //  \\
Received on Thursday, 1 February 2001 04:12:51 UTC

This archive was generated by hypermail 2.3.1 : Wednesday, 7 January 2015 14:55:50 UTC