Re: XML in a Relational Database

From: Piculo ("Piculo")
Date: 10/24/04 

Date: Mon, 25 Oct 2004 02:04:37 +0700

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" <hp4444@kornet.net.korea> escribio en el mensaje
news:OyA7WxeuEHA.3476@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:%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

  • Re: DISCOVER_XML_METADATA
    ... expansion of ASSL XML returned by the server. ... You could do ExpandObject for the server in step 1. ... you could request ExpandObject for that database -- this is step ... all cubes and nothing else. ...
    (microsoft.public.sqlserver.olap)
  • Re: Preservation of namespace prefixes in XML datatype
    ... representation well beyond merely preserving the logical meaning. ... > Now the ANSI/ISO SQL-2003 standard makes it pretty clear that the XML ... all the guarantee the database gives you is that we preserve the ... >> makes changes in namespace prefixes, will I the user/developer have the ...
    (microsoft.public.sqlserver.xml)
  • Creating XML from an Oracle DB
    ... answer to what must be a FAQ when generating XML from Oracle but I cannot ... Oracle 9.2 database using DBMS_XMLQUERY and DBMS_LOB. ... As a result the UK pound sign contained in a VARCHAR2 column on the ...
    (perl.dbi.users)
  • Re: Wanted:MAIL.MAI structure definition
    ... a relational database is more flexible in the retrival of data. ... Perhaps this impact has been softened as hardware has gotten faster, but, overhead is overhead, and if you weren't using the advances in hardware for overhead, those designs that have less overhead would also gain from the faster hardware. ... RFC822 header because your XML parser wouldn't be able to understand new ...
    (comp.os.vms)
  • Re: Rework [Was: Static vs. Dynamic typing...]
    ... Agile projects have an extraordinarily low chance of a big change. ... Suppose you start with XML files, and by Iteration 6 the ... Switching to a database is now cheaper than morphing XML files into a ...
    (comp.object)