You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@xml.apache.org by "Chen, PeterX" <pe...@intel.com> on 2000/01/12 00:34:55 UTC
XML/Database Applications . . .
I would like to know if the XML community at large is interested in using an
application that works with XML and relational databases. Specifically,
such an application would load an XML file into an existing table and be
able to map the data back out from the table into an appropriate XML file.
If there is an interest in the XML community for such an application, are
you expecting such an application to be developed by database vendors as a
feature in their database, or are you expecting such an application to be
developed by third party vendors as a standalone application that works with
existing relational databases? I would appreciate any and all responses.
Thanks you.
Peter
Re: XML/Database Applications . . .
Posted by Assaf Arkin <ar...@exoffice.com>.
Check out Castor at http://castor.exolab.org.
It provides mapping between Java objects and SQL, and Java objects and
XML, works both way and supports RDBMS relations. Java to LDAP is also
coming in the next release.
We've been using it to grab an object from the database (a three-table
relation into a three-object graph) produce XML and pipe the result into
Xalan to produce an HTML page. Works like a charm, eliminates lots of
code redundancy.
arkin
"Chen, PeterX" wrote:
>
> I would like to know if the XML community at large is interested in using an
> application that works with XML and relational databases. Specifically,
> such an application would load an XML file into an existing table and be
> able to map the data back out from the table into an appropriate XML file.
>
> If there is an interest in the XML community for such an application, are
> you expecting such an application to be developed by database vendors as a
> feature in their database, or are you expecting such an application to be
> developed by third party vendors as a standalone application that works with
> existing relational databases? I would appreciate any and all responses.
> Thanks you.
>
> Peter
Re: XML/Database Applications . . .
Posted by Mike Pogue <mp...@apache.org>.
PeterX,
IBM has such a thing, called "DB2 XML Extender", that maps XML either
to a single CLOB, or it can split and recombine the XML into multiple
database cells.
I'm sure that Oracle must have a similar thing.
You might want to contact those companies directly, for information on
those XML products. To my knowledge, there's no open source database
thing that does this.
Mike
Guy Hulbert wrote:
>
> Peter.
>
> I think the following:
> http://www.w3.org/XML/Activity#schema-wg
> indicates that the answers to most of your questions are "yes".
>
> I don't think that the xml.apache mailing lists are the right place to
> post this kind of question though.
>
> On Tue, 11 Jan 2000, Chen, PeterX wrote:
>
> |I would like to know if the XML community at large is interested in using an
> |application that works with XML and relational databases. Specifically,
> |such an application would load an XML file into an existing table and be
> |able to map the data back out from the table into an appropriate XML file.
> |
> |If there is an interest in the XML community for such an application, are
> |you expecting such an application to be developed by database vendors as a
> |feature in their database, or are you expecting such an application to be
> |developed by third party vendors as a standalone application that works with
> |existing relational databases? I would appreciate any and all responses.
> |Thanks you.
> |
> |Peter
> |
> |
>
> ----
> Guy Hulbert, Project Manager Bioinformatics Supercomputing Centre
> (416) 813-8876 555 University Avenue
> email: guy@bioinfo.sickkids.on.ca The Hospital for Sick Children
> http: www.bioinfo.sickkids.on.ca Toronto, ON, M5G 1X8, CANADA.
RE: XML/Database Applications . . .
Posted by Ismael Ghalimi <gh...@exoffice.com>.
Hi,
I am not sure it would help, but I suggest you take a look at Castor:
http://castor.exolab.org/
Best regards
ig.
> -----Original Message-----
> From: Guy Hulbert [mailto:guy@bioinfo.sickkids.on.ca]
> Sent: Tuesday, January 11, 2000 4:05 PM
> To: Chen, PeterX
> Cc: general@xml.apache.org
> Subject: Re: XML/Database Applications . . .
>
>
> Peter.
>
> I think the following:
> http://www.w3.org/XML/Activity#schema-wg
> indicates that the answers to most of your questions are "yes".
>
> I don't think that the xml.apache mailing lists are the right place to
> post this kind of question though.
>
> On Tue, 11 Jan 2000, Chen, PeterX wrote:
>
> |I would like to know if the XML community at large is interested
> in using an
> |application that works with XML and relational databases. Specifically,
> |such an application would load an XML file into an existing table and be
> |able to map the data back out from the table into an appropriate
> XML file.
> |
> |If there is an interest in the XML community for such an application, are
> |you expecting such an application to be developed by database
> vendors as a
> |feature in their database, or are you expecting such an application to be
> |developed by third party vendors as a standalone application
> that works with
> |existing relational databases? I would appreciate any and all responses.
> |Thanks you.
> |
> |Peter
> |
> |
>
> ----
> Guy Hulbert, Project Manager Bioinformatics Supercomputing Centre
> (416) 813-8876 555 University Avenue
> email: guy@bioinfo.sickkids.on.ca The Hospital for Sick Children
> http: www.bioinfo.sickkids.on.ca Toronto, ON, M5G 1X8, CANADA.
>
>
Re: XML/Database Applications . . .
Posted by Guy Hulbert <gu...@bioinfo.sickkids.on.ca>.
Peter.
I think the following:
http://www.w3.org/XML/Activity#schema-wg
indicates that the answers to most of your questions are "yes".
I don't think that the xml.apache mailing lists are the right place to
post this kind of question though.
On Tue, 11 Jan 2000, Chen, PeterX wrote:
|I would like to know if the XML community at large is interested in using an
|application that works with XML and relational databases. Specifically,
|such an application would load an XML file into an existing table and be
|able to map the data back out from the table into an appropriate XML file.
|
|If there is an interest in the XML community for such an application, are
|you expecting such an application to be developed by database vendors as a
|feature in their database, or are you expecting such an application to be
|developed by third party vendors as a standalone application that works with
|existing relational databases? I would appreciate any and all responses.
|Thanks you.
|
|Peter
|
|
----
Guy Hulbert, Project Manager Bioinformatics Supercomputing Centre
(416) 813-8876 555 University Avenue
email: guy@bioinfo.sickkids.on.ca The Hospital for Sick Children
http: www.bioinfo.sickkids.on.ca Toronto, ON, M5G 1X8, CANADA.