Re: XMLType design implications

dataplex_at_gmail.com wrote:
> I'm designing a new database using Oracle 9i Release 2 (which we will
> later migrate to 10g). For the solution I chose to design an XML
> Schema for my data collection and store all my data as XML.

Other than a strong streak of masochism and a desire to waste disk space ... why? What is the business case?

Store relationally and reconstruct XML as output IF required.

My guideline for XML is to use it for what it is good at ... messaging. And to quash it in any and all other uses where it is unscalable and a waste of resources.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org