File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes XML and Related Technologies and the fly likes Relation of XML with Object-relational form Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Relation of XML with Object-relational form" Watch "Relation of XML with Object-relational form" New topic
Author

Relation of XML with Object-relational form

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
How XML is related with Object-relational form.how can you define object views corresponding to the various XML document structure and define instead-of triggers to perform the appropriate transformation and update the base data and store it in a database.

Anil

SCJP 1.5, SCEA, ICED (287,484,486)
Ajith Kallambella
Sheriff

Joined: Mar 17, 2000
Posts: 5782
XML by itself has no in-built features to support object relations. XML simply allows you to effectively represent a hierarchical data format. Since the rules are flexible, it is not difficult to comeup with a format that can be used to represent object relations too.
For example, you could represent relationships in terms of ID attributes. ie., the ID value for one entire nodeset can be used as a foreign key in another nodeset of a different XML document thereby tying together two( or more ) entities.
Employee.xml

Departments.xml

You can then write code to form a "complete 4GL object" by dereferencing the ids and doing a cross-XML lookup.
Several relational and object relational database vendors are gradually moving towards XML support. Since XML is very new, you will have to wait for some more time to really see mature XML integration paths. Oracle 8i now has the 'best' XML support that
is available out there. You can manipulate a result-set in the XML form, which means you can select,update or create table rows using an XML query.
Hope that helps,

------------------
Ajith Kallambella M.
Sun Certified Programmer for the Java2 Platform.
[This message has been edited by Ajith Kallambella (edited January 23, 2001).]


Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Relation of XML with Object-relational form
 
Similar Threads
create tables from xsd
XML "object mapping"
Please Suggest Me
can Hibernate convert an XML schema into relational database schema ?
Getting large result sets using hibernate