RWP04: Registry Replication

[Tony Linde]

Hi Wil,

> So why not just use the SQL

The SQL does not exist. The query is derived from a set of drop-down boxes
on a form, not just typed in. It would be more work for the portal workflow
component to construct the SQL and for the registry to parse it and amend it
to whatever database schema is used than to take in a generic query
structure in xml form and turn that into the appropriate SQL (or whatever)
for the way that the registry is stored.

> Also I feel a WebService is the best way to access something 
> like this - making it easy to build registry queries into any 
> other apps we are making...

We are using web services (and later, grid services).


Cheers,
Tony. 

> -----Original Message-----
> From: Wil O'Mullane [mailto:womullan at skysrv.pha.jhu.edu] 
> Sent: 30 April 2003 14:31
> To: Keith Noddle
> Cc: Ray Plante; IVOA Registry mailing list
> Subject: Re: RWP04: Registry Replication
> 
> 
> 
> > we have a simple example XML query (below) upon which I 
> would welcome 
> > everyone's comments. We are looking into XQuery/XPath, but 
> that might 
> > not be appropriate for the current iteration of AstroGrid. 
> Again, your 
> > comments would be welcome.
> 
> So why not just use the SQL - it is already a fairly standard 
> query language ? Converting the query to XML just for the 
> sake of having XML seems rather pointless. If we are 
> converging on the full/private model then the schema's of the 
> full registries should be the same. Now running ahead a 
> little assuming the obvious implementation for a searchable 
> set of records is to use a relational database it would 
> process SQL directly.. we have been playing with this a 
> little and made a web service to support a 
> predicate  like " Publisher like'%Roy%' and Subject like 
> '%Optical%' or Subject like '%Radio%' "
> 
http://sdssdbs1.stsci.edu/nvo/registry/Registry.asmx

Normally we would expect this to be called in code although you may invoke
it using a form  also
http://sdssdbs1.stsci.edu/nvo/registry/Registry.asmx?op=QueryRegistry

 
http://sdssdbs1.stsci.edu/nvo/registry/Registry.asmx/QueryRegistry?predicate
=Publisher+like%27%25Roy%25%27+and+Subject+like+%27%25Optical%25%27+or+Subje
ct+like+%27%25Radio%25%27

Also I feel a WebService is the best way to access something like this -
making it easy to build registry queries into any other apps we are
making...

wil