You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@xml.apache.org by Howard Lee <ho...@zeborg.com> on 2000/11/01 19:37:07 UTC
Saving XML to DB
Hi folks,
What is the best way to save XML to DB when there are no tables that are
specific to the XML? We want to find a way to save any XML to DB, and able
to update the XML and so on. What's the best way? Would XML database (e.g.
excelon?) help our situation? Is there a plug in for Oracle to do that?
Thank you very much for any suggestions.
howard
Re: Saving XML to DB
Posted by Steve Muench <St...@oracle.com>.
| When you say "map in and out of tables", the tables already exist or these
| tables are not specific to any XML? (e.g. genetic schema to store any XML)
The tables reflect your business data but need not
be related to the incoming XML. XSLT is used as
a standard mapping technology.
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/
RE: Saving XML to DB
Posted by Howard Lee <ho...@zeborg.com>.
Hi Steve,
When you say "map in and out of tables", the tables already exist or these
tables are not specific to any XML? (e.g. genetic schema to store any XML)
Thanks!
-----Original Message-----
From: Steve Muench [mailto:Steve.Muench@oracle.com]
Sent: Wednesday, November 01, 2000 10:51 AM
To: general@xml.apache.org
Subject: Re: Saving XML to DB
The Oracle XML SQL Utility can do the job.
http://technet.oracle.com/tech/xml
My "Building Oracle XML Applications" book from O'Reilly
gives lots of examples of how to use it in real world
situations.
It doesn't create the tables for you, but it can
map in and out of tables or richly-structured object views.
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/
----- Original Message -----
From: "Howard Lee" <ho...@zeborg.com>
To: <ge...@xml.apache.org>
Sent: Wednesday, November 01, 2000 10:37 AM
Subject: Saving XML to DB
| Hi folks,
|
| What is the best way to save XML to DB when there are no tables that are
| specific to the XML? We want to find a way to save any XML to DB, and able
| to update the XML and so on. What's the best way? Would XML database (e.g.
| excelon?) help our situation? Is there a plug in for Oracle to do that?
| Thank you very much for any suggestions.
|
| howard
|
|
| ---------------------------------------------------------------------
| In case of troubles, e-mail: webmaster@xml.apache.org
| To unsubscribe, e-mail: general-unsubscribe@xml.apache.org
| For additional commands, e-mail: general-help@xml.apache.org
|
|
---------------------------------------------------------------------
In case of troubles, e-mail: webmaster@xml.apache.org
To unsubscribe, e-mail: general-unsubscribe@xml.apache.org
For additional commands, e-mail: general-help@xml.apache.org
Re: Saving XML to DB
Posted by Steve Muench <St...@oracle.com>.
The Oracle XML SQL Utility can do the job.
http://technet.oracle.com/tech/xml
My "Building Oracle XML Applications" book from O'Reilly
gives lots of examples of how to use it in real world
situations.
It doesn't create the tables for you, but it can
map in and out of tables or richly-structured object views.
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/
----- Original Message -----
From: "Howard Lee" <ho...@zeborg.com>
To: <ge...@xml.apache.org>
Sent: Wednesday, November 01, 2000 10:37 AM
Subject: Saving XML to DB
| Hi folks,
|
| What is the best way to save XML to DB when there are no tables that are
| specific to the XML? We want to find a way to save any XML to DB, and able
| to update the XML and so on. What's the best way? Would XML database (e.g.
| excelon?) help our situation? Is there a plug in for Oracle to do that?
| Thank you very much for any suggestions.
|
| howard
|
|
| ---------------------------------------------------------------------
| In case of troubles, e-mail: webmaster@xml.apache.org
| To unsubscribe, e-mail: general-unsubscribe@xml.apache.org
| For additional commands, e-mail: general-help@xml.apache.org
|
|
Re: Saving XML to DB
Posted by Kimbro Staken <ks...@dbxmlgroup.com>.
Something that Matt mentioned that is also worth looking at is dbXML. It is
still under development but is rapidly getting to a very usable state. The
source is LGPL. Take a look at http://www.dbxmlgroup.com/core.html. I think
it is pretty cool but admittably I'm biased. :-)
Kimbro Staken
Chief Technology Officer
dbXML Group L.L.C.
http://www.dbxmlgroup.com
----- Original Message -----
From: "Thomas B. Passin" <tp...@mitretek.org>
To: <ge...@xml.apache.org>
Sent: Tuesday, November 07, 2000 8:04 AM
Subject: Re: Saving XML to DB
> Matt Jones wrote about a new xml database effort -
>
> > We've been working on an XML database that we call Metacat that uses
> > Xerces as its XML parser. Metacat exposes an API that allows us to
> > store arbitrary XML documents in a relational database (via JDBC)
> > without creating custom tables for each XML doctype. Right now we are
> > using Oracle as a backend, but other databases are possible as well
> > (but haven't been tested). Metacat enables structured search of the
> > document contents (ie, we don't just store the XML in a BLOB) even
> > though the database has no prior knowledge of the XML schema/dtd.
> >
> ...
> > Check out http://www.nceas.ucsb.edu/kdi for more information on the
> > project. That's where we'll be posting our code as we make it
> > available.
> >
> This sound really interesting. But your server won't cough up the main
> frame in the page, only the header and navigation frames. Can you get
> the whole page working outside your intranet?
>
> Regards,
>
> Tom Passin
>
>
> ---------------------------------------------------------------------
> In case of troubles, e-mail: webmaster@xml.apache.org
> To unsubscribe, e-mail: general-unsubscribe@xml.apache.org
> For additional commands, e-mail: general-help@xml.apache.org
>
>
Re: Saving XML to DB
Posted by "Thomas B. Passin" <tp...@mitretek.org>.
Matt Jones wrote about a new xml database effort -
> We've been working on an XML database that we call Metacat that uses
> Xerces as its XML parser. Metacat exposes an API that allows us to
> store arbitrary XML documents in a relational database (via JDBC)
> without creating custom tables for each XML doctype. Right now we are
> using Oracle as a backend, but other databases are possible as well
> (but haven't been tested). Metacat enables structured search of the
> document contents (ie, we don't just store the XML in a BLOB) even
> though the database has no prior knowledge of the XML schema/dtd.
>
...
> Check out http://www.nceas.ucsb.edu/kdi for more information on the
> project. That's where we'll be posting our code as we make it
> available.
>
This sound really interesting. But your server won't cough up the main
frame in the page, only the header and navigation frames. Can you get
the whole page working outside your intranet?
Regards,
Tom Passin
Re: Saving XML to DB
Posted by Matt Jones <jo...@nceas.ucsb.edu>.
-----BEGIN PGP SIGNED MESSAGE-----
Howard,
We've been working on an XML database that we call Metacat that uses
Xerces as its XML parser. Metacat exposes an API that allows us to
store arbitrary XML documents in a relational database (via JDBC)
without creating custom tables for each XML doctype. Right now we are
using Oracle as a backend, but other databases are possible as well
(but haven't been tested). Metacat enables structured search of the
document contents (ie, we don't just store the XML in a BLOB) even
though the database has no prior knowledge of the XML schema/dtd.
This is all accomplished by modeling the data as the DOM tree rather
than the explicit schema of the XML document, and then providing a
Java servlet layer on top of that. We have a limited subset of XPath
query capability working against the document store, and have done
some clever query optimization work. We also have enabled XSLT
transformations of the XML documents on output, so it is simple to
develop a web-based presentation of the metadata for an arbitrary
number of XML document types.
Our research project, the Knowledge Network for Biocomplexity, is
doing this work in the context of a metadata repository for a
distributed data network, but I think the effort is generically
useful. It has many similarities to the dbXML project and the Lore
project at Stanford in its goals, but it utilizes existing relational
databases and so gains several enterprise features right out of the
box. It also has similarities to the Oracle XSQL tools that they
ship, but doesn't require a template map to convert XML to relational
form. We find this approach substantially more flexible than the
XSQL approach, although they both have their uses (xsql is v. useful
for integrating xml data with and converting it to legacy RDBMS
schemas).
Check out http://www.nceas.ucsb.edu/kdi for more information on the
project. That's where we'll be posting our code as we make it
available.
Unfinished features that are still on our TODO list include:
- DOM API support (we use a simpler API now)
- Full XPath support
- Namespace support
If you're interested in the products, let me know and I'll see what
we can arrange. We are currently in a testing phase, and plan our
first major release for January 2001, although I could probably
arrange for you to test our current beta version now.
Take care,
Matt
Howard Lee wrote:
>
> Hi folks,
>
> What is the best way to save XML to DB when there are no tables
> that are specific to the XML? We want to find a way to save any XML
> to DB, and able to update the XML and so on. What's the best way?
> Would XML database (e.g. excelon?) help our situation? Is there a
> plug in for Oracle to do that? Thank you very much for any
> suggestions.
>
> howard
>
> --------------------------------------------------------------------
> - In case of troubles, e-mail: webmaster@xml.apache.org
> To unsubscribe, e-mail: general-unsubscribe@xml.apache.org
> For additional commands, e-mail: general-help@xml.apache.org
- --
******************************************************************
Matt Jones jones@nceas.ucsb.edu
http://www.nceas.ucsb.edu/
National Center for Ecological Analysis and Synthesis (NCEAS)
******************************************************************
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.1i
iQCVAwUBOgdFCCa3Tv4nECOlAQFSCwP/eyaIkbyS7RRTk9Mm1uTONq29iuUkepEZ
fJ3UG4Ng3XGfrSKPuWyNa7FQJrRxb8aYz1IP+e7v2M2zjiFRQyaFGLoRKszZ1if9
3zLq53oCWUoESgV+VZq2o7jp531s6L7tga6ClJtZlhwpfdumV9UdI4OhxM52wQ/i
sNOvt0KX62E=
=uCl3
-----END PGP SIGNATURE-----
RE: Saving XML to DB
Posted by Dennis Thrysøe <dt...@netnord.dk>.
Hi,
I am currently working on a commercial solution for just that. The
technology is called Eplix and goes a bit further.
Mail me, if you'd like some more information.
-dennis
> -----Original Message-----
> From: Howard Lee [mailto:howard.lee@zeborg.com]
> Sent: 1. november 2000 19:37
> To: general@xml.apache.org
> Subject: Saving XML to DB
>
>
> Hi folks,
>
> What is the best way to save XML to DB when there are no tables that are
> specific to the XML? We want to find a way to save any XML to DB, and able
> to update the XML and so on. What's the best way? Would XML database (e.g.
> excelon?) help our situation? Is there a plug in for Oracle to do that?
> Thank you very much for any suggestions.
>
> howard
>
>
> ---------------------------------------------------------------------
> In case of troubles, e-mail: webmaster@xml.apache.org
> To unsubscribe, e-mail: general-unsubscribe@xml.apache.org
> For additional commands, e-mail: general-help@xml.apache.org
>
>