creating DB from an XSD or XML

["Rodríguez Miguélez, Adolfo" <ad...@mapfre.com>]

>From time ago I am loooking fo a way to do the following.

Assuming that I have some kind of DTD or XSD for XMLs. I would like to
create, a database, or DDL, to reproduce the DTD or XSD estructure in my
database schema. Could be this done with an automathic procedure. In other
words, is currently possible to create a database schema reproducing the
structure of an XSD or DTD? Such a DTD or XSD would not be database aware at
all.

I am developing a web application focused for a kind of business which
already has very well defined XML schemas and I would like to create the
database following the same estructure, if possible, as an authomatic
procedure, maybe with OJB, or OJB plus something.... It would easy me to
receive XMLs from an external web service an automathically store them in
DB, or the opposite make a valid XML conforming the DTD or XSD from my
database assuming that both have same strutucture.

TIA,

Adolfo

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: creating DB from an XSD or XML

[jg...@renr.es]

Hi, Adolfo

I´dont know any tool to make a DDL from a DTD. I´ve do itby hand. Usuarlly,
a dtd maps against a unique table and it doesn´t so difficult.

For extract xml we use digister (jakarta.apache.org/commons). It has a good
works to map xml/object.

My database has a table with the data, I use ojb to make persistence and
digister to map the xml. It´s easy.


Greetings

Jose Galiana
Director de proyectos
Recursos en la Red, S.L.U.

> From time ago I am loooking fo a way to do the following.
>
> Assuming that I have some kind of DTD or XSD for XMLs. I would like to
> create, a database, or DDL, to reproduce the DTD or XSD estructure in
> my database schema. Could be this done with an automathic procedure. In
> other words, is currently possible to create a database schema
> reproducing the structure of an XSD or DTD? Such a DTD or XSD would not
> be database aware at all.
>
> I am developing a web application focused for a kind of business which
> already has very well defined XML schemas and I would like to create
> the database following the same estructure, if possible, as an
> authomatic procedure, maybe with OJB, or OJB plus something.... It
> would easy me to receive XMLs from an external web service an
> automathically store them in DB, or the opposite make a valid XML
> conforming the DTD or XSD from my database assuming that both have same
> strutucture.
>
> TIA,
>
> Adolfo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org