> Matt Liotta wrote:
> parts. The CLOB method, on the other hand, avoids these context
> issues. Instead of mapping schema to rows, the database preserves
> the data context and hierarchy in one unit. However, a SQL query
> cannot look inside the field holding the document and interpret
That's just plain wrong - certainly in Oracle 9i, and probably other heavy
weight RDMS, there is a native XMLType column, and you can do XPath querys
stright to it with SQL.
> it�the only way to examine parts of a document is to return the
> whole thing in a result set."
Which makes that wrong too :-)
However in your other reply you go on to talk about databases with a native
XMLType, so I'm sure you must have been aware of that.
I'm also of the view that if you are starting to have to worry about one extra
disk (or more likly memory cache) read, you need to spend some more money on
your database :-)
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
