Re: Dealing with the flexible metadata structure with xml type database

MD wrote:
> We are using xml type in the oracle to support complex strucutre for our
> metadata.
> The xml can be as many as 200 elements in the node and can be repetitive.
> However, currently we experience the problem is that when client asks to get
> the search
> result it takes a lot of times to transform this xml to xml for the search
> result. For example
> when we have 300 metadata items, it takes 2 seconds to parse 10 xml records.
> Compare to
> regular database it's a lot more. I was wonder if there are any workaround
> for this problem.
>
> in side of xml type databse
>
> ID XMLTYPE
> 1. <?xml ....><root><item1>...</item200></root>
> 2. <?xml ....><root><item1>...</item200></root>
>
> Conver the data above to xml for displaying search result in the browser.
>
> <?xml version="1.0" ?>
> <searchresult>
> <record>
> <id>1</id>
> <item1>12</item1>
> ..
> ..
> </record>
> <record>
> <id>2</id>
> <item1>22</item1>
> </record>
> </result>
>
> This takes 2 seconds for 10 records.
>
> MD

XML is intended as a method of exchanging data ... not storing it. The solution is to use XML as it was originally intended before the marketing wonks decided to make it the buzz-word d'jour.

Store data relationally.

-- 
Daniel Morgan
Puget Sound Oracle Users Group