Re: What is the logic of storing XML in a Database?
Date: Tue, 27 Mar 2007 22:42:58 GMT
Message-ID: <S5hOh.19095$uo3.4311_at_newssvr14.news.prodigy.net>
"Karen Hill" <karen_hill22_at_yahoo.com> wrote in message
news:1174947342.905208.135110_at_e65g2000hsc.googlegroups.com...
> 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
>
> );
>
I worked with a DBMS in the 80's that had array as a data type. At first I hated it, then I used it. The big problem is what is the domain of an array and how do you do joins? And when you think about it, this did not violate 1NF. XML is similar. Received on Wed Mar 28 2007 - 00:42:58 CEST