Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Dealing with the flexible metadata structure with xml type database

Dealing with the flexible metadata structure with xml type database

From: MD <MD_at_MD.com>
Date: Mon, 11 Sep 2006 23:13:45 GMT
Message-ID: <J4mNg.2793$E67.2290@clgrps13>


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 Received on Mon Sep 11 2006 - 18:13:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US