Re: XML in a Relational Database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Han (hp4444_at_kornet.net.korea)
Date: 10/24/04 

Date: Mon, 25 Oct 2004 02:10:14 +0900

Recent versions of major DBMS supports XML in a way you save each XML documents in each records typed as XML field. Oracle and SQL. Especially in SQL 2005, now beta, supports Xquery which is used to query the XML within. If your XML is not constrained by schema, you will need frequent type-casting for query.

"Piculo" <PakPiculo(NoSPam.at)gmail.com> wrote in message news:%232MWuUYuEHA.2828@TK2MSFTNGP12.phx.gbl...
>I am trying to build a system to store several XML documents in one
> Database.
> The focus of this application is the XML documents could be whatever. I know
> nothing about the schema of the xml documents that i must save, only know
> that is a xml document valid.
>
> I am trying to store the node in one table, the attributes in another one,
> following (more or less) the DOM.
>
> But i am wondering if this project is already done. I have looked for
> something like this in internet but i find nothing. Do you know if exists a
> DataModel defined for this, and a application to use it?
>
> I already know that exists NXD, (Native Xml Database) but i am trying to do
> for MySql (or whatever Database).
>
> Thanks,
> PiCulo.
>
>

Relevant Pages

  • Oracle XML problem - difference in 9i and 10g
    ... I work primarily on a database which manages XML documents. ... looking into migrating some of our client applciation XML code to ... Oracle, but seem to be getting worrying results between Oracle 9i and ...
    (comp.databases.oracle.misc)
  • Re: Practicle Limitations of Index Server
    ... I use a XML Filter made by a friend to index XML documents. ... I'm querying my XML database using the SQL syntax and filling an ... It's very fast when i use a query with CONTAINS keyword (0.3 seconds to ... I have cached all the fields in the secondary cache. ...
    (microsoft.public.inetserver.indexserver)
  • Re: XQuery - Check if element exist?
    ... in one of our xml documents we store in the database. ... I just get an error saying .. ...
    (microsoft.public.sqlserver.xml)
  • Re: XML->XSL
    ... > I am looking for software which could convert XML documents to database ... > documents like Excel, Access or Dbase documents. ...
    (comp.text.xml)
  • XQuery - Check if element exist?
    ... in one of our xml documents we store in the database. ... should this really be hard or am i just stupid? ...
    (microsoft.public.sqlserver.xml)