IDL Interface to LASCO Databases

A.E.Esfandiari, S.E.Paswaters, D.Wang
Interferometrics,Inc.

R.A.Howard
Naval Research Laboratory

Session ID: P7.05   Type: poster

Abstract:

QDB is a collection of IDL routines that interfaces with a Sybase database management system through C routines to query the Large Angle Spectrometric Coronograph (LASCO) databases. IDL widgets are used extensively to display the databases, tables, columns, and on-line help. This is a fully automated process - no code modification is required to reflect database changes such as adding/dropping databases, tables or columns. Standard Query Language (SQL) is used to form the query based on the user selection. This query is then passed via Remote SHell (RSH) to two C routines that access the Sybase Open Client Database library to execute the query. The result of the query is returned in an IDL structure. Another set of IDL routines is provided to display or manipulate the data in this structure. "LASCO" is one of the LASCO instrument databases which has been relatively change-free and regularly updated with new data. It is composed of JPEG browsed images and tabular data about these images and is growing rapidly. Currently, it uses 250 MB of disk space to archive over 40,000 browsed images and related information. The database is organized into tables containing browsed images, image names, image header information, image types, image parent, image history, etc.. I report on how QDB can be remotely used to form a query, access the "LASCO" database, and capture the data.





Patrick P. Murphy
Wed Sep 11 10:09:59 EDT 1996