XML in a Relational Database

[Piculo]

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.

[Piculo]

But i cannot use oracle because it is expensive, and MSSql the same. I need
a cheap and light database. Oracle and MSSql spends a lot of resources of
the machines.
My alternatives are MySql or Postgress, or maybe Access but i think the last
one it is no so powerfull like the previos ones.

Cheers,
PiKulo.

"Han" <hp****@kornet.net.korea> escribio en el mensaje
news:Oy**************@TK2MSFTNGP14.phx.gbl...

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:%2****************@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.

[Han]

No, at least MS-SQL is free. Without IDE, MS-SQL express is free. If you are
comfortable with command lines of MySQL, you'll be same with MS-SQL express.
With more power on XML. And same database engine of commercial version of
MS-SQL.

http://www.microsoft.com/downloads/d...displaylang=en

"Piculo" <PakPiculo(NoSPam.at)gmail.com> wrote in message
news:ub**************@TK2MSFTNGP14.phx.gbl...

But i cannot use oracle because it is expensive, and MSSql the same. I
need a cheap and light database. Oracle and MSSql spends a lot of
resources of the machines.
My alternatives are MySql or Postgress, or maybe Access but i think the
last one it is no so powerfull like the previos ones.

Cheers,
PiKulo.

"Han" <hp****@kornet.net.korea> escribio en el mensaje
news:Oy**************@TK2MSFTNGP14.phx.gbl...

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:%2****************@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.