Home » Developer & Programmer » JDeveloper, Java & XML » How to create an data model of an Oracle to XML schema
How to create an data model of an Oracle to XML schema [message #433460] Wed, 02 December 2009 07:36 Go to next message
KJGG
Messages: 3
Registered: December 2009
Junior Member
Hello All,

I just recently joined a new job and found out the requirement is to produce a logical and physical model from Oracle10g to XML. The data currencly resides in Oracle10g and rendered to XML. The existing logical model is based on the Oracle database relationships. Is there a tool that can produce a logical and physical model of an Oracle10g to XML schema? Any suggestions are greatly appreciated. Thank you.
Re: How to create an data model of an Oracle to XML schema [message #433470 is a reply to message #433460] Wed, 02 December 2009 08:11 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
What do you mean by an "Oracle10g to XML schema"?
Re: How to create an data model of an Oracle to XML schema [message #433498 is a reply to message #433470] Wed, 02 December 2009 10:02 Go to previous messageGo to next message
KJGG
Messages: 3
Registered: December 2009
Junior Member
Hi Frank,

The data is currently in an Oracle10g database. It is exported to XML I need to create a datamodel of the relationship from Oracle database to XML. There is a logical model that also need to relate to the new Oracle to XML schema. This is a holistic approach. Additionally is there a way or tool to diagram an XML schema? Thank you.

Re: How to create an data model of an Oracle to XML schema [message #433506 is a reply to message #433498] Wed, 02 December 2009 10:30 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Sorry, but I fail to understand how one can create a datamodel for a transformation
Re: How to create an data model of an Oracle to XML schema [message #433635 is a reply to message #433506] Thu, 03 December 2009 06:47 Go to previous message
KJGG
Messages: 3
Registered: December 2009
Junior Member
Yes, I agree. I know there are some tools that will identify nd model objects to XML. I was hoping there was such a tool to show relationships from Oracle to XML and/or an XML schema. It seems I will have to do the mapping manually. Thank you.
Previous Topic: Hierarchical xml
Next Topic: Problem to load XML file into table
Goto Forum:
  


Current Time: Thu Mar 28 09:32:43 CDT 2024