Re: Data Structure Question

> to something like
>
> <item><prod>book</prod> <qty>1</qty> <price>15.00</price></item>
> <item><prod>flowers</prod> <qty>12</qty> <price>50.00</price></item>
> <item><prod>toys</prod> <qty>2</qty> <price>30.00</price></item>
> <item><prod>car</prod> <qty>1</qty> <price>20000.00</price></item>
>
> Even given generously short attribute names, this does not appear to
> be shrinking the data in any way. In fact it is now looking larger
> (it is). Unless you are also sure you only have one or two lines on
> an invoice.

If he can create an XML schema to constrain the XML data, he can take advantage of structured storage. One of the advantages is reduced storage requirements. In that case, Oracle "compresses" the XML data according to its conformant XML schema.

Yong Huang Received on Fri Jan 21 2005 - 10:07:39 CST