Generate DB schema and load data based on XML file?

Question

We have a large XML file with lots of data relationships and lots of data. Is there a way to generate a DB schema based on the relationships and then load the data into the schema?

Answer 1

Just write an XSLT which would generate schema in SQL.
Then write another XSLT which would generate INSERT statements.

Answer 2

Stuff like this can be found on the Oracle OTN XMLDB Forum. This one is mentioned here: Generate XML Schema from oracle tables