Solar-B/EIS Catalog Requirements

EIS RDBMS Requirements	CDS Database System
Compatible with SQL OS independent Secure Import/Export flat ASCII files Handle over 1 million observations (over 3 year life)	Yes, relational database but requires translation (PERL/C) Yes, Unix/Linux, Windows (95/98/2000...) Yes, can run on a secure server and password/write protected Yes, CDS remote planning is handled this way CDS catalog currently has over 100,000 records

EIS Interface Requirements	CDS Catalog System
Administrator Interface Allow automatic updates from planning tool Allow manual editing Distinguish between planned and asrun Import/Export flat ASCII files Rigorous error checking and logging	Automatic updating during FITS file generation Command and widget-based DB editing tools exist Planned and asrun entries kept in separate databases Import/Export files not actually used (done on the fly) Error checking performed (study/raster validity, modes, etc)
User Interface IDL GUI Allow user query, searching, and browsing Read, extract, & load FITS files Provide access to QL software Interface with other instrument catalogs	IDL GUI exists - XCAT User query, searching, and browsing performed via point & click or text entry Linked to CDS file system for access to FITS files Linked to IDL QL software Interface with other instrument catalogs not implemented

Some additional info about CDS (aka, UIT) database system:

Recent documentation:
http://hrssun.gsfc.nasa.gov/swg-v2_1/online_swg/node183.html
http://solg2.bnsc.rl.ac.uk/swnotes/cds_swnote_10.ps
Can support over a million records (e.g. Guide Star catalog has 25 million entries)
Search speed depends on how items are sorted. Indexed item searches (catalog number, study/raster id) are very fast: scale as ~ log(n). For example, search on Bright Star catalog entry ~ 1 sec on Ultra-2. Non-indexed item searches (e.g. science objective) are linear and slow
WWW interface exists: http://solg2.bnsc.rl.ac.uk/atlas/search.shtml

Catalog consists of several related files
Example of ASRUN Catalog Catalog of ASRUN studies 2 main.dbd -> headers 6 main.dbh -> headers 3408 main.dbf -> metadata 2816 main.dbx -> index Catalog of corresponding rasters with each study 2 fexperiment.dbd 13816 fexperiment.dbf 6 fexperiment.dbh 2784 fexperiment.dbx 1 fexperiment1.dbd 2160 fexperiment1.dbf 2 fexperiment1.dbh 2784 fexperiment1.dbx 2 fexperiment2.dbd 9480 fexperiment2.dbf 6 fexperiment2.dbh 14520 fexperiment2.dbx ==> approximately 55MB total file size, with over 100,000 records

Sample DB Catalog header files
#title CDS MAIN as-run database (study level) - Version 3 #maxentries 100000 #items PROG_NUM I*4 Study counter number PROG_ID I*2 Multi-observation program ID number PROG_IND I*2 Index when study is repeated via N_REPEAT_S STUDY_ID I*2 Study ID number STUDYVAR I*2 Study variation index OBS_PROG C*8 Name of the study DETECTOR C*1 Either G for GIS, N for NIS, or B for Both SCI_OBJ C*50 Science objective SCI_SPEC C*50 More specific science objective CMP_NO I*2 Campaign number OBJECT C*3 Code for object observed OBJ_ID C*6 Object identification DATE_OBS R*8 Date/time of beginning of observation DATE_END R*8 Date/time of end of observation OBT_TIME R*8 Onboard date/time of beginning of observation OBT_END R*8 Onboard date/time of end of observation XCEN R*4 Center of instrument field-of-view in solar X YCEN R*4 Center of instrument field-of-view in solar Y ANGLE R*4 Angle of instrument relative to solar north IXWIDTH R*4 Width of field-of-view in instrument X IYWIDTH R*4 Width of field-of-view in instrument Y SEQ_FROM I*4 Start of range of observing sequence numbers. SEQ_TO I*4 End of range of observing sequence numbers. COMMENTS C*1 Either Y or N DATE_MOD R*8 Date and time when catalog record was last modified. #index PROG_NUM sort DATE_OBS sort DATE_END sort #title CDS EXPERIMENT as-run database (raster level) - Version 3 #maxentries 100000 #items MAIN_PTR I*4 Pointer to MAIN database SEQ_NUM I*4 Sequence number OBS_SEQ C*12 Observing sequence COUNT I*2 Number of repeated observing sequences SEQ_IND I*2 Sequence index RAS_ID I*2 Raster ID number RAS_VAR I*2 Raster variation index EXPTIME R*4 Exposure time OBS_MODE C*20 Observing mode DW_ID I*2 Data window ID number OBT_TIME R*8 Onboard date/time of beginning of observation OBT_END R*8 Onboard date/time of end of observation XCEN R*4 Center of instrument field-of-view in solar X YCEN R*4 Center of instrument field-of-view in solar Y ANGLE R*4 Angle of instrument relative to solar north IXWIDTH R*4 Width of field-of-view in instrument X IYWIDTH R*4 Width of field-of-view in instrument Y INS_X0 R*4 Instrument origin pointing (legs) in X INS_Y0 R*4 Instrument origin pointing (legs) in Y INS_ROLL R*4 Instrument roll angle SC_X0 R*4 Spacecraft X pointing SC_Y0 R*4 Spacecraft Y pointing SC_ROLL R*4 Spacecraft roll WAVEMIN R*4 Minimum wavelength observed WAVEMAX R*4 Maximum wavelength observed #index MAIN_PTR sort/index #pointers MAIN_PTR main