Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: XML access for relational data...

Re: XML access for relational data...

From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Mon, 11 Jun 2007 12:41:48 +0200
Message-ID: <f4j8tc$2tg$1@nntp.fujitsu-siemens.com>


romeo.olympia_at_gmail.com schrieb:

> On May 31, 11:36 pm, Volker Hetzer <firstname.lastn..._at_ieee.org>
> wrote:

>> Hi!
>> We are designing a new database application whose job it is to collect
>> and provide data (structured and BLOB) to different departments.
>> The access method is to be http.
>> I hesitate to actually /store/ the data as XML but would like to
>> offer it as xml.
>> The idea is to provide a RESTful interface so that
>> GET/PUT/POST/DELETE requests do their actions.
>> However, so far I'm a bit stumped because I see no way
>> to
>> - use XMLDB to process the queries according to /my/ code (in
>> particular any URL parsing and parameter processing)
>> - offer XML data without /loading/ it into XMLDB as XML data.
>> Does anyone know how to solve these issues?
>>
>> I'd like to keep the relational structure because of all the
>> constraints, triggers, referential integrity, data change
>> notification and so on. Also, we will reference data held
>> in other, also conventional schemas.
>>
>> If possible at all I'd like to avoid putting the XML/Table
>> mapping into the application server.
>>
>> We are using 10gR2, about 50 users, a normal LAN and probably
>> less than 50GB of data.
>>
>> Lots of Greetings!
>> Volker
>> --
>> For email replies, please substitute the obvious.
> 
> XML DB should meet your application requirements then. See the Oracle
> XML DB Developers Guide for details.
> 
> You can keep your data in relational tables and expose them as XML.
> Read about URIs in that doc.

Will do.
Next stop is how to update documents and keep the link structure intact. But I'm new to all this xml stuff and really need to do a lot of reading right now.

Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.
Received on Mon Jun 11 2007 - 05:41:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US