XML interface to Oracle

Michael Kay M.H.Kay at eng.icl.co.uk
Mon Dec 15 16:36:09 GMT 1997

-----Original Message-----
From: Martin Bryan <mtbryan at sgml.u-net.com>
To: xml-dev at ic.ac.uk <xml-dev at ic.ac.uk>
Date: 15 December 1997 16:14
Subject: XML interface to Oracle

>I have just been asked by the European Commission Statistics Office if
>anyone has yet hooked an XML parser directly to an Oracle database. (They
>need to transfer large amounts of data between heterogeneous databases ...

Then why specify Oracle in the question?

There are at least two obvious ways of representing a table in XML, the main
is whether to represent data values as attributes or as content. No doubt,
given the
richness of XML, the experts could come up with many less obvious
as well. Using any of the parsers I have looked at, any of these formats
could be trivially
translated into the kind of input formats (e.g. CSV files) that existing
RDBMSs will accept.
Or perhaps by "directly" you want to avoid the intermediate CSV file: well
that's not difficult
either but it's more work and I don't see much benefit in it.

There's a class in the MSXML distribution that gives ADO access to an XML
file, which
illustrates what can be done, though of course this is Microsoft

But it all begs the question, what are you (or they) trying to achieve? Is
there really a practical
problem with transferring data between relational databases that XML can
solve? People do
it all the time with various flavours of CSV, so why bother?

Mike Kay

xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo at ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo at ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa at ic.ac.uk)

More information about the Xml-dev mailing list