Re: What is the logic of storing XML in a Database?

From: Bernard Peek <>
Date: 28 Mar 2007 15:24:06 GMT
Message-ID: <>

On 2007-03-28, Daniel <> wrote:
> On Mar 28, 9:55 am, "Cimode" <> wrote:
>> On Mar 28, 1:21 pm, Bernard Peek <> wrote:> On 2007-03->
>> > Data can be validated before it's transmitted.
>> Does that mean that CSV data with a header can't be validated?
> Of course not, an application at the endpoint can employ custom code
> to check the contents of the file, using a custom description of the
> flat file (the header isn't enough.)

That depends entirely on what data you put in the header. If by header you mean a list of field-names then you are correct. I was assuming a broader definition that would include other information such as constraints.


>> So what you are saying is that an XML file takes less space (less
>> verbose) than a flat CSV file?
> This is the only point on which I would be inclined to differ from
> Bernard :-)

I would say that a flat file containing all of the information in an XML file might well be larger than the XML version. It's not a foregone conclusion that XML files are larger. Both types of file are likely to have frequently repeated strings, and if so will compress well.

As always a lot depends on how the technology is used rather than just the technology.

In search of cognoscenti
Received on Wed Mar 28 2007 - 17:24:06 CEST

Original text of this message