Difference between revisions of "Moller Results Database"

From Hall A Wiki
Jump to: navigation, search
Line 1: Line 1:
 
Here is a link to a database for Moller runs information compiled for PREXII [https://userweb.jlab.org/~jonesdc/MollerRunsDB.sql]
 
Here is a link to a database for Moller runs information compiled for PREXII [https://userweb.jlab.org/~jonesdc/MollerRunsDB.sql]
  
−
This is an sqlite3 database. To run it type at the command line
+
This is an sqlite3 database. To access it type at the command line
 
   $sqlite3 MollerRunsDB.sql
 
   $sqlite3 MollerRunsDB.sql
 
   sqlite>
 
   sqlite>
 +
 +
To make output readable use
 +
  sqlite>.mode column
 +
  sqlite>.headers on
  
 
There are 3 tables available:  
 
There are 3 tables available:  
Line 118: Line 122:
 
   );
 
   );
 
</pre>
 
</pre>
 +
 +
Example: get left and right singles, coincidence and accidentals, beam current, trigger thresholds and trigger_type in addition to measured asymmetry during the Q1 scan
 +
  sqlite> SELECT moller_output.run, left_singles, right_singles, coinc, accid, inj_bcm_halla, trig_thresh_ch0, trig_thresh_ch1, trig_type FROM moller_output, moller_settings WHERE moller_output.run==moller_settings.run AND moller_settings.run>17160;
 +
  <pre>
 +
  run        left_singles  right_singles  coinc      accid      inj_bcm_halla  trig_thresh_ch0  trig_thresh_ch1  trig_type
 +
  ----------  ------------  -------------  ----------  ----------  -------------  ---------------  ---------------  ----------
 +
  17161      60650        56882          6781        71          0.54          200.0            200.0            left     
 +
  17162      60738        56779          6747        71          0.54          200.0            200.0            left     
 +
  17163      61052        57153          6819        74          0.48          200.0            200.0            left     
 +
  17164      59989        56202          6692        70          0.51          200.0            200.0            left     
 +
  17165      59179        55154          6547        68          0.48          200.0            200.0            left     
 +
  17166      60948        57258          6859        71          0.51          200.0            200.0            left     
 +
  17167      61737        57944          6891        73          0.48          200.0            200.0            left     
 +
  17168      60378        56338          6663        70          0.57          200.0            200.0            left     
 +
  17169      60464        56469          6683        70          0.51          200.0            200.0            left     
 +
  17170      60630        56702          6738        72          0.54          200.0            200.0            left     
 +
  17171      60136        56268          6666        70          0.54          200.0            200.0            left     
 +
  17172      61196        57428          6822        72          0.69          200.0            200.0            left     
 +
  17173      58735        54529          6425        66          0.57          200.0            200.0            left

Revision as of 15:57, 6 August 2019

Here is a link to a database for Moller runs information compiled for PREXII [1]

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 measured asymmetry during the Q1 scan 

 sqlite> SELECT moller_output.run, left_singles, right_singles, coinc, accid, inj_bcm_halla, trig_thresh_ch0, trig_thresh_ch1, trig_type FROM moller_output, moller_settings WHERE moller_output.run==moller_settings.run AND moller_settings.run>17160;

  run         left_singles  right_singles  coinc       accid       inj_bcm_halla  trig_thresh_ch0  trig_thresh_ch1  trig_type 
  ----------  ------------  -------------  ----------  ----------  -------------  ---------------  ---------------  ----------
  17161       60650         56882          6781        71          0.54           200.0            200.0            left      
  17162       60738         56779          6747        71          0.54           200.0            200.0            left      
  17163       61052         57153          6819        74          0.48           200.0            200.0            left      
  17164       59989         56202          6692        70          0.51           200.0            200.0            left      
  17165       59179         55154          6547        68          0.48           200.0            200.0            left      
  17166       60948         57258          6859        71          0.51           200.0            200.0            left      
  17167       61737         57944          6891        73          0.48           200.0            200.0            left      
  17168       60378         56338          6663        70          0.57           200.0            200.0            left      
  17169       60464         56469          6683        70          0.51           200.0            200.0            left      
  17170       60630         56702          6738        72          0.54           200.0            200.0            left      
  17171       60136         56268          6666        70          0.54           200.0            200.0            left      
  17172       61196         57428          6822        72          0.69           200.0            200.0            left      
  17173       58735         54529          6425        66          0.57           200.0            200.0            left
Retrieved from "https://hallaweb.jlab.org/wiki/index.php?title=Moller_Results_Database&oldid=37483"