Re: Using XML and a relational database

From: HansF (news.hans_at_telus.net)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 06:45:43 GMT

Alex Shirshov wrote:

>
> I want to store XML docs in DB avoiding file system, source control
> system, etc. How can I work with documents as xml, but not as CLOBs
> without a bare support of xml technologies in DBMS?

Just curious whether you have looked at the XMLType and the XML DB
capability intrinsic to Oracle?

/Hans

---
Below here is reference and links to Oracle info: Since this is cross
posted to a number of non-Oracle groups, for reference to those who have
not looked at the material, the relevant documentation links:

Oracle docco:
        http://docs.oracle.com

Oracle docco for Oracle9i Release 2:
        http://www.oracle.com/pls/db92/db92.docindex?remark=homepage

Oracle docco for 9iR2 XMLDB: (warning - link is split)
        http://download-west.oracle.com/docs/cd/B10501_01/
                appdev.920/a96620/xdb01int.htm

General info portal to Oracle XML capabilities:
        http://www.oracle.com/technology/tech/xml/index.html

(I've only referenced 9i Release 2 even though Oracle10g is out and has many
relevant improvements. Oracle has had XML support since 8i in the late
90's, and many don't like looking at the latest version.)

I've also dropped defunct newsgroups from the distribution.
        comp.database,
        comp.database.oracle,
        comp.database.oracle.server,
        comp.databases
in general are not relevant or current newsgroups.

FInally, for those who don't have access to the docco because they have not
registered with Oracle's TechNet, a snippet from the Oracle Concepts
manual:

XMLType

This Oracle-supplied type can be used to store and query XML data in the
database. XMLType has member functions you can use to access, extract, and
query the XML data using XPath expressions. XPath is another standard
developed by the W3C committee to traverse XML documents. Oracle XMLType
functions support many W3C XPath expressions. Oracle also provides a set of
SQL functions and PL/SQL packages to create XMLType values from existing
relational or object-relational data.

XMLType is a system-defined type, so you can use it as an argument of a
function or as the datatype of a table or view column. You can also create
tables and views of XMLType. When you create an XMLType column in a table,
you can choose to store the XML data in a CLOB column or object
relationally.

Relevant Pages

  • 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. ...
    (comp.databases.oracle.server)
  • Re: up front designs always useless
    ... >> so if I don't know up front whether I am going to use XML or an Oracle ... You can commit to risky decisions with little impact of changing ... decisions until as late as possible is an up front design decision. ...
    (comp.object)
  • Re: ?Best way to escape for xml?
    ... > Whatever you're getting is not well-formed xml. ... > source so that it applies the following character mapping on serialization: ... >> I have an Oracle Procedure that returns xml. ... >> - loading this into an XmlDocument using thedocument.LoadXml ...
    (microsoft.public.dotnet.xml)
  • Re: Store XML in database - newbie question
    ... Store it as IMAGE or NTEXT. ... In SQL Server 2005, you can use an XML datatype. ... > If you are using Oracle you can define a column as an XMLType this will ...
    (microsoft.public.dotnet.framework)
  • Re: Store XML in database - newbie question
    ... Store it as IMAGE or NTEXT. ... In SQL Server 2005, you can use an XML datatype. ... > If you are using Oracle you can define a column as an XMLType this will ...
    (microsoft.public.dotnet.framework.aspnet)