What is the logic of storing XML in a Database?
From: Karen Hill <karen_hill22_at_yahoo.com>
Date: 26 Mar 2007 15:15:42 -0700
Message-ID: <1174947342.905208.135110_at_e65g2000hsc.googlegroups.com>
X-No-Archive:yes
Date: 26 Mar 2007 15:15:42 -0700
Message-ID: <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
); Received on Tue Mar 27 2007 - 00:15:42 CEST