ASPCS
 
Back to Volume
Paper: A Generalized Mosaic-to-SQL Interface with Extensions to Distributed Archives
Volume: 77, Astronomical Data Analysis Software and Systems IV
Page: 68
Authors: Pasian, F.; Smareglia, R.
Abstract: A graphical user interface based on Mosaic, and allowing form-based access to SQL-driven relational databases, is described. The system is general, due to some simple naming conventions for database tables. This allows a description of the database structure (contents of tables, joins, and views) to be stored in the database itself, and the Mosaic pages to be prepared on-the-fly, with no need for external definition files. Furthermore, the interface allows X-Y plotting of any two numerical quantities retrieved from the database, and access to data archives distributed over Internet, following the WWW concept. Quick-look data can be displayed, and observational data can be retrieved in their original format (FITS) inside compressed tar files. All of these operations are performed on the archive hosts by proper server processes, and no additional software, besides Mosaic, is required at the user's site. The functionality of the system has been tested on a small archive of objective prism data (images and extracted spectra) and will be implemented for a distributed archive of ISM data.
Back to Volume