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 Received on 2003-04-30Z18:09:51