[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: How to store XML in Oracle?

storing xml in oracle
Christer Nordvik wrote:

> How do you store XML documents in Oracle? I have 200 objects that are
> described in XML and are stored as CLOBs. When I read them from the DB
> they take 0.2-0-3sec to read each. The screen usually consists of 10-20
> objects, and that means that the server uses 2-3sec to generate the
> resulting document(SVG actually). I find 2-3 seconds to be a bit much so
> if anyone have any good ideas they are very welcome.

There are two ways to do this. One is as CLOBs as you are doing. In
Oracle 9i, these can be indexed and queried with XPath, although I'm not
sure that would be of any use to you. The other way is with an
object-relational mapping using the Oracle XML SQL Utility for Java.

In your case, I am curious as to why you are storing the data as XML.
Why not store it directly in object-specific tables or in a generic set
of tables that can be used to describe any object? That would save you
having to parse the XML, which I'm assuming is slower than direct access
to the data.

-- Ron


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.

Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.