This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes XML and Related Technologies and the fly likes xml -> relational database and vice versa Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "xml -> relational database and vice versa" Watch "xml -> relational database and vice versa" New topic
Author

xml -> relational database and vice versa

Gernot Greimler
Greenhorn

Joined: Sep 08, 2005
Posts: 6
I am currently working on a ex- and import system of a huge oracle database (at least a huge part of a huge database )

i have several relational tables which need to be mapped to a hierachical system (db to xml) and back (xml to db) to have a working im- and export.

currently i am planning to do this like that:

- create a good human readable XML Scheme to have a common standard [done]
- create a relational database that is alike the XML Scheme and insert some "IDs" (primary keys for each level in the xml by using XSLT's position()) [small test done - works]

-- import --
- import rowsets by dbms_savexml in PL/SQL to the relational temporary im/export tables [small test done - works]
- fill in data from im/exporttables into livetables [not done yet - works for sure ]

-- export --
- export livedata into im/export tablemodell in PL/SQL [not done yet - works for sure ]
- export temptables by using SQLX and XDB Functions in PL/SQL [working on small test atm]

Is that the proper way to ex- and import xml into relational databases or is there a standardised way to do this.

thanks in advance for only reading this complete mess of braindump i just produced here - hope anyone is able to tell me if my ideas are good or not
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: xml -> relational database and vice versa
 
Similar Threads
Single class file to handle connect/disconnect methods for a MySQL database
Any interest in a Torque DAO implementation?
Java discourages intelligent use of database technology: Discuss.
J2EE & EJB roles in Ireland
OracleDatabaseMetaData.getColumns() returns an empty result set