Looking for Java mapping programe(XML --> Relatinal database schema)

Thread view:

Heejeong Lee - 25 May 2004 12:33 GMT

I am going to begin following project

Description of the project:

One of the proposed ways of storing XML is to "shred" the structure of
the XML document and
insert it into a relational DBMS. To do this, I will consider the
query
workload over the XML document. The purpose of this project is to
identify a cost-based approach to
XML decomposition taking into account a query workload. Different
query workloads will lead to
different decompositions of the same XML document.

For starting, I am looking for Java sauce code( XML - > RDB schema).
And then I will make a query specific algoritm and use it with Java
mapping program
to generate RDB schema.

So, my questions:
1) Is there a java mapping programe (an xml file to a database)?
2) Is there any available algorithm to use for this?

Any comments will be appreciated!!
Thanks,
aprilcoco

Reply to this Message

GIMME - 25 May 2004 18:23 GMT

> Description of the project:
>
> One of the proposed ways of storing XML is to "shred" the structure of
> the XML document and insert it into a relational DBMS.

Which DBMS? Oracle 9 has lots of XML toys ...

>To do this, I will consider the query workload over the XML document.

Translate again please. "query workload over the xml document" is unclear.

> The purpose of this project is to identify a cost-based approach to
> XML decomposition taking into account a query workload.

What kind of cost?

> Different query workloads will lead to different decompositions of

the same XML document.

So you expect to load lots of documents and to have users make queries
over them in different ways?

> For starting, I am looking for Java sauce code( XML - > RDB schema).

What kind of source code do you want ? A program using metadata which
fetched a List of JDOM elements using JDBC 2.0 meta data can be written
by hand in a few minutes.

> And then I will make a query specific algoritm and use it with Java
> mapping program to generate RDB schema.

If you have a real budget, check out Enginium.

> So, my questions:
> 1) Is there a java mapping programe (an xml file to a database)?

If you want to see the JDOM/JDBC quick version let me know ...

> 2) Is there any available algorithm to use for this?

Reply to this Message

Heejeong Lee - 26 May 2004 10:58 GMT

Thank you for interesting of my posting(Looking for Java mapping
programe(XML --> Relatinal database schema).
I am condiderting using PostgreSQL. But it doesn't matter. Because I
just want to generate
RDB schema. I don't need to connect DB.

"query workload over the xml document" means different query will lead
to different RDB schema
even xml file is the same. I think that I should make query specific
algorithm for this.

What is JDOM/JDBC quick version ? Can I get it?

Thanks

Reply to this Message

David Harper - 25 May 2004 19:39 GMT

> For starting, I am looking for Java sauce code( XML - > RDB schema).
> And then I will make a query specific algoritm and use it with Java
[quoted text clipped - 4 lines]
> 1) Is there a java mapping programe (an xml file to a database)?
> 2) Is there any available algorithm to use for this?

Google is your friend. Try Googling on "java xml dbms mapping" and
you'll be pleasantly surprised at all the options open to you, both
commercial and open source.

David Harper
Cambridge, England

Reply to this Message

Andy Dingley - 26 May 2004 15:24 GMT

> One of the proposed ways of storing XML is to "shred" the structure of
> the XML document and insert it into a relational DBMS.

Boring !

Look at a more interesting data model, like RDF. Look at some
exciting sort of database model other than RDBMS. But "Store XML in a
COTS RDBMS" has been done to death any number of times over the last
half-decade.

Reply to this Message

Looking for Java mapping programe(XML --> Relatinal database schema)

Free Magazines