Path: news.f.de.plusline.net!news-fra1.dfn.de!storethat.news.telefonica.de!telefonica.de!news.germany.com!postnews.google.com!x35g2000prf.googlegroups.com!not-for-mail
From:  romeo.olympia@gmail.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: XML access for relational data...
Date: Fri, 01 Jun 2007 04:18:29 -0000
Organization: http://groups.google.com
Lines: 41
Message-ID: <1180671509.349990.5700@x35g2000prf.googlegroups.com>
References: <f3mq28$thp$1@nntp.fujitsu-siemens.com>
NNTP-Posting-Host: 202.153.117.2
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1180671509 18939 127.0.0.1 (1 Jun 2007 04:18:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 1 Jun 2007 04:18:29 +0000 (UTC)
In-Reply-To: <f3mq28$thp$1@nntp.fujitsu-siemens.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 PCCW-PXY-SVR12, 1.1 bssws03.pccw.com
Complaints-To: groups-abuse@google.com
Injection-Info: x35g2000prf.googlegroups.com; posting-host=202.153.117.2;
   posting-account=8VMzrQwAAAAQZy7CCARLku-GE5aKHoVa
Xref: news.f.de.plusline.net comp.databases.oracle.misc:79740

On May 31, 11:36 pm, Volker Hetzer <firstname.lastn...@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.

-