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