XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » Comparing databases and XML.
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Thomas WnukSubject: Comparing databases and XML.
Author: Thomas Wnuk
Date: 03 May 2006 07:58 AM
Hello,
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?

Postnext
(Deleted User) Subject: Comparing databases and XML.
Author: (Deleted User)
Date: 03 May 2006 09:54 AM
Originally Posted: 03 May 2006 08:44 AM
Hi Thomas,<br> <br> I think there are various approaches to what you are trying to accomplish.<br> <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> <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> <br> Regards<br> - Srini
Posttop
(Deleted User) Subject: Comparing databases and XML.
Author: (Deleted User)
Date: 03 May 2006 10:07 AM
Hi Thomas,

I should correct my last statement -

DataDirect XQuery (DDXQ) can push part fo the query back to the relation database server and materialize only a small part into the client, the one needed in query itself.

For large files DDXQ works in streaming fashion so the input data is scanned rather the entirely loaded in memory.

The link http://www.datadirect.com/products/xquery/index.ssp has more info on DDXQ

Regards
Srini

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.