STAR Database Example
In the reconstruction of the FTPC tracks, the run time barometric pressure
and FTPC gas temperatures are used to adjust the drift maps. This information,
along with the other run time condition information, is collected and
archived on sc3.starp.bnl.gov during the run by slow control. Each entry in the slow
control archiver has a timestamp. These timestamps are in local time,i.e.
BNL time = EST.
run time information used in the FTPC reconstruction:
cu_tpc_gas_PT-B [mbar] - barometric pressure in STAR hall
ftpc_hdlc:t_gas_1.D [] - FTPC West gas out temperature in degree C
ftpc_hdlc:t_gas_2.D [] - FTPC East gas out temperature in degree C
Here is an example to illustrate the "timestamp"ing used in the STAR databases.
2003 RunLog Browser
==================
MPI:
Run Number 4020039
Start Time Mon Jan 20 20:23:16 2003 [ 2003-01-20 19:23:16 GMT ]
Stop Time Mon Jan 20 20:43:04 2003 [ 2003-01-20 19:43:04; GMT ]
BNL:
Run Number 4020039
Start Time Mon 20 Jan 2003 02:23:16 PM EST [ 2003-01-20 19:23:16 GMT ]
Stop Time Mon 20 Jan 2003 02:43:04 PM EST [ 2003-01-20 19:43:04; GMT ]
Slow Control Archive (only works on *.starp machines)
====================
The slow control data was archived with BNL time timestamps.
Start Time Mon 20 Jan 2003 02:23:16 PM EST
Stop Time Mon 20 Jan 2003 02:43:04 PM EST
NOTE:
02:23:16 PM EST = 14:23:16 EST
02:43:04 PM EST = 14:43:04 EST
Environment: Pressure(mbar) button
Time cu_tpc_gas_PT-B [mbar]
1/20/2003 14:23:00.000000000 1000.88
1/20/2003 14:23:59.444510262 1000.64
Gas system: Gas out T,West Gas out T,East buttons
Time ftpc_hdlc:t_gas_1.D [] ftpc_hdlc:t_gas_2.D []
1/20/2003 14:23:00.144492153 27.0257 27.4172
For the FTPC gas out temperatures, 1 refers to FTPC West and 2 refers to FTPC East.
Online Database
===============
Database Conditions_tpc on onlsun1 - table tpcGas
SELECT beginTime,PT_B from tpcGas where beginTime>"2003-01-20 19:00:00"
beginTime PT_B
2003-01-20 19:21:21 1000.88000488
2003-01-20 19:24:31 1000.64001465
Database Conditions_ftpc on onlsun1 - table ftpcHDLCTemps
SELECT elementID,beginTime,gasOut from ftpcHDLCTemps where beginTime>"2003-01-20 19:00:00"
elementID beginTime gasOut
1 2003-01-20 19:14:07 27.00000000
2 2003-01-20 19:19:08 27.39999962
Offline Database
================
Database Calibrations_tpc on robinson - table tpcGas
SELECT beginTime,barometricPressure from tpcGas where beginTime>"2003-01-20 19:00:00"
beginTime barometricPressure
2003-01-20 19:10:00 1000.63836670
Database Calibrations_ftpc on robinson - table ftpcGasOut
SELECT beginTime,gasOutEast,gasOutWest from ftpcGasOut where beginTime>"2003-01-20 19:00:00"
beginTime gasOutEast gasOutWest
2003-01-20 19:23:16 27.3999996200 27.0000000000