SiPM Database

MySQL Database At Jefferson Lab

A copy can be found in HallD-ELOG.

MySQL Server

• halldweb1.jlab.org
• login: halld
• password: the normal "halld" password as linux boxes, or ask Yi to get it
• port: 3306 (MySQL default)
• database name: halld_sipm

Tables

sipm_spec

The table stores the Hamamatsu specifications for SiPM arrays. List of columns:

• sn: Serial Number
• voltage: Average voltage at 25C (V)
• vol_var: Standard deviation in voltage of individual channels (mV)
• m_var: Variation of gain (%, from Hamamatsu spec sheet)
• dark_rate: Total dark rate (MHz)
• dr_var: Relative standard deviation in dark rate of individual channels (%)
• remark: Remarks

sipm_spec_tile

The table stores the Hamamatsu specifications for individual 3×3 mm² cells. List of columns:

• sn: Serial Number
• cell: Cell number (1-16)
• voltage: Voltage of individual channels for a 7.5×105 gain at 25C (V)
• dark_rate: Dark rate of individual channels (MHz)

sipm_data

The table stores the info of the production test. List of columns:

• sn: serial number
• time: date and time the data were taken
• temperature_a: average temperature reading from sensor A (C), bottom, upstream
• temperature_b: average temperature reading from sensor B (C), top, downstream
• filter_1: filter 1 setting
• filter_2: filter 2 setting
• frequency: pulse frequency (Hz)
• position: position of SiPM on the cooling plate (1-1 - 4-4)
• voltage_channel: channel number of HV power supply (0-15)
• voltage_25C: operational voltage at 25C given by Hamamatsu (V)
• voltage_offset: offset on bias voltage (V)
• voltage_set: set voltage (V)
• voltage_read: average read voltage (V)
• current: average current (uA)
• gate: gate width for QDC (ns)
• daq_module: V792 module used (4-20)
• daq_first_channel: V792 channel used for first cell (0 or 16)
• event: total number of events
• data_directory: sub-directory on farm work disk: /work/halld/Subsystems/SiPM/production/data/[sub-directory]
• replayed: whether the data have been replayed (-1 not replayed, 0 submitted to farm, 1 replayed, >1 replayed but will not be used in PDE extraction)
• remark: remarks

SiPM PDE table: sipm_pde

   sn: serial number
   temperature: average(targeting) temperature of for the whole set of measurements (C)
   voltage_offset: targeting bias voltage offset from nominal operational voltage (V)
   gate: gate width for QDC (ns)
   voltage: average read voltage (V)
   dark_rate: average dark rate per cell (MHz)
   dr_var: dark rate variation
   pde: average PDE
   pde_var: PDE variation
   gain: average gain (×105)
   gain_var: gain variation
   x_talk: average probability of cross talk
   xt_var: cross talk variation
   remark: remarks

SiPM PDE per CELL table: sipm_pde_cell

   sn: serial number
   temperature: average(targeting) temperature of for the whole set of measurements (C)
   voltage_offset: targeting bias voltage offset from nominal operational voltage (V)
   gate: gate width for QDC (ns)
   dark_rate: dark rate of the cell (MHz)
   pde: PDE of the cell
   gain: gain of the cell (×105)
   x_talk: cross talk of the cell