XML in relational database ? WAS RE: [thelist] worldusa.com sucks

I have seen a lot of applications using XML in relational databases.  In any
cases, it seems to make sense ( as in the example below).  But doesn't this
kind of defeat the purpose of relational DBs?  In Matt's original example,
what if I wanted to add a feature that gives users who have more than 3
items a special deal?  I can't query the database to get those numbers
directly, since the data is stored as an XML packet.


Chris Evans
chris@fuseware.com
http://www.fuseware.com


-----Original Message-----
From: thelist-admin@lists.evolt.org
[mailto:thelist-admin@lists.evolt.org]On Behalf Of Anthony Baratta
Sent: Monday, April 03, 2000 6:37 PM
To: thelist@lists.evolt.org
Subject: Re: [thelist] worldusa.com sucks


Matt Warden wrote:

> <tip>
> Let's say you have a database table that holds... oh... how about a
> shopping cart. You could create a table to relate a shopping cart to
> shopping cart items (one to many). Or you could use a makeshi(f)t data
> cube like structure using XML. Oh, let's say you have this in your
>
> .....
>
> That said, let me say that I haven't actually used this in a live
> environment, but it seems like it would work well, provided that the
> database could handle large strings of XML for big, many-itemed carts.
>
> </tip>

BTW - I'm doing this already. Works sweet!!! Great minds think alike.

--
Anthony Baratta

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !