home list archives users mailing list
 

Subject: Re: [Fwd: JOIN Query and Authorisation]

Date view Thread view Subject view Author view Attachment view

From: Mike Jackson (michaelj@epcc.ed.ac.uk)
Date: Feb 08, 2006 08:08

Hi Samatha,

On Wed, 8 Feb 2006, Samatha Kottha wrote:
>
> 3. Could some one provide links on how to access the filesystems using
> OGSA-DAI?

The OGSA-DAI user doc contains details about how to expose file systems
(which we refer to as file data resources) e.g:

http://www.ogsadai.org.uk/documentation/ogsadai-wsrf-2.1/doc/wsrf/deploy/DeployDataServiceResource.html

Cheers,

mike

> Amy Krause wrote:
>>> 1. How to do the JOIN of tables from two different data resource
>>> services? Databroswer is providing a facility to join the two tables but
>>> taking ages to insert the data into temp tables for tables of 64,000 and
>>> 3900 records. How can I do it in my Java program?
>>
>> In this case, it's probably best to copy the smaller table to a
>> temporary table on the other data resource and then perform the join.
>>
>> Have a look at examples/src/uk/org/ogsadai/examples/clienttoolkit/
>> DataTransportExample.java for an example on how to transport the
>> results of one query to another data service.
>>
>> You have to do the following in your java client:
>> - on service 1, select all 3900 records and pipe them to the webrowset
>> converter and then to an output stream
>> - on service 2, create a new table
>> - on service 2, deliver the results from the above output stream and bulk
>> load them into the new table
>> - on service 2, perform the join
>>
>> The client toolkit documentation will explain how to implement those
>> steps. Hope this helps!
>>
>> Amy
>>
>>
>>
>>
>> On Tue, 7 Feb 2006, Samatha Kottha wrote:
>>
>>> Hi!
>>>
>>> I am sorry to send you the questions directly but did not get any
>>> replies in users forum. But I think you might have known the solution
>>> for my problems especially 2nd (as you used the scenario : Performance
>>> Analysis of the OGSA-DAI Software) and 3rd. It would be great if you
>>> would share with me.
>>>
>>> Thank you.
>>>
>>> regards,
>>> Samatha
>>>
>>
>>
>>
>>
>>
>> --
>> ------------------------------------------------------------
>> | Dr Amy Krause Applications Consultant |
>> | |epcc|, The University of Edinburgh |
>> | King's Buildings, Mayfield Road, Edinburgh EH9 3JZ, UK |
>> | Tel: +44 (0)131 650 6718 --- email: a.krause@epcc.ed.ac.uk |
>> ------------------------------------------------------------
>>
>
>

-------------------------------------------------------------------
Dr. Michael (Mike) Jackson E-mail: m.jackson@epcc.ed.ac.uk
EPCC Tel: +(44)-0131-650-5141
WWW: http://www.epcc.ed.ac.uk Fax: +(44)-0131-650-6555

"There will be no questions." - The Parallax View (1974)

Date view Thread view Subject view Author view Attachment view