XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
alessandro marzialiSubject: XQuery engines
Author: alessandro marziali
Date: 28 Apr 2004 07:32 AM
Hi,
I would like to know if Sonic Integration Workbench
supplies XQuery engine such as inner module.
I've been trying DataDirect Connect for SQL/XML and
now I want to execute XQuery statements on fetch data via SQL/XML in Java app.

Best Regards.

Alessandro Marziali.

Postnext
Alberto MassariSubject: Re: XQuery engines
Author: Alberto Massari
Date: 28 Apr 2004 08:19 AM
At 07.34 28/04/2004 -0400, you wrote:
>From: "alessandro marziali" <alessandro.marziali@enel.it>
>
>Hi,
>I would like to know if Sonic Integration Workbench
>supplies XQuery engine such as inner module.
>I've been trying DataDirect Connect for SQL/XML and
>now I want to execute XQuery statements on fetch data via SQL/XML in Java app.

Hi Alessandro,
the Sonic platform exposes an XQuery engine as part of the Sonic XML Server
module; however, given that you plan to run XQuery statements on top of a
SQL/XML layer, and assuming that you can wait a few months to deploy your
application, I would suggest you to have a look at the forecoming XQuery P1
product from DataDirect (see
http://www.datadirect.com/techzone/xml/topics/xquerysupport/index.ssp)

Hope this helps,
Alberto


Postnext
alessandro marzialiSubject: Re: XQuery engines
Author: alessandro marziali
Date: 28 Apr 2004 08:34 AM
Hi Alberto,
thanks for your quick and valuable advices.

Explaining better my needs, I have to collect
data from two different Oracle DBs. At the moment, a VB
module has been developed to migrate data from DB_a to DB_b.
At last, DB_b imposes ties on some records of DB_a.
To cut off VB module and to try to use a message service bus,
my idea is to query data in sql/xml via Oracle adapters for the two DBs;
then insert the two XML files extracted from DBs into an XML server to
finish cross data controls on the two XML files.

What do you think?

Best Regards.

Alessandro Marziali.

Posttop
Alberto MassariSubject: Re: XQuery engines
Author: Alberto Massari
Date: 28 Apr 2004 10:40 AM
At 08.37 28/04/2004 -0400, stylus-studio-xquery Listmanager wrote:
>[...]
>Explaining better my needs, I have to collect
>data from two different Oracle DBs. At the moment, a VB
>module has been developed to migrate data from DB_a to DB_b.
>At last, DB_b imposes ties on some records of DB_a.
>To cut off VB module and to try to use a message service bus,
>my idea is to query data in sql/xml via Oracle adapters for the two DBs;
>then insert the two XML files extracted from DBs into an XML server to
>finish cross data controls on the two XML files.
>
>What do you think?

As you can guess, there a lot of variables involved in such a scenario. If
the data is going to be kept and updated in the Oracle DBs, and you need to
move just a snapshot of it into a (temporary) XML representation, you
should (in the long run) use XQuery P1 from DataDirect. This will allow you
to write an XQuery that will be executed as close to the database as
possible (by decomposing the query into SQL statements) and moving out of
the database just the minimum amount of data. In the meanwhile, you can
start using the SQL/XML adapter and Saxon 7.
On the other side, if the data coming from the Oracle database is going to
be manipulated several times, in different ways, or just for a medium/long
amount of time, you should evaluate the performance improvements given by
building the XML files using SQL/XML, storing them in a native XML database
like the Sonic XML Server and using the XQuery processor built inside the
XML Server to perform the series of queries you need (taking advantage of
indexes). Keep in mind that the XQuery processor currently shipped in the
XML Server is not aligned with the current XQuery specification; because of
this, the queries you will write for this engine cannot be processed by
Saxon 7, and vice versa.
Also, in the former case, you should use the version of Stylus Studio that
ships with the XML Server, called "Integration Edition". The standalone
Stylus Studio product should be used in case you decide to write queries to
be executed under Saxon 7.

Summarizing this long message, you probably need to talk with a Sonic
representative to understand which of the technologies in our offering best
matches your needs.

Hope this helps,
Alberto


 
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.