Harvey,
Thank you for taking the time to reply.
>
> Re your recent item in NetCDF Group Digest Thursday, 23 Feb 1995.
>
> I have developed a high-level language interface to netCDF called 'FAN'
> (File-Array Notation). Russ Rew has the code & has indicated that several of
> my FAN-based utilities are likely to be included in a future release of
> netCDF. I am spending a week in June at NCAR to work on this project.
>
> I am interested in your concept of an SQL interface to netCDF.
Actually, most of the code developed here for the three project
use SELECT statements embedded in their functions. However,
the long term intent is to provide parsing of all SQL statements
Here is the nsql_parser priority:
** Level 0 Level 1 Level 2 Level 3
** ------- ------- ------- -------
** declare select from where
** database index into group by
** create table to having
** alter insert order by
** open synonym
** close audit
** begin view
** commit drop
** delete modify
** grant
** info
** lock
** load
** output
** rename
** unload
** set
>
> This is obviously a very small subset of SQL. Can you provide details of
> syntax you want to use? It would also be useful to explain the structure of
> your netCDF files. Some sample SQL would also help to clarify what you want
> to do. Are the SQL queries done from within a program written in some other
> language? Just how much SQL & other code is involved?
The intent is to allow any netCDF file to work with this NSQL
query system. Initially the library will be built, then an
interactive query program will be built. The nsql_parser()
will use the *inq functions from the library to verify that
the NSQL statement is correct. An NSQL statements will look
like:
select variable_name from file_name where variable_name > some_value;
>
> I have never used SQL & my knowledge of it is limited. However I wonder if it
> might be possible to translate your SQL into FAN.
Yes, I will look into this.
I work in Fort Collins, about 45 minutes away from Boulder,
I would like to see you in June, exchange ideas, etc.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
John Huddleston | //////////
Computer Engineer | \(o)/ \(o)/
USDA Natural Resources Conservation Service | ()
(formerly Soil Conservation Service) | \\========//
2625 Redwing Rd., Suite 110 |
Fort Collins, Colorado 80526 | If you can't find it,
jhuddleston@xxxxxxxxxxxxxxx | it's in the CVS.
(303) 282-2477 |
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
