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

From: Cimode <cimode_at_hotmail.com>
Date: 27 Mar 2007 01:34:29 -0700
Message-ID: <1174984469.588351.137070_at_p77g2000hsh.googlegroups.com>


On Mar 26, 11:15 pm, "Karen Hill" <karen_hil..._at_yahoo.com> wrote:
> X-No-Archive:yes
>
> I see people putting XML documents in databases. Why do they do this,
> what is the logic behind it? Why not just put the data into tables?
> Why are the standards committees going along with this (XML SQL/
> MED)? Why don't people just use tables to store the data thusly:
>
> CREATE TABLE FOO_CUSTOMER
> (
> name VARCHAR
> address VARCHAR
> key INT
> );
>
> why are they doing this:
>
> CREATE TABLE BAD_XML_CUSTOMER
> (
> customer_data XML
>
> );
XML is a hybrid reeminiscence of hierarchical/navigational approach for storing data. There is no inherent objective logic to it. In other words, don't search coherence in incoherence. Received on Tue Mar 27 2007 - 10:34:29 CEST

Original text of this message