Re: XMLType performance



The Geek Inside wrote:
Hello there,

I'm involved in a project with many XML managment and I'm evaluating using the XMLType to store several information types in XML structures and extract information from these.

This is the first time using XMLType, I would like to get some feedback about the preformance using XMLType.

The system will have many queries to this information.

Thanks in advance.

I would never store XML inside a database if it could be reconstituted
on demand.

Without knowing the full set of requirements my initial reaction would
be ... never store XML.

Consider the scability and storage of:
<thisisareallylongtag>1</thisisareallylongtab>
To which you can add the lack of relational integrity.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.



Relevant Pages

  • Re: Using XML and a relational database
    ... How can I work with documents as xml, ... Just curious whether you have looked at the XMLType and the XML DB ... Below here is reference and links to Oracle info: ... This Oracle-supplied type can be used to store and query XML data in the ...
    (microsoft.public.sqlserver.xml)
  • Re: XMLType performance
    ... I'm involved in a project with many XML managment and I'm evaluating using the XMLType to store several information types in XML structures and extract information from these. ... To which you can add the lack of relational integrity. ...
    (comp.databases.oracle.server)
  • Re: XMLType performance
    ... I'm involved in a project with many XML managment and I'm evaluating using the XMLType to store several information types in XML structures and extract information from these. ... Consider the scability and storage of: ...
    (comp.databases.oracle.server)
  • Re: Wanted:MAIL.MAI structure definition
    ... exports using XML. ... SMTP mail and all the software out there which processes RFC-compliant headers ... I would maintain that to store mail messages you would need to use CLOB ... Every mail message arriving into an OpenVMS system gets its format converted. ...
    (comp.os.vms)
  • Re: ruby / rexml / xpath bug?
    ... puts of the XML. ... end # end each store ... Longitude: -74.107299 ...
    (comp.lang.ruby)