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

From: M D <md_at_md.com>
Date: Tue, 12 Sep 2006 07:30:47 GMT
Message-ID: <HmtNg.3212$cz3.449@edtnps82>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1158040456.466023_at_bubbleator.drizzle.com...

> 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

I think the oracle is providing this feature so that you can save xml documents in the xml typed field
and can be used as the system metadata to search on. Other guys like db2, mysql, mssql are proving
this feature. But I don't want to argue about it this is necessary or not. We are using it already and make
our customers happy. I am looking for someone can answer the question.

Thanks,
MD Received on Tue Sep 12 2006 - 02:30:47 CDT