Difference between revisions of "Moller Results Database"
From Hall A Wiki
| Line 1: | Line 1: | ||
| − | Here is a link to a database for Moller runs information compiled for PREXII [ | + | Here is a link to a database for Moller runs information compiled for PREXII [https://userweb.jlab.org/~jonesdc/MollerRunsDB.sql here] |
This is an sqlite3 database. To access it type at the command line | This is an sqlite3 database. To access it type at the command line | ||
Revision as of 16:09, 6 August 2019
Here is a link to a database for Moller runs information compiled for PREXII here
This is an sqlite3 database. To access it type at the command line
$sqlite3 MollerRunsDB.sql sqlite>
To make output readable use
sqlite>.mode column sqlite>.headers on
There are 3 tables available:
- moller_output: information output by the analysis script
- moller_settings: configuration setting and EPICS readbacks taken at the beginning of each run
- moller_quality: general information about the type of run and quality
To see what is available type .schema at the sqlite prompt
sqlite>.schema
CREATE TABLE moller_output( run INTEGER PRIMARY KEY, -- run number left_singles INTEGER DEFAULT 0, -- average left detector singles rate (per helicity) right_singles INTEGER DEFAULT 0, -- average right detector singles rate (per helicity) coinc INTEGER DEFAULT 0, -- average coincidence rate (per helicity) accid INTEGER DEFAULT 0, -- average accidental rate (per helicity) bcm INTEGER DEFAULT 0, -- average bcm scalar counts per helicity clock INTEGER DEFAULT 0, -- average clock counts per helicity corrected_asym REAL DEFAULT 0, -- corrected asymmetry corrected_asym_err REAL DEFAULT 0, -- corrected asymmetry error pol REAL DEFAULT 0, -- calculated polarization pol_err REAL DEFAULT 0, -- calculated polarization error analyzing_pow REAL DEFAULT 0, -- effective analyzing power Azz target_pol REAL DEFAULT 0, -- target polarization pol_left REAL DEFAULT 0, -- left detector only asymmetry pol_right REAL DEFAULT 0, -- right detector only asymmetry bcm_asym REAL DEFAULT 0, -- bcm asymmetry bcm_asym_err REAL DEFAULT 0 -- bcm asymmetry error ); CREATE TABLE moller_settings( run INTEGER PRIMARY KEY, -- run number run_type TEXT DEFAULT '', -- run type eg. beam_pol run_start TEXT DEFAULT '', -- run start date and time run_end TEXT DEFAULT '', -- run end date and time run_length REAL DEFAULT 0, -- run duration (seconds) trig_thresh_ch0 REAL DEFAULT 0, -- ch 0 (left) detector discriminator threshold (mV) trig_thresh_ch1 REAL DEFAULT 0, -- ch 1 (right) detector discriminator threshold (mV) ihwp_in INTEGER DEFAULT -1, -- insertable half-wave plate IN=1; OUT=0 target INTEGER DEFAULT 0, -- target 0=not on any target; 1=Cu 11um; 2=Fe 10um; 3=Fe 4um; 4=Fe 1um; E_beam REAL DEFAULT 0, -- Beam energy, MeV Hall A E_inj REAL DEFAULT 0, -- Injector energy, MeV E_Slinac REAL DEFAULT 0, -- South linac energy, MeV E_Nlinac REAL DEFAULT 0, -- North linac energy, MeV n_pass REAL DEFAULT 0, -- Passes Hall A bcm_avg REAL DEFAULT 0, -- Beam Current Average unser REAL DEFAULT 0, -- Current on Unser monitor bcm_us REAL DEFAULT 0, -- Current on Upstream bcm bcm_ds REAL DEFAULT 0, -- Current on Downstream bcm inj_bcm_tot REAL DEFAULT 0, -- Injector Full Current Monitor 02 inj_bcm_halla REAL DEFAULT 0, -- Injector Current Monitor Hall A bpm01_X REAL DEFAULT 0, -- Beam Position BPM01 X, mm bpm01_Y REAL DEFAULT 0, -- Beam Position BPM01 Y, mm bpm04_X REAL DEFAULT 0, -- Beam Position BPM04 X, mm bpm04_Y REAL DEFAULT 0, -- Beam Position BPM04 Y, mm bpm04a_X REAL DEFAULT 0, -- Beam Position BPM04A X, mm bpm04a_Y REAL DEFAULT 0, -- Beam Position BPM04A Y, mm q1_cur REAL DEFAULT 0, -- Quad Q1 (Amps) q2_cur REAL DEFAULT 0, -- Quad Q2 (Amps) q3_cur REAL DEFAULT 0, -- Quad Q3 (Amps) q4_cur REAL DEFAULT 0, -- Quad Q4 (Amps) dip_cur REAL DEFAULT 0, -- Dipole (Amps) tgt_angle REAL DEFAULT 0, -- Target Rotary Position(V) tgt_angle_deg REAL DEFAULT 0, -- Rotary Position in deg tgt_lin_pos REAL DEFAULT 0, -- Target Linear Position(V) tgt_lin_pos_mm REAL DEFAULT 0, -- Linear Position in mm ihwp TEXT DEFAULT '', -- Laser 1/2 wave plate rhwp REAL DEFAULT 0, -- Rotating 1/2 wave plate vwien_angle REAL DEFAULT 0, -- VWien filter angle, deg sol_phi_fg REAL DEFAULT 0, -- Solenoids angle, deg hwien_angle REAL DEFAULT 0, -- HWien filter angle, deg hel_pattern TEXT DEFAULT '', -- Helicity mode/pattern hel_freq REAL DEFAULT 0, -- Helicity frequency hel_delay TEXT DEFAULT '', -- Helicity delay t_settle REAL DEFAULT 0, -- MPS signal, usec t_stable REAL DEFAULT 0, -- Helicity window, usec bpm02a_X REAL DEFAULT 0, -- Beam Position BPM02A X, mm bpm02a_Y REAL DEFAULT 0, -- Beam Position BPM02A Y, mm mol_mag_cur_set REAL DEFAULT 0, -- AM430 Current Setpoint (A) mol_mag_cur_meas REAL DEFAULT 0, -- AM430 Measured Current (A) mol_mag_v_meas REAL DEFAULT 0, -- AM430 Measured Voltage (A) mol_mag_field_meas REAL DEFAULT 0, -- AM430 Measured Field (T) mol_mag_ramp_state REAL DEFAULT 0, -- AMS430 Ramp State mol_cooler_temp REAL DEFAULT 0, -- Cryocooler Temperature (K) mol_mag_T2temp REAL DEFAULT 0, -- Magnet(T2) Temperature(K) mol_mag_lead1_temp REAL DEFAULT 0, -- Magnet Lead #1 (T6) Temperature mol_mag_lead2_temp REAL DEFAULT 0, -- Magnet Lead #2 (T7) Temperature det_hv_ch1 REAL DEFAULT 0, -- Moller Detector measured HV ch 1 det_hv_ch2 REAL DEFAULT 0, -- Moller Detector measured HV ch 2 det_hv_ch3 REAL DEFAULT 0, -- Moller Detector measured HV ch 3 det_hv_ch4 REAL DEFAULT 0, -- Moller Detector measured HV ch 4 det_hv_ch5 REAL DEFAULT 0, -- Moller Detector measured HV ch 5 det_hv_ch6 REAL DEFAULT 0, -- Moller Detector measured HV ch 6 det_hv_ch7 REAL DEFAULT 0, -- Moller Detector measured HV ch 7 det_hv_ch8 REAL DEFAULT 0, -- Moller Detector measured HV ch 8 det_ap_ch1 REAL DEFAULT 0, -- Moller Detector measured HV Ap 1 det_ap_ch2 REAL DEFAULT 0, -- Moller Detector measured HV Ap 2 det_ap_ch3 REAL DEFAULT 0, -- Moller Detector measured HV Ap 3 det_ap_ch4 REAL DEFAULT 0, -- Moller Detector measured HV Ap 4 det_ap_ch5 REAL DEFAULT 0, -- Moller Detector measured HV Ap 5 det_ap_ch6 REAL DEFAULT 0, -- Moller Detector measured HV Ap 6 det_ap_ch7 REAL DEFAULT 0, -- Moller Detector measured HV Ap 7 det_ap_ch8 REAL DEFAULT 0, -- Moller Detector measured HV Ap 8' trig_thresh REAL DEFAULT 0, -- trigger threshold in mV trig_type TEXT DEFAULT '', -- trigger type: 'left', 'right' or 'coinc' mol_pow_sup_cur REAL DEFAULT 0, -- Moller power supply current (A) FOREIGN KEY(run) REFERENCES moller_output(run) ); CREATE TABLE moller_quality( run INTEGER PRIMARY KEY, -- run number task TEXT DEFAULT '', -- 'pol'=polarization, 'qsc'=quad scan, 'dsc'=dipole scan, 'thr'=threshold study, 'trg'=trigger study, 'hv'=high voltage study, 'ped'=pedestal, 'oth'=other quality TEXT DEFAULT '', -- 'good', 'suspect', 'bad' comment TEXT DEFAULT '', -- user input comment about run FOREIGN KEY(run) REFERENCES moller_output(run) );
Example: get left and right singles, coincidence and accidentals, beam current, trigger thresholds and trigger_type in addition to end of run time during a recent Q1 scan
sqlite>SELECT moller_output.run, left_singles, right_singles, coinc, accid, inj_bcm_halla, trig_thresh_ch0, trig_thresh_ch1, trig_type , run_end FROM moller_output, moller_settings, moller_quality WHERE moller_output.run==moller_settings.run AND moller_output.run==moller_quality.run and moller_settings.run>17160 AND task=='qsc'; run left_singles right_singles coinc accid inj_bcm_halla trig_thresh_ch0 trig_thresh_ch1 trig_type run_end ---------- ------------ ------------- ---------- ---------- ------------- --------------- --------------- ---------- ------------------- 17161 60650 56882 6781 71 0.54 200.0 200.0 left 2019-08-05 06:47:08 17162 60738 56779 6747 71 0.54 200.0 200.0 left 2019-08-05 06:51:14 17163 61052 57153 6819 74 0.48 200.0 200.0 left 2019-08-05 06:55:35 17164 59989 56202 6692 70 0.51 200.0 200.0 left 2019-08-05 06:59:34 17165 59179 55154 6547 68 0.48 200.0 200.0 left 2019-08-05 07:03:31 17166 60948 57258 6859 71 0.51 200.0 200.0 left 2019-08-05 07:07:28 17167 61737 57944 6891 73 0.48 200.0 200.0 left 2019-08-05 07:11:37 17168 60378 56338 6663 70 0.57 200.0 200.0 left 2019-08-05 07:15:37 17169 60464 56469 6683 70 0.51 200.0 200.0 left 2019-08-05 07:21:13 17170 60630 56702 6738 72 0.54 200.0 200.0 left 2019-08-05 07:25:46 17171 60136 56268 6666 70 0.54 200.0 200.0 left 2019-08-05 07:31:37 17172 61196 57428 6822 72 0.69 200.0 200.0 left 2019-08-05 07:36:15 17173 58735 54529 6425 66 0.57 200.0 200.0 left 2019-08-05 07:41:26
