Star Catalogs @LCO

Star catalogs @LCO

1. Location

Database name	Physcial location	Description	Additional Info
scan	pi2:/data1/pidb/	database of scan frames - average of 3 images	recalculated nigthly
scan_single	pi2:/data1/pidb/	database of scan single images	no recalculation
aver20_2006	pi1:/data3/pidb/	database of night images - average of 20 images ( pi-pipeline )	recalculated nightly

2. Problems description

Databases are filled in the morning after night analysis is finished. The problem is that most of the analysing script require some star statistics fields like :
no_measurements, magnitude, sigma_mag, cam2_sstar_id to be recalculated.
When it was done in WAW off-line ( for 2004/2005 ) recalculation was done once and could take even 10-30 days, however now it must be
done nightly so it must have been redesigned.
It is now using script recalc_night! which is calling sql routine : ReCalcNight(NIGHT) . This routine selects all stars which have been observed on given night ( parameter of ReCalcNight procedure ) and recalculates statistics for these stars.
Currently is being tested on scan data, it should be fast enough to be executed daily , according to preliminary tests.

3. Database based algorithms

flare finder - brithness increase serach algorithm , started using script ( not yet in cron ):

on pi1 :
find_flares.sh 20060725
synchronized on heplx40 with command ( on heplx40 ) :
synch_flareevents.pl -night=2006072 -do_insert

Results of finder - retrived from pi1
nova finder on aver20 frames :
observations of objects in table InterestingObjects , plan jest taki :
1. zaladowac do bazy na heplx40 tabele interesting objects ( io_run=1 - to sa flare stars z smbad-a )
2. na pi1 trzeba puszczac ( dorobie automat ) :
  select MatchIoToPiStars( 0, 1, 120.0 );
3. codziennie synchronizowac te obiekty z tymi samymi na pi1 :
  synch_interesting.pl -type=0 -verb
4. sciagac nowe pomiary tych obiektow ( rekordy stars i measurements )
5. types of interesting objects ( field io_type ) :
  0 - flare stars ( SIMBAD )
  1 - all erruptive stars ( SIMBAD )
  2 - nova stars
  3 - ?
  ...