Re: storing data in xml?

From: Paul Bramscher (brams006_nospam_at_tc.umn.edu)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 15:50:55 -0500

Zurab Davitiani wrote:

> Gernot Frisch wrote:
>
>
>>I want to store a few informations the user entered on my website.
>>However I don't want to use a MySQL database for this. Don't ask me
>>why, I just don't want to. Now I'd like to use XML - is this easy with
>>php? If not, I'll use a text file.
>
>
> If you are using XML to store some preferences or data that you want to
> easily manipulate - e.g. transform into something else, send via web
> service, etc. then use XML. But I would not recommend using XML as a
> general data storage. XML is not meant to replace a database and should not
> be used for that purpose. If you do not want to use a database server (for
> whatever reason), then at least use something like Berkeley DB.

I store data in indexed and normalized RDBMS's, the most efficient
format for storage and retrieval.

If you need XML, why not retrieve the raw data and just wrap XML tags
around it for some application that wants XML for sharing/presenation
purposes? By the why heck actually store it in XML? RBDMS's were
designed in the 1970's to solve this very problem. If you have a
hundred thousand rows of data, do you really want a hundred thousand XML
open and close tag pairs? Waste of storage and a bad architecture.

Relevant Pages

  • Re: SQL SERVER
    ... It's not only an Explorer problem. ... number of files you need to store: it's the same problem in every file ... Here is sample you want for why storing XML in a database: ... XML column of the table the definition you want (it's not relational any ...
    (microsoft.public.sqlserver.msde)
  • Re: DataBase
    ... > You can use XML to store the data pretty easily. ... > with ADO.net you can import or export the data to XML. ... > Andrew J. Kelly SQL MVP ... >> database, but I need it not to use any SQl server. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Wanted:MAIL.MAI structure definition
    ... exports using XML. ... SMTP mail and all the software out there which processes RFC-compliant headers ... I would maintain that to store mail messages you would need to use CLOB ... Every mail message arriving into an OpenVMS system gets its format converted. ...
    (comp.os.vms)
  • Re: ruby / rexml / xpath bug?
    ... puts of the XML. ... end # end each store ... Longitude: -74.107299 ...
    (comp.lang.ruby)
  • Re: RSS SQL tables
    ... optimal database structure. ... Define all the elements you want to store. ... xml does not translate well to a relational database. ...
    (comp.databases)