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

H

Heejeong Lee

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
 
G

GIMME

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 ...
 
D

David Harper

Heejeong said:
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?

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
 
H

Heejeong Lee

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
 
A

Andy Dingley

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top