Subject:Comparing databases and XML. Author:Thomas Wnuk Date:03 May 2006 07:58 AM
I would like to compare business data in my Oracle data base with data in XML documents. Can I do that with XQuery? What would be the best solution for that?
Or do I have to make an aplication and access data with XQuery and SQL API?
Subject:Comparing databases and XML. Author:(Deleted User) Date:03 May 2006 09:54 AM Originally Posted: 03 May 2006 08:44 AM
I think there are various approaches to what you are trying to accomplish.<br>
For an XQuery based approach, you will have to use XQuery implementations, like DataDirect XQuery, to access data in relational databases. And of course, you can use XQuery also to manipulate any XML sources. <br>
Based on the format and size of data in your XML data source and in the Oracle database, you can do the comparison in memory or on disk.<br>